Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge data in mutliple tabs in Excel sheet
I have an Excel spreadsheet that has multiple sheets from which I need to
merge data into a Word doc. How do I get the merge process to acknowledge multiple tabs? I'm using Word 2000. When the merge wizard is envoked, I'm asked if I want to use the entire spreadsheet, but it will only use the first tab. Any thoughts? Thanks! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge data in mutliple tabs in Excel sheet
Word can only use a single, flat file as a data source. You will need to
add another sheet to your workbook on which you link all of the data from the other sheets that is required for the merge so that it is all in the one place. -- 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 "Lisa@Pru" wrote in message ... I have an Excel spreadsheet that has multiple sheets from which I need to merge data into a Word doc. How do I get the merge process to acknowledge multiple tabs? I'm using Word 2000. When the merge wizard is envoked, I'm asked if I want to use the entire spreadsheet, but it will only use the first tab. Any thoughts? Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SET UP MS WORD TO HAVE SHEET TABS LIKE EXCEL? | Page Layout | |||
sheet tabs in excel | Page Layout | |||
Automated Mail Merge With Excel Sheet containing data. | Mailmerge | |||
Mutliple lines of data per merge document | Mailmerge | |||
using same excel data in merge docs that use mutliple pages | Mailmerge |