Solved

Passing field data from Access to Word Bookmarks

Posted on 2008-10-22
3
252 Views
Last Modified: 2013-11-29
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.
0
Comment
Question by:cebaker75
3 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 125 total points
ID: 22778716
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
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 125 total points
ID: 22778725
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
 

Author Closing Comment

by:cebaker75
ID: 31508834
Thanks to both GrahamSkin and JDettman.  The mail merge worked well.  And the sample provided helped.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question