 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / October 2004How to import labels from a text file
Hello, I'm having a problem importing labels from a text file. The file is not csv or tab separated values. It's a plain list with names and addresses, but the only logic relation between records is that they start every "9" lines. I'm trying to import this file to word to generate labels but so far I haven't figured out how to do it. Some records have 3 lines and some have 4, depending on the address, but the 1st line of all records are systematically 9 lines away, as the example above: Name 1 Address 1-a Address 1-b Address 1-c or nothing blank (line4) blank (line5) blank (line6) blank (line7) blank (line8) Name 2 Address 2-a etc.... I could do a copy/paste, but we are talking about 3000 labels :-( Does anybody know some way around a problem like this? I'll really appreciate your help. Regards, Jorge Jump into http://www.gmayor.com/convert_labels_into_mail_merge.htm at the point it matches your data file and create a table to use as a data source.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hello, > I'm having a problem importing labels from a text file. The file is [quoted text clipped - 25 lines] > Regards, > Jorge Terrific!! Thank you so much Graham!! Actually I couldn't finish it yet because for some reason my document is not accepting to search for the ^13 code. It works find when I search for ^13, or ^13{1}, but if I search for ^13{2} or ^13{2,5} it says "Word has finished searching the document" but nothing is found :-( What I noticed is that the character, even though is found with ^13 one by one, is not displayed by Word in the same way. It shows the same character on the document but with the circle left side empty, not filled in black as when I typed "ENTER" in a standard document. Anyway I'm working around it searching the web for info. I want to than you so much for your help!!! Have a great day! Jorge > Jump into http://www.gmayor.com/convert_labels_into_mail_merge.htm at the > point it matches your data file and create a table to use as a data source. [quoted text clipped - 28 lines] > > Regards, > > Jorge You shouldn't need to strip out the blank lines before converting to a table. Just create a table with the extra columns to accommodate the empty lines then delete the extra ones later. If I understand you correctly the 'circle' is a non breaking space. If you have spaces in the empty lines, then your search for other than ^13{1} cannot work as you have not allowed for the spaces. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Terrific!! > Thank you so much Graham!! [quoted text clipped - 57 lines] >>> Regards, >>> Jorge Thank you Graham!! I got the file fixed and created the labels file based on the other instructions file on your site!! Thank you so much!! I got it done thanks to you! Have a great day, Jorge > You shouldn't need to strip out the blank lines before converting to a > table. Just create a table with the extra columns to accommodate the empty [quoted text clipped - 64 lines] > >>> Regards, > >>> Jorge Glad the web site was useful to you. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thank you Graham!! > I got the file fixed and created the labels file based on the other [quoted text clipped - 81 lines] >>>>> Regards, >>>>> Jorge Terrific!! Thank you so much Graham!! Actually I couldn't finish it yet because for some reason my document is not accepting to search for the ^13 code. It works find when I search for ^13, or ^13{1}, but if I search for ^13{2} or ^13{2,5} it says "Word has finished searching the document" but nothing is found :-( What I noticed is that the character, even though is found with ^13 one by one, is not displayed by Word in the same way. It shows the same character on the document but with the circle left side empty, not filled in black as when I typed "ENTER" in a standard document. Anyway I'm working around it searching the web for info. I want to than you so much for your help!!! Have a great day! Jorge > Jump into http://www.gmayor.com/convert_labels_into_mail_merge.htm at the > point it matches your data file and create a table to use as a data source. [quoted text clipped - 28 lines] > > Regards, > > Jorge |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.