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

TI

Nath

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