Mailmerging Using Excel as Source

  • Thread starter Thread starter SRC
  • Start date Start date
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
 
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
--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tabbing order in Excel form 2
Compare then combine data, then mailmerge with Word 4
excel data not avilable for mail merge 1
Excel 2007 - combining worksheets to use for a mail merge 1
How do I move contact info from excell to Outlook? 1
Transpose column into rows for use as mailmerge data 5
Mailmerge Master for use with Excel database 2
Using Worksheet as Data Source 1

Back
Top