View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pablo_In_NZ Pablo_In_NZ is offline
external usenet poster
 
Posts: 1
Default 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