Word Mail merge

N

Nathan

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
 
D

David McRitchie

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 Before:=Sheets(1)
 
Top