Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Is it possible to use multiple tabs in a workbook as one data sour
I want to create a merge, but the data is within 5 different tabs of my Excel
document. If you can't choose more than one worksheet, then what is the best way to pull my data from the spreadsheet??? I can't believe there's no way to do this. I tried to learn pivotreport, but it's not the type of report I need. I have a spreadsheet containing multiple worksheets. Each worksheet contains different info. for the same 73 centers. I now need to print out the data for each center individually & would like to condense the info. to a minimal amount of pages (3-4). |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Is it possible to use multiple tabs in a workbook as one data sour
Mail merge can only use a single flat file as a data source. As a result,
you would need to link the required information from each of the sheets onto a single sheet. -- 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 "Michelle @ BMA" wrote in message ... I want to create a merge, but the data is within 5 different tabs of my Excel document. If you can't choose more than one worksheet, then what is the best way to pull my data from the spreadsheet??? I can't believe there's no way to do this. I tried to learn pivotreport, but it's not the type of report I need. I have a spreadsheet containing multiple worksheets. Each worksheet contains different info. for the same 73 centers. I now need to print out the data for each center individually & would like to condense the info. to a minimal amount of pages (3-4). |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using data from all worksheets within a workbook for mail merge | Mailmerge | |||
find/replace multiple TABS | Microsoft Word Help | |||
multiple tabs on one line | New Users | |||
How to do a mail merge with an Excel workbook that has multiple w. | Mailmerge | |||
Microsoft word should have tabs for multiple documents | Microsoft Word Help |