Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge data from 2 excel worksheets into one word document
I have two excel worksheets. They contain data pertaining to two different
years. The fields are identical. I want to merge the data from both the worksheets side-by-side in one word document. Mail merge seems to take only one data source for a document. Any ideas? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge data from 2 excel worksheets into one word document
Combine the two worksheets into one.
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "S.Kulshekar" wrote in message news I have two excel worksheets. They contain data pertaining to two different years. The fields are identical. I want to merge the data from both the worksheets side-by-side in one word document. Mail merge seems to take only one data source for a document. Any ideas? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge data from 2 excel worksheets into one word document
Hi ?B?Uy5LdWxzaGVrYXI=?=,
I have two excel worksheets. They contain data pertaining to two different years. The fields are identical. I want to merge the data from both the worksheets side-by-side in one word document. Mail merge seems to take only one data source for a document. Any ideas? It's possible, but may be more work than Doug's suggestion: You can use MSQuery and write the SQL for a UNION query. The SQL would look like this, for example: SELECT `Sheet1$`.Lastname, `Sheet1$`.Firstname FROM `C:\Test\UnionMerge1`.`Sheet1$` `Sheet1$` UNION SELECT `Sheet1$`.Lastname, `Sheet1$`.Firstname FROM `C:\Test\UnionMerge2`.`Sheet1$` `Sheet1$` You can access MS Query from the "Tools" menu in the Open Data Source dialog box. 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 | |||
Reveal codes in a word document | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Data Trucated in word merge with excel source | Mailmerge | |||
page number printing on a merged report | Mailmerge | |||
Why isn't all my Excel data merging into my Word labels document? | Mailmerge |