How do I mail merge from different excel worksheets?

[Guest]

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!

 

[David McRitchie]

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

 

[Guest]

Thanks David...

The only thing is that I'm not merging to labels, I'm merging to letters and
I've tried putting the information all on one sheet and doing it that way but
it doesn't bring up the named ranges in Word, it just gives the option for
entire spreadsheet.

 

[David McRitchie]

You want a dedicated worksheet, but you can use a filter, as
word will only see the filtered result. I've never used named ranges
for a Mail Merge, might have something to do with the version of Excel.

For complete information on Filters see Debra Dalgleish's site
http://www.contextures.com/tiptech.html
For a video tutorial as an introduction
http://www.datapigtechnologies.com/ExcelMain.htm -- tips on filtering...