Mail Merge Word Document From Excel VBA

P

Pablo_In_NZ

Hi, a newbie question !
I need to merge a word document using the data from an Exce
spreadsheet.All the fields are set in the word document OK, I just nee
to know how to load the Word template, run the merge, then save th
resulting document, all from VBA code within the Excel sheet. The ide
is the code sits under a button in the spreadsheet, which when clicke
will create the document and save it.
If someone could point me in the right direction of the objects I nee
to create/functions I need to call, that would be great.
I'm using XP.
Many thanks in advance
 

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
Automating mail merge from excel 3
writing excel data into word document 1
Word VBA for deleting Selected Row 0
Using VBA to automate printing with mail merge 1
Creating Word docs from Excel with VBA 3
Custom Document Properties in Word documents and Excel workbooks 13

Top