Automate a word mail merge

[jarra_mackem]

I have created a database which is used for risk assessments,

What im hoping to accomplish is

the auto-opening of a pre-set mail merge document,

And either merge the results straight to the printer or leave the file open so the user can specify a save point. Basically i dont want any prompting from word/ access. I just want the resulting document

I can open the word documen , but am struggling to automate the mail merge.

Any help greatly appreciated

 

[Guus2005]

Try this link. http://www.helenfeddema.com/CodeSamples.htm
Helen Feddema has lots of Office 2 Office samples!

 

[durexlw]

I know office 2007 has an option to do a mailmerge automatic: Open your table/query. Then under External Data --> More --> Merge it With Microsoft Word. It allows you to open existing document or create new ones on the fly and store your settings afterwards.

I never used it in VBA, but you probably can, open a query and execute the mailmerge using the menuitem command. Never did it, but should work.