Mail Merge with MS Access

[Imran Ghani]

Im using MS Access 2007 and I want to develop an application by which When I
merge my data with MS Word through MS Access 2007, the letters should be
generated automatically by programming and saved somewhere at our given
location, maybe by the name of the client, and the database field for the
said task when accomplished should be updated as the task in done. Please do
guide me with your valuable experiences.
Regards,
Thankx.

 

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

 

[Imran Ghani]

Thank you very much indeed for your great help. I was able to develop my
letters successfully with this utility. But Im not able to convert the format
of date of my database table dates according to my specificationss on my word
letter. Please do guide me about how to change dates format on the merge
letter. Thanks again.