Mail Merge

[Karen]

I'm not sure if I'm supposed to add this to the Word
message board or the Access board.

I have a mail merge document that someone created in
Word. A table in Access is used as my data source. I
enter all the data in each table field and merge the data
to the Word document. There's a merge field
for "Hospital." I looked at the Hospital table and
there's 2 fields - One for Hospital and one for the
hospital code number. When I merge the data source table
into the word document, the hospital code number merges
and not the hospital name. Yet the hospital name is the
data in that field. I hope I'm explaining this so
someone can understand. If I'm not, please let me know.
I have to have this figured out.

PLEASE HELP!
Thank you

 

[Jim/Chris]

There probably is another table with Hospital codes and
Hospital names. Create a query joining tha main table and
hospital table with the join at the Hospital Code. Base
your word merge off that query and the Hospital name from
the Hospital table.

Jim

 

[Karen]

-----Original Message-----
There probably is another table with Hospital codes and
Hospital names. Create a query joining tha main table and
hospital table with the join at the Hospital Code. Base
your word merge off that query and the Hospital name from
the Hospital table.

Jim


.
Thank you for your help - There is a table with Hospital

codes and Hospital names. The data source is a table
including the information for the form letter. Fields
include (for example) Hospital Name; Address; City; State;
Zip Code; etc. Can I base my word merge off that query
and the Hospital name from the Hospital table, when my
data source has more information I need. I have to use
the table with all of the info needed for the form letter
as my data source.
Your help would be greatly appreciated

 

[Jim/Chris]

Create a new query with both the Hospityal table and the
main table. Join them at the Hospital ID. Then populate
the query with all the information you need in your word
document including the hospital name. Your word document
will be based off this one query.

Jim