Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge 2 excel worksheets
I am trying to enter data from two sheets on same worbook in excel, into a
word document, but I seem to only be able to take data from one sheet. Can you help? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge 2 excel worksheets
Word can only use a single flat file as the data source for a mail merge.
You will need to either combine the to sheets into one or create a third sheet in Excel on which you reference the cells on the other two sheets so that you have all of the data 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 "Creativephotos" wrote in message ... I am trying to enter data from two sheets on same worbook in excel, into a word document, but I seem to only be able to take data from one sheet. Can you help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple worksheets in Excel | Mailmerge | |||
mailmerge from excel with multiple worksheets | Mailmerge | |||
Merging Excel worksheets | Mailmerge | |||
How do I use multiple worksheets when doing a mailmerge | Mailmerge | |||
Using different worksheets as sources for mailmerge | Mailmerge |