Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

MS Word and MS Access 2000

MS Word and MS Access 2000

MS Word and MS Access 2000

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

RE: MS Word and MS Access 2000

You can make a third new query and add both queries to it and then use it in your Word doc.
No there is no way to mail merge to 2 different data sources.
could you split your doc into 2 different docs and merge one with 1 query and the other with the other????

then make a Word Macro that printed them both out.

the WORD doc and macro could be launched from Access like this
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim stAppName As String

stAppName = "C:\Microsoft Office97\Office\WINWORD.EXE c:\Mydoc.doc /Mmacroname"
Call Shell(stAppName, 1)

Exit Sub

MsgBox Err.Description
Resume Exit_Command0_Click

End Sub

RE: MS Word and MS Access 2000

Thank you Doug I will try it!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close