Mail Merge - file has duplicate data
 

Hi,

I have a relatively large database in Excel (1700 names) most of the
listings are duplicates but I need to store it that way for internal
use (watching for trends in team members etc.)

I would like to send everyone listed in the database an email using
Outlook and a mail merge but I don't want people to receive the email
more than once.

Is there a way to do this?

All I can think of is doing a "Save As" and then manual deleting the
names.

Thanks for your help!
Elizabeth

Mail Merge - file has duplicate data
 

Try using AutoFilter (on a small test group first). I think it will do the
trick.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


" wrote:

Hi,

I have a relatively large database in Excel (1700 names) most of the
listings are duplicates but I need to store it that way for internal
use (watching for trends in team members etc.)

I would like to send everyone listed in the database an email using
Outlook and a mail merge but I don't want people to receive the email
more than once.

Is there a way to do this?

All I can think of is doing a "Save As" and then manual deleting the
names.

Thanks for your help!
Elizabeth

Mail Merge - file has duplicate data
 

On Mar 14, 1:46 pm, KC Rippstein hotmail com <kcrippstein<atdot
wrote:
Try using AutoFilter (on a small test group first). I think it will do the
trick.
--
Please remember to indicate when the post is answered so others can benefit
from it later.



" wrote:
Hi,

I have a relatively large database in Excel (1700 names) most of the
listings are duplicates but I need to store it that way for internal
use (watching for trends in team members etc.)

I would like to send everyone listed in the database an email using
Outlook and a mail merge but I don't want people to receive the email
more than once.

Is there a way to do this?

All I can think of is doing a "Save As" and then manual deleting the
names.

Thanks for your help!
Elizabeth- Hide quoted text -

- Show quoted text -

Hi,

Thanks!!!!

I used AutoFilter and then copied only the visible cells onto a new
sheet.

Whew - hours of work saved.

Thanks so much!
Elizabeth