Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-30-2018, 11:46 AM
Giorkos Giorkos is offline Windows 10 Office 2013
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,375
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-18-2018, 11:26 PM
Giorkos Giorkos is offline Windows 10 Office 2013
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,375
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[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
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


All times are GMT -7. The time now is 07:48 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft