Email merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jordan - 03 Nov 2005 23:49 GMT

I have a list in Excel. The first column is a name. The name can be used
more than once and then the other columns are information about the name.
Example:

Jordan 10/12/2005 A
Jordan 10/13/2005 B
Jordan1 10/14/2005 C
Jordan1 10/12/2005 D
Jordan2 10/13/2005 E

I merged this in Word but it sends 2 emails to Jordan, 2 to Jordan1 and 1 to
Jordan2. Is there a way to have one email sent based on the name being the
same. So the email to Jordan would be:

10/12/2005 A
10/13/2005 B

The other problem that I have is that I need the emails created and then for
the user to add the email address.

Reply to this Message

Doug Robbins - Word MVP - 04 Nov 2005 06:19 GMT

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

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

How to Work Around Duplicate Names in Mail Merge Data

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

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 have a list in Excel. The first column is a name. The name can be used
> more than once and then the other columns are information about the name.
[quoted text clipped - 18 lines]
> for
> the user to add the email address.

Reply to this Message