Excel macro to open word mail merge

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

Guest

I have an excel macro calculate and extract records from access and reorganize it for a mail merge in Word. The mail merge document (saved as a template) in Word is already set up and works fine but the problem is that my users have to first run excel and get the data and then they have to save and close the document and then load the Word template

Is there a way to allow them to only have to perform one step, such as load the Word template and have an autorun macro load the excel file and run its macro, save & close it, and then run the mail merge? Or the other way around and have excel run the Word file

Any suggestions
 
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
Saving a Word document as PDF from en Excel macro 2
VBA set thick borders around non empty cells in range 0
Starting Word from Excel 2
Automating mail merge from excel 3
Mail merge leaves excel process running 3
Mail merge macro: select recipients from Excel during merge 0
Help with Selecting Merge Table 1

Back
Top