Open a word mail-merge document from Excel VBA

  • Thread starter Thread starter hbj
  • Start date Start date
H

hbj

I have an Excel workbook with data to a word 2007 mail-merge file. When I open the Word file with VBA an old version is opened without merging data. When I open it the normal way, I get the question to perform or not perform the SQL-statement.
How can I automate the SQL statement from VBA and perform the merge?
Håkan
 
Why not use Excel as your Full mailmerge without using Word. Send me a mail to (e-mail address removed) and I'll send you the worksheet. Very small and compact and I use it all the time.
 
Back
Top