Mail Merge and MS Query

[Guest]

I have an interesting problem with MS Query and Word 2007. I have two
tables, one contains individual names and the company name (table 1), the
other contains the email address(es) associated with the individual (table
2). The tables are linked using a primary key in table 1 and a foreign key
in table 2.

I start Mail Merge, Select Recipients, and select tools dropdown, then
select MS Query. I select the database, and add the appropriate columns from
the choose column wizard, and select view data in MS Query on the last
screen. MS Query opens, and the data appears in the table as I would expect.
I set relationships between the tables to the correct fields, and the data
appears in query as I want it to for merging.

I select return data, and query closes, but when I look at mail merge
recipients, I have none, just blank lines. I have tried saving the query and
setting the data source to the saved query with the same results. Completing
the mail merge results in (naturally) nothing. Can anyone shed light on this
behavior?

 

[Cindy M.]

Hi =?Utf-8?B?Um9nZXIweDE=?=,

Testing here returns the expected results, so I'm at a bit of a loss...

I used Excel as the data source.

MS Query "belongs" to Excel. If you use it in Excel to bring together the two
tables do you see anything different?

I have an interesting problem with MS Query and Word 2007. I have two
tables, one contains individual names and the company name (table 1), the
other contains the email address(es) associated with the individual (table
2). The tables are linked using a primary key in table 1 and a foreign key
in table 2.

I start Mail Merge, Select Recipients, and select tools dropdown, then
select MS Query. I select the database, and add the appropriate columns from
the choose column wizard, and select view data in MS Query on the last
screen. MS Query opens, and the data appears in the table as I would expect.
I set relationships between the tables to the correct fields, and the data
appears in query as I want it to for merging.

I select return data, and query closes, but when I look at mail merge
recipients, I have none, just blank lines. I have tried saving the query and
setting the data source to the saved query with the same results. Completing
the mail merge results in (naturally) nothing. Can anyone shed light on this
behavior?

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