Microsoft Office Forums Can you combine two Rules in one Mail Merge Command

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-03-2019, 07:49 PM
coopfab coopfab is offline Can you combine two Rules in one Mail Merge Command Windows 10 Can you combine two Rules in one Mail Merge Command Office 2016
Novice
Can you combine two Rules in one Mail Merge Command
 
Join Date: Oct 2019
Posts: 5
coopfab is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-03-2019, 09:55 PM
macropod's Avatar
macropod macropod is online now Can you combine two Rules in one Mail Merge Command Windows 7 64bit Can you combine two Rules in one Mail Merge Command Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,671
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

How are you trying to combine them and to what end?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 11-04-2019, 08:05 AM
coopfab coopfab is offline Can you combine two Rules in one Mail Merge Command Windows 10 Can you combine two Rules in one Mail Merge Command Office 2016
Novice
Can you combine two Rules in one Mail Merge Command
 
Join Date: Oct 2019
Posts: 5
coopfab is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 11-04-2019, 12:37 PM
macropod's Avatar
macropod macropod is online now Can you combine two Rules in one Mail Merge Command Windows 7 64bit Can you combine two Rules in one Mail Merge Command Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,671
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

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
[MS MVP - Word]
Reply With Quote
  #5  
Old 11-04-2019, 01:08 PM
coopfab coopfab is offline Can you combine two Rules in one Mail Merge Command Windows 10 Can you combine two Rules in one Mail Merge Command Office 2016
Novice
Can you combine two Rules in one Mail Merge Command
 
Join Date: Oct 2019
Posts: 5
coopfab is on a distinguished road
Default

The Directory merge works well. Thanks much.
Reply With Quote
Reply

Tags
mail merge rule

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show table list by using chek box command and save document on shairpoint by using command button Zhibek Word VBA 3 08-16-2018 06:19 PM
Can you combine two Rules in one Mail Merge Command How to combine these formulas into one? LearnerExcel Excel 2 12-27-2017 12:41 AM
Can you combine two Rules in one Mail Merge Command 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


All times are GMT -7. The time now is 03:47 PM.


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