Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-28-2021, 05:10 PM
Formd Formd is offline If and/or in mailmerge Windows 7 32bit If and/or in mailmerge Office 2007
Advanced Beginner
If and/or in mailmerge
 
Join Date: Feb 2015
Location: TX
Posts: 49
Formd is on a distinguished road
Question If and/or in mailmerge


I am using a template to mailmerge a document using multiple "If" conditions.
The outcome should merge a letter, only if the status is not "Expired" and if definitions shows "Client/Pat" or Client/Set.
Problem is, the info still merges if status is "Expired". What am I doing wrong?
Attached is my template, sample db and my document after merged.


IF Definition1 = Client/Pat OR Definition1 = Client/Set AND Status1 is not = Expired
then letter should merge.

This is the code I am using:
IF{={IF{MERGEFIELD Definition1}= "Client/Pat" 1 0}+{IF{MERGEFIELD Definition1} = "Client/Set" 1 0} \# 0}>0 {IF{MERGEFIELD Status1} = "Expired" "" "Letter goes here"}
Attached Files
File Type: doc Template.doc (42.0 KB, 8 views)
File Type: xlsx Data.xlsx (8.9 KB, 7 views)
File Type: doc Merge Outcome.doc (27.0 KB, 6 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
If and/or in mailmerge Macro to insert an image to a word mailmerge document based on the value of a mailmerge field? Jake93 Mail Merge 3 07-02-2019 05:38 PM
Can you CC somebody on a MailMerge? constructionjasont Mail Merge 2 06-28-2017 06:01 AM
If and/or in mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 8 02-11-2013 04:40 AM
If and/or in mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 13 05-29-2012 02:04 PM
Help with mailmerge??? foxtrot1981 Mail Merge 0 12-03-2010 08:21 AM

Other Forums: Access Forums

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


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