MS Word and MS Access 2000

[gsd]

I am mail merging a word document to an access (Office 2000) database. I have 2 querys I need to access to merge fields onto one form letter. Does anyone know how to merge (link) to 2 querys in one form letter. I have no problem merging with one query. I would greatly appreciate any help! Thanks gsd

 

[DougP]

You can make a third new query and add both queries to it and then use it in your Word doc.<br>
No there is no way to mail merge to 2 different data sources.<br>
could you split your doc into 2 different docs and merge one with 1 query and the other with the other????<br>
<br>
then make a Word Macro that printed them both out.<br>
<br>
the WORD doc and macro could be launched from Access like this<br>
---------------------------------------------<br>
Private Sub Command0_Click()<br>
On Error GoTo Err_Command0_Click<br>
<br>
Dim stAppName As String<br>
<br>
stAppName = &quot;C:\Microsoft Office97\Office\WINWORD.EXE c:\Mydoc.doc /Mmacroname&quot;<br>
Call Shell(stAppName, 1)<br>
<br>
Exit_Command0_Click:<br>
Exit Sub<br>
<br>
Err_Command0_Click:<br>
MsgBox Err.Description<br>
Resume Exit_Command0_Click<br>
<br>
End Sub<br>
-------------------------------------

 

[gsd]

Thank you Doug I will try it!