Open a word mail-merge document from Excel VBA

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
 
J

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

Similar Threads

Automating mail merge from excel 3
Saving a Word document as PDF from en Excel macro 2
Mail Merge source Access Database using Excel VBA 1
mail merge 2
Mail Merge source Access Database using Excel VBA... Pls Anyone 2
Getting around 255 Column limit 10
Determine when Word document opens successfully from Excel VBA 2
Excel VBA in Citrix. 0

Top