I don't use Vista so I don't know anything about the Vista contacts manager.
From the information I can find on the web, it would seem that exporting to
CSV is the only practical solution for using the data - much as was the case
with the old Windows Address Book. If you have Outlook (part of Office) then
that would be a way forward. Otherwise mail merge is going to be a clumsy
process as you have found.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
JohnMike wrote:
Hi Graham,
Many thanks for this information and your help. I may of course be
being stupid (which is quite likely). However on my Vista Machine I
do not have anything called Outlook. I have windows mail and windows
contacts and other utilities like calander etc. This has been being
used in place of outlook.
I assumed that these were standard vista utilities taking the place of
outlook.
I will see if I can track down the office cd's with a view to
installing outlook, but I do not think that any were supplied with
the machine. From your notes it appears that merging from the outlook
contacts is the best solution.
I will let you know how I get on.
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.