Mail Merge - file has duplicate data

E

esfaber

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
 
K

KC Rippstein hotmail com>

Try using AutoFilter (on a small test group first). I think it will do the
trick.
 
E

esfaber

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.










- Show quoted text -
Click to expand...

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
 
Top