Mail merge to word from access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 31 Oct 2009 21:45 GMT

I have a access database, i havea form loaded with a customers name
and address

I have about 10 Standard letter writen in Word, what i would like to
do is a way on the access form that lets me clcik a button that it
automaticl mail merge with the word document so it put the name and
address and then prints out the word document

I require this to be done very fast and automaticlay

can any one point me in right direction

Reply to this Message

Albert D. Kallal - 31 Oct 2009 22:17 GMT

>I have a access database, i havea form loaded with a customers name
> and address
[quoted text clipped - 7 lines]
>
> can any one point me in right direction

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....

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message