Code for mail merge to reference saved excel file

		Microsoft Office Forums > Microsoft Word > Word VBA
Code for mail merge to reference saved excel file

FAQ

Thread Tools

Display Modes

12-05-2013, 09:02 AM

jtemp57

Windows Vista Code for mail merge to reference saved excel file

Office 2007

Novice

Join Date: Dec 2013

Posts: 6

macropod,

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. I need the merge fields to remain in my label because the users will not know how to set all this up.

Do I change the .Destination = wdSendToNewDocument to something else?

Tags

mail merge, vbs

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:07 PM.