Access mail merge advice

[McGeeky]

Hi. I need to create a Word mail merge from an Access query. Essentially,
our users will need the abililty to change static portions of text in the
Word document and then the Access query updates the dynamic areas.

What is the best approach for achieving this with Access & Word and can you
provide advice on where to start?

Thanks

 

[McGeeky]

I should clarify that I want to be able to run this from Access; the user
provides some filter criteria in a form, clicks a button, then the Word
document is generated automatically.

Thanks!

 

[Mark Andrews]

I found the code on this page to work very well.
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com

 

[McGeeky]

Hi Mark. Fantastic - that is just what I was looking for!