[JohnMike]

Dear All,

I want to complete a mail merge in word to print out address labels. The
addressing data has been entered via windows contacts on a vista pc.

Following the prescribed method I have exported the contacts to a CSV file.
Imported that to an Excel Sheet and completed the usual merge processes.

The problem lies with addresses containing 2 or more lines with in the
Windows Contacts.

These get exported in the following format name,"address line1 address
line2",state etc etc

When imported into the Excel sheet we then get

r1 name address line1
r2 address line2

Which obviously then fails to merge correctly.

I have manually edited the CSV and the Excel files to compensate for this
and get a successful merge. But this seems like hard work. Surely other users
have multi line addresses and want to use this data in word.

Please can some one advise.

--
JohnMike