Hi ?B?SWFuIFlvcmtl?=,
In our Database we have lookup tables for city and state. example
CityId City StateID State
10 New York 50 NY
11 Atalnta 51 GA
our customer table has many fields: FirstName, LastName, Company, City,
State, etc.
City and State uses the look up tables described above to get their values.
We created a query based on the customer table to create mailing envelopes.
the problem is that word show only the CityID and StateID in word example
Open the Access query (I'm assuming this is Access) in Design view. Click the
"Add Table" button (a big yellow plus sign) and choose the table that contains
the look up information. This should add the table to the query, and you
should see a line linking the two tables.
Now you can drag the City and State fields that contain the text from the
lookup table into the query grid (and remove the ID fields if you don't need
them for the mail merge).
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)