Code for mail merge to reference saved excel file

macropod · #4 12-05-2013, 02:22 PM

Quote:

Originally Posted by jtemp57

I ran it and it lets me choose my datasource, but I want it to remain with the current word document that has all the merge fields set. The code you gave me opens up a new document with no merge fields

No, that's not what's happening. The macro I provided retains all of the mergefields and other content of the document from which it is run. It doesn't simply open a new document. Rather, using the document containing the code, it executes the mailmerge using that document and its mergefields and that process generates a new document containing the mailmerge output.

Quote:

I deleted the .Destination and it works.

Not really; all you've done is killed off the output, which Word will now ask you to specify.

Quote:

Another issue is that it is asking me twice to choose my list from excel before moving on.

To fix that, delete:
.OpenDataSource sPath
Working through the dialog already connects once, so there's no need to do it again. My bad.

Quote:

I also have created a form with a button attached to the code below. How do I get the form to pop up with the Word Document so that I can run the code below?

Without knowing what kind of button, or how you propose to hide it when the output is generated, I can't really say. However, for a more automated approach, move the code to the document's 'ThisDocument' code module and rename it:
Private Sub Document_Open()

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VB code: populate combobox from columns in Excel file	billybeach	Outlook	2	04-27-2013 04:38 AM
Mail Merge Code (Default Display)	ochiha_ita	Mail Merge	3	04-22-2013 04:04 AM
Code to stop as "save as" if the mail merge has not been done	tonywatsonmail	Mail Merge	4	04-27-2012 01:57 AM
Mail Merge saved to single .pdf	treetop	Mail Merge	1	08-10-2011 03:28 PM
Mail merge Field Code Manipulation	macjnr	Mail Merge	0	09-10-2009 11:37 AM