You will have to combine the data into one sheet, and place that sheet
as the first sheet in your workbook.
Mail Merge, Printing Labels using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Pure" wrote in message ...
I need to mail merge two letters from two different worksheets in Excel but
even when I name the ranges, Word does not give me the option to use the data
in my mail merge.

Is it possible to do this?

Thanks!