ACCESS with Mail Merge

[Rueven2]

I'm in the process of developing an application where one of the outputs will be a table with names and addresses that will be used as input to mail merge fuction within Word. So far I've been able to access the mail merge thru the "RunCommand" function. The next steps to perform the marge I have been doing mannually one step at a time until the letter has been printed. I would like to automate this process so that pushing one button or pressing one command would complete the process automatically.

Can this be done and if so please advise, how I can accomplish this task.

Thank you in advance.

 

[PHV]

As a starting point you may use the macrorecorder in word and then play with the generated code.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[psemianonymous]

Self-promotion alert:

'Native' mailmerge reports - as painless as possible faq181-5088


And yes, this is exactly what you're asking for.