Windows Contacts?
Word uses Outlook Contacts as its address book and merging from Outlook
contacts is fairly straightforward
http://www.gmayor.com/mailmerge_from_outlook.htm
Word can use a variety of data sources - including csv files - directly. It
is not necessary to export them to Excel. In any case you would have fewer
potential problems if you used a Word table rather than an Excel table - see
http://www.gmayor.com/convert_labels...mail_merge.htm
If the result of your exported data source is that you have some fields that
contain two pieces of information then what you see is how it will merge.
Have you tried merging the data file without converting it?
See
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
JohnMike wrote:
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.