Basing a word mail merge on teo independent queries?

[Guest_imported]

I am trying to create a mail merge form letter than gets information from two totally independent queries (job information and project proposer)- I cannot get Word to allow me to base the mail merge off of two seperate queries - does anyone have any ideas how I can get this to work. I can't do it all as one query because the two sets of data are not connected to each other in any way and can't be.

Thanks in advance,

Ray

 

[B827]

This is a total shot in the dark but would it work if you used a amster document with sub-documents. I haven't used sub documents for a long time and never tried nested mail merges so hve no idea if it will work.

The other question is are you absolutely certain there is no way of linking the queries - if you need the information on the same document there must be some relationship - no? Sandy

 

[outpatient]

Try this,
Make a new query in design view. hit the query tab when it asks what tables. Choose your two queries and blammo, you're in business(theoretically) Sam Greene
anyone in need of a rock induced headache? if so

http://www.mp3.com/outpatient