email merge - several records should go to 1 address

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JEG - 09 Jun 2007 08:37 GMT

I am trying to do an email merge to email authors about their articles. In
my data file, there is one record per article and sometimes an author will
have written several articles. If I do a straight email merge, the author
would get a different email for each article - but I want each author to
get just ONE email which would list all of their articles.

I have tried using the suggestions about duplicate records but that only
seems to work for merging to Word document -- as you have to set up your
document as a Directory (or catalog). This doesn't work for email merge.
Here are the links I was using: http://support.microsoft.com/?kbid=211303
and
http://support.microsoft.com/kb/302665.

Is there a way to do this same sort of thing but merging to email? I'm
using Word 2003.
Thanks so much.
Jackie

Reply to this Message

Doug Robbins - Word MVP - 09 Jun 2007 09:09 GMT

Word does not really have the ability to do such "multiple items per
condition" merges, especially directly to email. I think the only way to
achieve what you are after would be to use a purpose-specific VBA method.

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

>I am trying to do an email merge to email authors about their articles. In
> my data file, there is one record per article and sometimes an author will
[quoted text clipped - 13 lines]
> Thanks so much.
> Jackie

Reply to this Message

JEG - 10 Jun 2007 03:53 GMT

I was afraid that might be the case.

Thanks for your reply.

Reply to this Message

Rate this thread: