Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to use mailmerge feature to generate report? (i.e. SQL statem
I would like to generate a report in word by retrieve data from an external
data source. (mysql database). I have successfully establish connection to this data source and by using mail merge I could retrieve the data for "one table" only. The problem is that the report require data more than one tables, and I may need to join and query the tables for some of the reports, but I does not know how to select more than one table with mailmerge. Please advice how I could achieve this, could I use SQL statement to query the database and then use mailmerge to compose the report (by choosing the field names). I'm using Windows XP Pro SP2 and Word 2003 SP2, MySQL data source. Many thanks in advance, William |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to use mailmerge feature to generate report? (i.e. SQL statem
A reply was already posted to a duplicate of this question, in another group.
Mailmerge can link to only one data source. Use a query to bring the information from multiple tables together, then link to that query as the data source. I would like to generate a report in word by retrieve data from an external data source. (mysql database). I have successfully establish connection to this data source and by using mail merge I could retrieve the data for "one table" only. The problem is that the report require data more than one tables, and I may need to join and query the tables for some of the reports, but I does not know how to select more than one table with mailmerge. Please advice how I could achieve this, could I use SQL statement to query the database and then use mailmerge to compose the report (by choosing the field names). I'm using Windows XP Pro SP2 and Word 2003 SP2, MySQL data source. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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 | |||
page number printing on a merged report | Mailmerge | |||
Trying to suppress Select Table box in Excel-Word mailmerge | Mailmerge |