Emailing a Merged Catalog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin Harris - 25 May 2006 10:36 GMT

Hi,

I am trying to create a mailmerge where order acknowledgments are emailed to
customed. The data is held in a text file with these fields:

Cust Ordernum Model Qty Orddat Duedat

I would like the email to list orders per customer - for example:

Cust=Bloggs

Ordernum Model Qty Orddat Duedat
12345 BBB11 1 01/01/06 05/01/06
543 ABB2 4 01/01/06 06/01/06

etc

I can complete the merge just as i need to a 'Catalog' but can't work out
how to send it as email. If I choose the word Email merge the layout all
goes wrong.

Any ideas?

Reply to this Message

Doug Robbins - Word MVP - 25 May 2006 13:18 GMT

The only destination that is available with a Catalog type mail merge is to
a new document. If you want to send it out my email, that will have to be
done as a separate operation. Assuming that you have more than one customer
in the document produced by executing the merge, you will need to split the
document into separate documents for each customer. That can probably be
automated with a macro.

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 18 lines]
>
> Any ideas?

Reply to this Message