Solved

Passing field data from Access to Word Bookmarks

Posted on 2008-10-22
3
253 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

752 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