Mailmerging Using Excel as Source

S

SRC

Hi,

I have four separate spreadsheets of contacts and want to
use them as the data source for mail merging.

However, I need a system for tracking the mail merges I
make. I need to be able to have a date and Y/N column
which shows which contacts have been part of a mail merge
and when.

Does anyone know how I could automate this.

Help needed....!

SRC
 
D

David McRitchie

Hi Steve,
You need to have the excel worksheet as the first worksheet
for mail merge to see it. (unless, you have Excel 2003, as I understand)

Rather than 4 spreadsheets, by might do better using data filtering,
then you only need one worksheet. My page on Mail Merge is
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
--
 
Top