Worksheets won't merge!

F

Frustrated!!!!

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

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."
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
Frustrated!!!! said:
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.
?????
 
Top