opening a word mail merge doc in access to oprint out a single record

[Dave]

Hi All,

Working for a small UK charity that is using access 2003 to add address of
clients.

We only add about ten a day then run a word letter doc that links to a query
in access to produce mail merge letters for all the clients. Works OK but
user want to have a button on the access input form so they can type in an
address then print off a single letter.

What kind of code should I have on that button that will open a word merge
file and merge the just inputted info on screen to print off a single
letter.

Any help appreciated!
Cheers, David

 

[Jeff Boyce]

Steve

How does your solution address the OP's request for a way to "type in an
address then print off a single letter"? If you feel you have a better
approach than satisfying the OP's request, consider posting your rationale,
to help the OP understand the advantages of your approach.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Albert D. Kallal]

I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the following page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try. While it does require you to add some code, many of my
users have been able to get this to work by just following the
instructions...even with zero coding experience....

 

[pietlinden]

Hi All,

Working for a small UK charity that is using access 2003 to add address of
clients.

We only add about ten a day then run a word letter doc that links to a query
in access to produce mail merge letters for all the clients. Works OK but
user want to have a button on the access input form so they can type in an
address then print off a single letter.

What kind of code should I have on that button that will open a word merge
file and merge the just inputted info on screen to print off a single
letter.

Any help appreciated!
Cheers, David

Albert Kallal's "Super Easy Word Merge" will do that. You can merge a
single record or a selection.
Here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html