02 June 2009

Quote Originally Posted by rtbadman View Post
Hi everyone, I received the address list today. Can anyone tell me how to import the "line notation" of the address list into Excel. I'm signed up for the max and am hoping I won't have to hand address my postcards.
Thanks, Roger
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.

Regards,
Darwin