Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-23-2017, 09:19 PM
Alfred Alfred is offline Windows 10 Office 2016
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
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

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-23-2017, 10:59 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
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

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
[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
Applying "Paper Source" settings to multiple sections in a mail merge does not apply ChrisC Mail Merge 1 06-18-2012 07:11 PM
Code to stop as "save as" if the mail merge has not been done tonywatsonmail Mail Merge 4 04-27-2012 01:57 AM
"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


All times are GMT -7. The time now is 12:08 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft