Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can I use more than 1 worksheet to merge info
I have a large Excel 2003 file with multiple worksheets. I want to create a
letter in Word 2003 that merges information from several of the worksheets. Can that be done? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can I use more than 1 worksheet to merge info
No, Word can only use a single, flat data source for a mail merge. You
will need to combine all of the required information onto one sheet in the Excel work book. -- 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 "kimmer" wrote in message ... I have a large Excel 2003 file with multiple worksheets. I want to create a letter in Word 2003 that merges information from several of the worksheets. Can that be done? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Heavy Mail Merge Application | Mailmerge | |||
print out a list of info in mail merge? | Microsoft Word Help | |||
Word Document Merge and MS Excel Worksheet via DDE | Microsoft Word Help | |||
Can you merge info from one document into a fillable form? | Microsoft Word Help | |||
Select specific excel worksheet for mail merge | Mailmerge |