Mailmerge Master for use with Excel database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large workbook of some 50 worksheets that I use as a mailmerge
database - 1 worksheet = 1 client, and may have to produce from 0-50 merged
documents per customer. The mailmerge works well, but each time I change
sheet/customer I have to alter 4 items of unique information on the mailmerge
master, unique to that particular customer. Other than setting up a separate
mailmerge master for each client, is there a simple way of updating the
mailmerge master prior to each merge ? I have all the information required
stored on a separate sheet/database.
 
I would think you could have a macro that would help you out.

But your mailmerge master is an MSWord document, I bet.

If you don't get a better answer here, you may want to post in one of the MSWord
newsgroups.
 
Thank you Peter - You're quite right, it is a Word document! I'll investigate
Macro's first and see how I get on.
 

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

Using Excel workbook as data source for word mailmerge 3
Compare then combine data, then mailmerge with Word 4
Problems with MailMerge - help needed. 1
Mail Merging: From Filtered data to Word 2
excel data not avilable for mail merge 1
Problem using excel workbook in word mailmerge 3
Question about Mailmerge and Word 1
Word Create a Phone Book using MailMerge in word 2007 0

Back
Top