02 June 2009
Originally Posted by rtbadman
I do use MS Excel to create a data file fro MS Word "mail merge". What you need to do is the following ...
1. Copy the "line format" as a *.txt file using Notepad or like text editor.
2. Import this text file into Excel selecting semicolon [;] as the delimiter.
3. Format the text fields in Excel to what you want to use in your labels.
4. Copy this section of the Excel file into MS Word, and format as a table that can be used in the "mail merge" feature of Word.
Hope this helps. PM me if you have any questions.