Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Burpengary, Queensland, Australia
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting .txt to Labels (Word 2000)

    I am attempting <img src=/S/brainwash.gif border=0 alt=brainwash width=15 height=15> to convert a comma delimited .txt file into a label file, print it and close it - all via VBA for Word.

    I am hoping someone can give me some hints on how to do this (much easier in WordPerfect !!).

    Many thanks in advance <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Converting .txt to Labels (Word 2000)

    Instead of VBA, consider setting up a mailmerge to the label format. For more on mailmerge follow the links at <A target="_blank" HREF=http://www.addbalance.com/word/wordwebresources.htm#mailmerge> Word Web Resources - MailMerge</A> (addbalance.com/word/wordwebresources.htm).

    Hope this helps.
    Charles Kyle Kenyon
    Madison, Wisconsin

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Burpengary, Queensland, Australia
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting .txt to Labels (Word 2000)

    Thanks Chas, I thought of this first too.

    Unfortunately this is for a client and they want to be able to press a button and have it all done for them.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Converting .txt to Labels (Word 2000)

    I believe that merges can be automated with VBA; what happens if you try to record a macro while doing a test merge?

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Burpengary, Queensland, Australia
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting .txt to Labels (Word 2000)

    Thank you everybody for your input.

    We finally managed to do the job.

    The macro written is Inelegant, but the users will never know that.

    Once again, many thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •