Open a word mail-merge document from Excel VBA
 

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

Open a word mail-merge document from Excel VBA
 

Why not use Excel as your Full mailmerge without using Word. Send me a mail to and I'll send you the worksheet. Very small and compact and I use it all the time.