Mail Merge Button on Word

[Guest]

I also accidentally posted this in the General Questions section...

I don't do much programming, and I've run into a problem. What I would like
to do is have the user open a form, entering/choosing information, then
clicking on a command button to merge the record into a Word mail merge
template. Ideally, I would like this to be done all in one button.

I've tried the "Merge Single Word" code, however, in order for the code to
work for me, the record source for the form has to be set to the table/query
that will be the record source for the mail merge template. When I set the
form's record source to the query that needs the information entered on the
form, the form fails. When I set the form's record source to a table
generated from the query that needs the information on the form, I get an
error message that the record or database is locked.

I'm so frustrated because I am so unfamiliar with visual basic. I have
searched through the community groups and newsgroups, but haven't found
exactly the code I need. When I do find some code, it's always missing
something that I can't figure out. If anyone could help me I would
appreciate it. I will be happy to provide any additional information.

Thanks!

 

[Arvin Meyer [MVP]]

Answered in the other group (I saw it there first) Briefly, have a look at:

http://www.datastrat.com/Code/WordMerge.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access