I am doing a mail merge from an excel workbook to a word document (letter).
The first one worked fine, when I activated the next worksheet, it wouldn't
merge the correct worksheet, it does the original one over and over. ?????

Try moving the 2nd sheet to be the first tab (i.e. leftmost) ..

Precaution is highlighted in Dave M's mail merge page:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm,

"Biggest stumbling block with using Mail Merge and an Excel database: Be
sure to have your Excel spreadsheet as the first worksheet tab in your
workbook. Even using a defined name, it appears you must have the worksheet
as the first worksheet tab in your workbook."
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Frustrated!!!!" wrote in message
...
I am doing a mail merge from an excel workbook to a word document
(letter).
The first one worked fine, when I activated the next worksheet, it
wouldn't
merge the correct worksheet, it does the original one over and over.
?????