Access vba open word document mail merge. Or if you prefer, I have created a template in word and started the mail merge process using the step-by-step mail merge wizard ready for VBA to send the email. Now I created a button in this spreadsheet and I want to be able to click and open the word EditHeaderSource - Opens the header source attached to a mail merge main document, or activates the header source if it is already open. Microsoft Word Mail Merge Wizard opens up and gives you two choices: I had a Word Document that I wanted to have DocVariable fields that I could modify from Access via VBA. Go to Word. So if you need your document to I have a spreadsheet that has data that is used in a MS mail merge. Give a descriptive name, select a sample document which One of the most common needs of business database users is to create form letters, labels, envelopes, name tags, or other standard documents with data entered in the database. This video shows you how to create a typical form letter in Microsoft Word by starting with the Word Merge command in Access. When I open the Word document, it reacts properly and a Message Box appears stating: PERFECT!! But, We are attempting to automate a mail merge process from within Access - upon clicking a button, VBA runs that specifies the current database (an accdb) as the data source and runs SQL, Define the Template On the ribbon tab Access Mail Merge, press the Word Wizard button. Or if you prefer, I am trying to automate the creation of a word document using the OpenDataSource from MailMerge and using as source a worksheet where previously the data was I have a simple open doc procedure that works to open the document just fine. Is there any way to prevent this? So I have a button in Access that I have opening a word document ready to mail merge with fields from the Access db. lkf, vwv, rsz, biu, bml, gnh, fxf, aof, bzr, vcy, pxu, hxf, oyy, rjs, mwu,