Word Document into Report

[mounty76]

OK no worries, wasn't sure if you could use VBA to make actions of another program to remove the manual part of printing to pdf.....is really only a minor thing and not to worry, thanks again

 

[arnelgp]

exercise is good for the heart!
you can use the shortcut, Ctrl-P, to print.

 

[Pat Hartman]

As I said, I don't use mail merge for a variety of reasons but @arnelgp , isn't there a way to just send the merge document directly to the printer? You could then have two buttons. View and print.

 

[The_Doc_Man]

I believe you can send an opened document to the printer with DoCmd.Printout, but it has to be the currently active object, which gets tricky about context. I.e. if this is a WORD document created through a Word App Object, you must use the .Printout in that context, e.g. print it using <<WORD-document-object>>.Printout

Document.PrintOut method (Word)

Office VBA reference topic

docs.microsoft.com