View Single Post
 
Old 12-19-2018, 12:15 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Giorkos View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote