Access - Word Merge, Can't get merged doc to print

[WildHare]

OK, 98% of the way there.

Have a simple system to sent some Access data to a Word document, do a mail merge, and print.

Everything works except the print.

I thought I'd read that once you do a "MailMerge.Execute", the "merged document" becomes the ActiveDocument, so if you do a

.MailMerge.Execute
ActiveDocument.Printout

the newly merged document with DATA in the field code spots will print - but what prints for me is the original one with the field codes, not the merged result letter.

What am I missing?...

Thanks!

Jim


--------------------------------------
"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman
More Access Help:

http://www.jmhare.com/AccessForum

http://www.jmhare.com/wildhare2.htm

 

[WildHare]

Update : Never mind - found it. The Documents collection puts the MERGED document in as Documents(1), and the original as Documents(2) - I thought it was the other way around, when I tried Activating Documents(2)...



--------------------------------------
"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman
More Access Help:

http://www.jmhare.com/AccessForum

http://www.jmhare.com/wildhare2.htm

 

[PHV]

If you don't want to save the merged document:
.MailMerge.Destination = wdSendToPrinter
.MailMerge.Execute

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

 

[WildHare]

PHV - yeah, I don't save it, so your tip saves a step - Thanks!

--------------------------------------
"For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman
More Access Help:

http://www.jmhare.com/AccessForum

http://www.jmhare.com/wildhare2.htm