Passing field data from Access to Word Bookmarks

I have a query in Access that pulls the data fields I need in my Word document.  How do I pass that data from Access to the Word bookmarks i have set up?  EX:  Field [Employer Name] needs to populate the Word bookmark {Employer Name}.  Any help will be greatly appreciated.
cebaker75Asked:
Who is Participating?
 
GrahamSkanConnect With a Mentor RetiredCommented:
The simple way to do that is to use mail merge and Merge fields (not bookmarks). If you haven't tried that, you might like to know that there is a mail merge wizard which is started from the Word menu (Tools/Letters and Mailings/ Mail Merge...). You can also start it from Access (Tools/Office Links/MergeIt).

If you don't want to use the mail merge mechanism, you will have to use VBA and Office Automation. Have you used that before?

0
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
cebaker,

  I've attached a sample database which has a complete Access to Word merge interface in it. Enjoy.

  Bounce back with any questions.

JimD.
mmA2002.zip
0
 
cebaker75Author Commented:
Thanks to both GrahamSkin and JDettman.  The mail merge worked well.  And the sample provided helped.
0
All Courses

From novice to tech pro — start learning today.