#1
|
|||
|
|||
Can you combine two Rules in one Mail Merge Command
Can you combine Rule "Next Record" with Rule "Skip Record if..." in the same instruction? This worked with 2 of the 50 database entries but then the merge process failed. Thanks in advance for your interest and help. Michael |
#2
|
||||
|
||||
How are you trying to combine them and to what end?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for your response. I'm trying to cull out records, to be printed in either a table or in a one page list, where the records selected have a "Y" in a cell in column M with the header "2019 Letter Y".
This works: {SKIPIF{Mergefield M_2019_Letter Y}="" }Mergefield First_Name} {NEXT }{SKIPIF{Mergefield M_2019_Letter Y}="" }Mergefield First_Name} This Fails: {SKIPIF{Mergefield M_2019_Letter Y}="" }Mergefield First_Name} {NEXT }{SKIPIF{Mergefield M_2019_Letter Y}="" }Mergefield First_Name} {NEXT }{SKIPIF{Mergefield M_2019_Letter Y}="" }Mergefield First_Name} The error message is: "Word could not merge the main document with the data source because the data records were empty or no Data records matched your query options." There is no problem with the data source, I've used it successfully for an envelope mail merge. Thanks for continued help. Michael |
#4
|
||||
|
||||
So why not use just:
{SKIPIF{Mergefield M_2019_Letter_Y}= ""} or filter the records? A Directory/Catalog merge will output the data without page breaks.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
The Directory merge works well. Thanks much.
|
Tags |
mail merge rule |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Show table list by using chek box command and save document on sharepoint by using command button | Zhibek | Word VBA | 3 | 08-16-2018 06:19 PM |
How to combine these formulas into one? | LearnerExcel | Excel | 2 | 12-27-2017 12:41 AM |
Please help me to combine these code together | lbf200n | Word VBA | 3 | 12-09-2012 04:22 PM |
Question about Tools>Rules and Alerts>E-mail Rules | RichGuard | Outlook | 0 | 09-02-2010 05:19 PM |
Add-In:How to add command right click command bar | phang | Outlook | 0 | 01-15-2007 02:53 AM |