Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge and MS Query
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? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge and MS Query
Hi ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge on an access query... | Mailmerge | |||
Mail Merge Query | Mailmerge | |||
Mail Merge Query Options? | Mailmerge | |||
mail merge query | Mailmerge | |||
how do I set up a query for my mail merge | Mailmerge |