Programming mail merge from Access

[Diane1100]

Group,
I am somewhat familiar with ACCESS programming, definitely not an expert, but I can find my way around and maintain other's code, just haven't created from ground up. I'm also familiar with VBA coding, I do quite a bit in MS WORD, but now I'm stumbling around in Access 2010 and trying to accomplish a simple task, creating envelopes from data in a table. If I "export" to mail merge, all works, but I want to take the steps:

1. export
2. word merge
3. etc...etc.....and put this in code.

My thought is vba code behind the "print envelope" button from my Access form, I'm assuming the on-click event. Am I correct that the only way to get my envelopes is a mail merge, and if so, I'm looking for anything to get me started with "VBA mail merge" in Access. I've been trying to test this with a macro function, but not getting anywhere with this.
Any getting started hints would be appreciated.
Thanks,
Diane1100

 

[jdraw]

There's some discussion here that may be of use to you.
http://www.utteraccess.com/forum/Fully-Automate-Mail-Merge-t1965369.html

 

[Diane1100]

jdraw,
This example worked perfect for me, a few modifications needed but worked great!!
Many thanks for getting me started.
Diane