ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Mail Merge Word Document From Excel VBA (https://www.excelbanter.com/excel-programming/309312-mail-merge-word-document-excel-vba.html)

Pablo_In_NZ

Mail Merge Word Document From Excel VBA
 
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

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com