Use different mail merge list 'on the fly'

macropod · #4 12-19-2018, 12:15 AM

Quote:

Originally Posted by Giorkos

I have already 'worked around' this by changing all the mail merge documents to read the same path/file list.txt

I understood that much from your initial post. As I said, though, implementing a solution where you can choose a different data source each time requires VBA code that allows you to select the data source before the mailmerge SQL statement is executed - and you can't do that if the document has been saved as a mailmerge main document that is already connected to a datasource. Hence, the need for the approach I suggested.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail merge with unusual list	Tesla	Excel Programming	3	10-18-2018 12:49 PM
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list	LisaRH	Mail Merge	3	08-09-2018 03:01 PM
Mail merge into separate list	mds	Mail Merge	5	04-06-2016 02:17 AM
Grouping list in Mail Merge	AlexTeslin	Mail Merge	1	03-08-2013 09:31 PM
Mail Merge Recipients List	TanMan	Mail Merge	1	10-13-2011 06:36 PM