Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-09-2016, 02:05 AM
macropod's Avatar
macropod macropod is offline Filter Mail Merge based on a list of filter criteria Windows 7 64bit Filter Mail Merge based on a list of filter criteria Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,379
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

Instead of filtering by Planner Group code, you could have the mailmerge sort by it (and by other criteria as well), so that your outputs are grouped the way you want them. If you use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version), you can have it insert page breaks (or Section breaks) whenever the groupings change. No code required. To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

Having completed said merge, it's a simple-enough matter to saving the different portions of the file to uniquely-named PDFs. There's code for that in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
filter, filtering, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter tasks with multiple criteria markhad Outlook 0 03-15-2016 02:48 AM
Filter Mail Merge based on a list of filter criteria Complex Mail Merge based on Criteria fairchance Mail Merge 11 08-22-2015 04:32 AM
Mail merge with filter using data inputted by user Tornado70 Mail Merge 6 04-09-2013 07:16 AM
Forgotten Sort and Filter Criteria rbdmg Mail Merge 0 10-31-2011 09:14 PM
Filter Mail Merge based on a list of filter criteria Applying Filter to mail merge crashes word!!! sedain121 Mail Merge 1 06-28-2010 02:33 PM

Other Forums: Access Forums

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


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