How do I remove duplicates in a mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mozy - 05 Jul 2005 13:20 GMT

I have been trying to work out how to do a mail merge using fields exported
from an Access database to Word. That bit worked. But does anyone know how to
remove 'duplicate' entries where a name might appear more than once in Access
but I wouldn't want to create a letter umpteen times over for the same person?

Reply to this Message

Jeff Boyce - 05 Jul 2005 15:01 GMT

Mozy

In Access, create a query that returns all the mailing merge fields. Then
change the Unique Values property to "Yes" to get unique values. This query
becomes your source for mail merge.

Good luck

Jeff Boyce
<Access MVP>

> I have been trying to work out how to do a mail merge using fields exported
> from an Access database to Word. That bit worked. But does anyone know how to
> remove 'duplicate' entries where a name might appear more than once in Access
> but I wouldn't want to create a letter umpteen times over for the same person?

Reply to this Message