Microsoft Office Forums Mail Merge Macro - With Options?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2017, 10:47 PM
MacroNoob MacroNoob is offline Mail Merge Macro - With Options? Windows 7 32bit Mail Merge Macro - With Options? Office 2010 32bit
Novice
Mail Merge Macro - With Options?
 
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 online now Mail Merge Macro - With Options? Windows 7 64bit Mail Merge Macro - With Options? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,480
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

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 Macro - With Options? Mail Merge keeping VBA Macro Piney Word VBA 5 08-03-2015 04:12 PM
Mail Merge Macro - With Options? 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
Mail Merge Macro - With Options? 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 05:03 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft