mailmerge 2 excel worksheets

[Creativephotos]

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?

 

[Doug Robbins - Word MVP]

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