Word Mail merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Before:=Sheets(1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open a word mail-merge document from Excel VBA 1
Save record Into master sheet! 1
How to subtract a number from a Mergefield? 0
Using VBA to automate printing with mail merge 1
Mail merge default file location 4
Create merge source in Excel, call Word to generate labels 1
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? 2
RON DE BRUIN Merge data from all workbooks in a folder HELP 1

Back
Top