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.
Graham wrote:
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.
--
Dave Peterson
|