Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

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
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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 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