Access To Word Mailmerge - One step only Office 2007

[Gary S]

I have setup a Mailmerge that is run from Access. The process works like
this: 1) The proper record is selected in an Access form which automatically
starts the process. 2) Word is called up automatically, it shows both the
template and the doument with the proper data in it. 3) Access is closed
automatically. 4) The user then needs to close the mailmerge template. 5)
The document with the proper mailmerge information inserted from Access is up
on the screen. At this point a shortcut is triggered by the user that adds a
document of the users choice to the end of the current document. 6) At this
point the user prints the document and the process is done. 7)The process
takes about 5-10 seconds.

Here is my question: my client want to be able to push a button from Access
and everything will be done except selecting the document to insert at the
end of the mailmerge document. I have tried several different approaches.
Each is not a single step process, some have warning messages that show up,
etc. Is it reasonably possible to come up with a perfect solution here? Is
there a perfect solution out there somewhere. All the solutions I have seen
are not "perfect".
I would appreciate your candor and help.

 

[ryguy7272]

Sounds like you've already doe a lot of work on this and what you're trying
to accomplish seems reasonable. If you're to the point of Warning Messages,
and that's your only roadblock now, why not temporarily disable those
messages?

docmd.setwarnings false

but you should turn it on again after the update query finishes by:
docmd.setwarnings true

So . .
Public Sub DeleteSomething()
docmd.setwarnings false
.. . . your code in here . .
docmd.setwarnings true
End Sub

 

[Gary S]

Thanks for the reply. Sorry I was not clear. I was referring to security
warnings and the such. The real issue here is that it seems to me that you
could almost come up with the perfect mailmerge in earlier versions of
Office, but in 2007 that does not seem to be the case, could someone confirm
that train of thought or direct me to an automated mailmerge method in Office
2007.

 

[Mark Andrews]

I use albert Kallals word merge code, no warning messages. Should do what
you want or at a minimum give you a way to appproach word merging.
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Just needs a tiny tweak if you are using .docx extentions instead of .doc

HTH,