Macro to Run a Mail Merge

Assuming that I have a mail merge file already set up to run with my Access database, how can I run that from my database? Assume file name is c:\My Documents\mymerge.doc

Thanks!!

Create a query in the db containing the data required, then use that query as the data source for your doc. You shouldn't have to run anything from within the db.

HTH

Or did you mean open the .doc?

Actually, the user wants to run the mail merge from the DB, not the doc...see? We're assuming that the mail merge is already set up to the appropriate table/query/whatever.

To open the .doc from a form in the db, I'd use the Follow Hyperlink method in the Onclick event of a button.

Code:

---

Application.FollowHyperlink "c:\My Documents\mymerge.doc", , True, True

---

HTH

Okay. I've advised the asker to record a macro to run the mail merge, put that code into the Document_Open, and save the doc file.

Then to create a command button and put that code behind it.

Thanks!!