mail merge from an excel workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mikkik - 03 Oct 2004 15:03 GMT

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,

Reply to this Message

Doug Robbins - 03 Oct 2004 22:16 GMT

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

Signature

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

>I have an Excel sheet which has cells containing a complete address. ie
>each
[quoted text clipped - 5 lines]
> addresses using mail merge or similar. I cannot figure out how to achieve
> this. Can anyone assist? Many thanks,

Reply to this Message