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?

Johan Snyder

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.

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