Excel is going to use the first worksheet.
So would suggest that you have the macro move that worksheet to
the first position.
Sheets("Data").Move Befo=Sheets(1)

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

"Nathan" wrote in message ...
Hi.

I would like to have a button on my spread sheet that enables a mail merge to be done on a sheet wihin the workbook called "Data"

I am ok with setting up the word object, but i dont know how to code the link to the sheet "Data" for the mail merge's data
source.

TIA

Nath