Mail merge with specific work sheet

I have an excel file with various worksheets, how can i create a mail merge
letter selecting just one of the work sheets. I am working off Microsoft
2000.

Hi Tina,
You can only use one worksheet. That worksheet should be the
first tab in the workbook. Directions for printing labels in
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

A letter would be pretty much the same but you might prefer one of the
other pages perhaps the one by Cindy Meister (see links at)
http://www.mvps.org/dmcritchie/excel/excel.htm#more

---
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

"Tinaponders" <[email protected]> wrote in message news:[email protected]...
> I have an excel file with various worksheets, how can i create a mail merge
> letter selecting just one of the work sheets. I am working off Microsoft
> 2000.