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,
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,
Absolutely! The Super Easy Word Merge of Albert's can be modified to do this: http://www.kallal.ca/msaccess/msaccess.html
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.
Does Albert's example work?
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.
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.
Sounds like you nhave it sorted. Great!