Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2017, 09:19 PM
Alfred Alfred is offline Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Windows 10 Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Office 2016
Novice
Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content
 
Join Date: May 2017
Posts: 1
Alfred is on a distinguished road
Default Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content

Hello, I am new to the the Community so hello to all!
I was wondering if someone can please help me;



I have created a mail merge from excel into a word email message and have added an IF function to the merge-field using the "Rules" tab. ( I can edit the field codes by "Right clicking and toggling Field codes)

I am using the "IF" function which works fine but I would like to get an additional option on the inserted text.
Rather than have it insert the additional text if the merge-field is "equal to" something, I would like to be able to add the text or for it to "trigger" if the merge-field "contains" a certain word or phrase. (I think the function may be called "Search" or "ISNUMBER")

This is because I have two possible paragraphs depending on the merge field content but would like a third option where if the merge-field contains both "chosen words" or "phrases" then it will show both the additional inserted text (without creating a third option).
For Example:
So instead of using "Answer_1" or "Answer_2"" as the Contents of the merge field to trigger the insertion of each respective paragraph of inserted text, we would be saying if it contain "1" anywhere in the Merged field or in the second merge-field if it contains "2" anywhere in the merge-field it would insert the respective text. I could then achieve my desired result where if I had a third option that was added to the merge-field, for example "Answer_1_2" because it contains both the numbers 1 and 2 it would add both paragraphs.
i have tried changing the IF state using "SEARCH" but without success, I think I am getting confused with the correct formulas because we have {} and () in the field codes.

i hope I have explained this clearly and not put anyone to sleep!

I would really appreciate it some one could help me with this.

thank you very much in advance.
Reply With Quote
  #2  
Old 05-23-2017, 09:46 PM
macropod's Avatar
macropod macropod is offline Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Windows 7 64bit Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Word's ability to test whether a field 'contains' something is limited. The possibilities are discussed in the Mailmerge Tips & Tricks 'sticky' thread at the top of this forum.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-23-2017, 10:59 PM
macropod's Avatar
macropod macropod is offline Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Windows 7 64bit Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Cross-posted at: https://answers.microsoft.com/en-us/...d-77617b557d2b
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" CCCPWDES Mail Merge 9 03-17-2014 08:01 AM
Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Applying "Paper Source" settings to multiple sections in a mail merge does not apply ChrisC Mail Merge 1 06-18-2012 07:11 PM
Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Code to stop as "save as" if the mail merge has not been done tonywatsonmail Mail Merge 4 04-27-2012 01:57 AM
Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content "Table of content" based on "Normal Style" behavior!!!! Jamal NUMAN Word 4 07-08-2011 04:12 AM
merge field formatting problem with "text to be inserted before" wissam Mail Merge 0 12-13-2009 12:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:40 AM.


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