mail merge from an excel workbook

[Mikkik]

I have an Excel sheet which has cells containing a complete address. ie each
cell contains the name, address and post code of each outlet rather than each
detail being in a different cell. Therefore I have 900 addresses contained
within 900 cells. I want to write to all 900 addresses and need to import the
addresses using mail merge or similar. I cannot figure out how to achieve
this. Can anyone assist? Many thanks,

 

[Doug Robbins]

In your mailmerge main document, you would just have one mergefield, that
being the field that contains the addresses.

If that doesn't work for you, copy and paste the data into a Word document
and use the technique in article "Convert Labels into Mail Merge Data File"
on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/convert_labels_into_mail_merge.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP