Mail Merge

[DCV0204]

I am wanting to click on a button to run "Query1" and then "Query2" mail merge my table named "Generate_Letter" to a word document I have linked to the table and final print the letters.



Is any or all of this possible?
Thanks,

[RuralGuy]

Absolutely! The Super Easy Word Merge of Albert's can be modified to do this: http://www.kallal.ca/msaccess/msaccess.html

[DCV0204]

Did not work.
My Table name is "Generate_Letters"
I named the button "GLtr"

Here is the code I have:
Private Sub GLtr_Click()

Me.Refresh
MergeAllWord ("select * from Generate_Letters")

'Note that you can use a condtion in the above sql

End Sub

Please help.

[RuralGuy]

Does Albert's example work?

[DCV0204]

As I stated above, it did not work.

I did try the code again this morning and it still did not work.

The previous post has the code I used; can you help?
Thanks.

[DCV0204]

Thanks for your help.

I have been doing some research and the following code works:

Private Sub GLtr_Click()
Me.Refresh
Application.FollowHyperlink "P:\ALL MCC Info\Projects\NF_Extract10-19-2011\PRV-9004-R.docx"

'Note that you can use a condtion in the above sql
End Sub

Thanks.

[RuralGuy]

Sounds like you nhave it sorted. Great!