Automate Word Mail Merge From Access

[puppy39]

I have a main form with a subform. User selects the state and the suform displays the contacts for that state. I would like to add a button to the main form called "Mail Merge". When users click on this button it will then create a new mail merge with microsoft word to create labels. I read the FAQ but I am new to this and it is very confusing since the instructions are based on you having extensive knowledge in VB Code which I do not.

 

[white605]

Two ways to approach this.
1. Easy way - Since your data is filtered, rite it to a seperate file that word mail merge likes say thismerge.mdb or thismerge.csv Now, record a macro with word to do the merge with the proper results. Last, call word with the macro to execute.
2. hard way - automate word thru acess vba and refer to the objects to get the merge to execute on your mdb with a filter to get only the records you want.



This old world keeps spinning round - It's a wonder tall trees ain't layin' down