Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2018, 12:15 AM
macropod's Avatar
macropod macropod is offline Use different mail merge list 'on the fly' Windows 7 64bit Use different mail merge list 'on the fly' Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,526
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
Reply



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
Use different mail merge list 'on the fly' Mail merge into separate list mds Mail Merge 5 04-06-2016 02:17 AM
Use different mail merge list 'on the fly' Grouping list in Mail Merge AlexTeslin Mail Merge 1 03-08-2013 09:31 PM
Use different mail merge list 'on the fly' Mail Merge Recipients List TanMan Mail Merge 1 10-13-2011 06:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft