Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-07-2017, 10:47 PM
MacroNoob MacroNoob is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2017
Posts: 1
MacroNoob is on a distinguished road
Default Mail Merge Macro - With Options?

I have been using Macropod's code to mail merge into individual files.

However, is it possible to create option to choose merge to .pdf or to .docx?

Thanks!
Reply With Quote
  #2  
Old 09-08-2017, 12:11 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,664
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 behold
Default

The macro already has code for both. If you want to be able to choose between them, you need to solicit some input that can then be tested as the macro runs. Alternatively, of course, you could just have two versions of the macro: one that outputs documents; and one that outputs PDFs, without the need for additional code for choosing (i.e. you simply choose which version to run from the macros box).
__________________
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 keeping VBA Macro Piney Word VBA 5 08-03-2015 04:12 PM
Mail Merge Macro ch1325 Word VBA 2 06-08-2015 06:18 AM
Mail Merge Macro spc94 Word VBA 2 06-04-2015 07:06 AM
Word Doc Macro (mail Merge) ajolson1964 Word VBA 1 05-10-2011 10:15 PM
Message Options - Mail Merge limitations nai0248 Mail Merge 0 12-09-2010 01:39 PM


All times are GMT -7. The time now is 10:51 AM.


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