I use this code in my Excel based VBA project to automate a mail merge. An Excel worksheet provides the data.
This code, in it's current form, works. It opens my mail merge document, merges the information based on the report's SQL string, saves the file and leaves it open in a minimized window in the taskbar.
Please Login or Register to view this content.
Two questions ...
1) what do I need to add if I want to print this merged document in addition to having it simple open up to be viewed?
2) The document is in a minimized window. After maximimizing it, the user has no control of the document ... toolbar buttons don't work, unable to edit the document. You have to minimize it, then maximize it again before the document is accessible. What's up with that?