Worksheets won't merge!

[Guest]

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

 

[Max]

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

--

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.

?????