Mail Merge

[Guest]

In Word I select the Table that has two fields. The ID number and a list of
names. When I merge it into a letter the ID number comes up instead of the
name that I want. How to I get it to recognize the right field? I've tried to
make the name the primary key but it still does not show up in the preview
the letter as anything but a number
Help. This should be a piece of cake.
R

 

[Guest]

Just a guess, but I'm suspecting that the table may have a lookup field
defined. Lookups defined at the table or query level art thy creation of the
evil one. For more information on this topic, please see the 2nd commandment
in this listing:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm

As long as you are not using Access 2007, you can quickly locate all lookup
fields by first downloading and installing Jeff Conrad's free add-in called
"CSD Tools":

http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

If you have a lookup field defined, then create a new query that includes
your original table plus the field in the looked up table. Use this query in
your mail merge.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________