Automated mail merge from Access

  • Thread starter Thread starter lindylou
  • Start date Start date
L

lindylou

I am trying to merge some data from Access to some existing word documents.
I was hoping I would be able to set them to run with the click of a button so
that the end user doesn't have to do anything complicated to get the
information to populate into word - suggestions??
 
lindylou said:
I am trying to merge some data from Access to some existing word documents.
I was hoping I would be able to set them to run with the click of a button
so
that the end user doesn't have to do anything complicated to get the
information to populate into word - suggestions??
Click to expand...

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....
 
lindylou said:
I am trying to merge some data from Access to some existing word documents.
I was hoping I would be able to set them to run with the click of a button
so
that the end user doesn't have to do anything complicated to get the
information to populate into word - suggestions??
Click to expand...

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