Mailmerge Master for use with Excel database

[Graham]

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]

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

[Graham]

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
>