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-16-2013, 03:22 PM

jtemp57

Windows Vista Code for mail merge to reference saved excel file

Office 2007

Novice

Join Date: Dec 2013

Posts: 6

Quote:

Originally Posted by macropod

For that I believe you could insert:
.DataSource.QueryString = "SELECT * FROM `My_List`"
after:
.MainDocumentType = wdFormLetters

It doesn't do anything different when I input the above. I tried moving it to a couple different places but nothing changes. I still have to select my data source and excel list. Any other suggestions??

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 11:13 AM.