I have two tables. One is a list of clients, and one is a list of data to be sent to all clients. I want to use Word to mailmerge the two together, except that there doesn't seem to be a way to do it!

Any ideas on the best way to go about this? Should I create a multipage document, and then send that via mailmerge? (Can I build the mailmerge document dynamically?)

I already have labels for the clients, so maybe I could generate the mailmerge with the data, and then dynamically add merge fields for the clients?

I hope that I don't have to use VB to do all the merges, but that's the way I see that it can be done.

Thanks for the help!