mail merging to word 1

[jacq]

Hi

I want to do a mail-merge from Access to Word.
The user would then click merge to printer and click ok to print.
I want to automate this, but am having problems
I tried saving a macro in Word, called autoexec to perform the said task, but I'm getting an error.

I'm running this code from Access

DoCmd.OutputTo acOutputQuery, "labels", acFormatRTF, "\\saturn\applications\LMC_labels\datamark_labels.rtf", False

Call Shell("C:\Program Files\Microsoft Office\Office\WINWORD.EXE \\saturn\applications\LMC_labels\datamark.doc", vbMaximizedFocus)

Application.FollowHyperlink "\\saturn\applications\LMC_labels\datamark.doc"

I think the problem is that the autoexec macro in word is running before Access has loaded word

Any ideas?
Can I send commands from Access, such as
mergetoprinter

Thanks
Jacq

 

[CPUburn]

hi jacq

there's no need to make it that complicated. forget the word macro, all you need is access: check out the following article on the Microsoft support database, it should get you on the right track:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q159328