Word 2010 making labels using Mail Merge with a Word doc as a source file
07/25/2014 2514 views
Ok, so I've got a customer who has over 500 addresses typed into a Word document, where it is formatted simply as:
for 60 pages. Now, they want to take those names and put them onto labels. Is there any way to do this with Word's mail merge? I spent a couple hours looking into it but due to the fact that it's just a list of text in Word, the mail merge feature was unable to figure out where each Field / Record is supposed to be. It's reading each line as having a return after it ("enter") so you can't accurately use that to denote where one record ends and the next begins. I tried saving it as a .txt to eliminate that, but it doesn't doesn't read the information from the .txt file properly either. I also tried adding a character to the end of each line ("-") to denote the end of each field and then used "enter" to denote the end of a record. That didn't work either and it just gave me errors and/or only random bits of the address would appear on a label / lots of blank labels (even if this worked it means adding hundreds of dashes to the original doc). I told the customer that they are better off just copy + pasting all the info themselves (their list is kind of wonky anyway; some addresses are 3 lines while some are like 8 and include phone numbers and so forth), however they are insisting there must be a way to automate it, so I'm asking here there in case there is some way to make this magically work without spending more time and effort to edit the way every single address has been entered to make it such that Mail merge can work with it, or to move it into a spreadsheet or database which would theoretically be read properly by the mail merge feature.
We have Wordperfect X5 as well, however the merge utility there seemed much more basic and I couldn't do anything with it in this case.