S
shan
I am using mail merge to populate a form in microsoft word. I have a
query that is based on multiple tables in Access. Essentially, the
query locates one specific record, gets corresponding information on
that record from numerous other tables, all linked by exclusive autonumber.
Word document has its data source set to the query and populates the
form based on the single client record selected in Access database.
Works fine in Office 97. However in Office 2003, word does not show the
query as being available for use. Shows almost all other queries and
tables, just not this one. Word uses the query fine as was originally
set up, it just won't let me select it to add or change merged fields in
this form or to create other forms based on that query.
Any help would be greatly appreciated.
Steve
query that is based on multiple tables in Access. Essentially, the
query locates one specific record, gets corresponding information on
that record from numerous other tables, all linked by exclusive autonumber.
Word document has its data source set to the query and populates the
form based on the single client record selected in Access database.
Works fine in Office 97. However in Office 2003, word does not show the
query as being available for use. Shows almost all other queries and
tables, just not this one. Word uses the query fine as was originally
set up, it just won't let me select it to add or change merged fields in
this form or to create other forms based on that query.
Any help would be greatly appreciated.
Steve