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.

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

Thank you Peter - You're quite right, it is a Word document! I'll investigate
Macro's first and see how I get on.

"Dave Peterson" wrote:

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