Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2018, 11:46 AM
Giorkos Giorkos is offline Use different mail merge list 'on the fly' Windows 10 Use different mail merge list 'on the fly' Office 2013
Novice
Use different mail merge list 'on the fly'
 
Join Date: Nov 2018
Posts: 2
Giorkos is on a distinguished road
Default Use different mail merge list 'on the fly'

Hi all.



Just registered on the forum to ask for some help.

I am not an expert with mail merge.

I was wondering if there is any way as to dynamically open a merge word document but pass ot it a different filename of the mailing list.
Perhaps by creating a 'special. Mail merge document that supports this, or even by command li e passing arguments.

So for example if I created a mail merge document a.docx that reads from a text file data named t. Txt, is there a way I could open the merge document, passing to it a different text file as a list such as b.txt???

I am aiming to call the appropriate mail merge document and the 'correct' mailing list from an application in oracle forms 12.

I know I.an get around this by creating the mail merge document to read from a static mailing list name, then through the application. To copy and rename the new mailing list to the location/name of the original mailing list but I would like to bear if there is a way to dynamically pass a different mailing list.

Thank you,

Giorkos
Reply With Quote
  #2  
Old 12-18-2018, 04:58 PM
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: 21,956
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

No, that is not possible. What you envisage would require a macro in a document that is not a mailmerge main document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-18-2018, 11:26 PM
Giorkos Giorkos is offline Use different mail merge list 'on the fly' Windows 10 Use different mail merge list 'on the fly' Office 2013
Novice
Use different mail merge list 'on the fly'
 
Join Date: Nov 2018
Posts: 2
Giorkos is on a distinguished road
Default

Hi,

Thanks for the reply.

I have already 'worked around' this by changing all the mail merge documents to read the same path/file list.txt and I programmatically copy and rename proper source file from wherever its original location is to mailing_list.txt , but as I said changed merge documenfs to have mailing_list.txt as sour e.

Of. Ihrse I make lots of checks along the way to make sure I do not provide a wrong mailing list document for a wrong client!!

Thanks for the reply!!

George
Reply With Quote
  #4  
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: 21,956
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

Thread Tools
Display Modes


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 07:27 AM.


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