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,

 

[tom_willpa]

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com