Results 1 to 4 of 4

Using IF Search Function in Mail Merge

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2017
    Location
    London, UK
    MS-Off Ver
    2016
    Posts
    2

    Using IF Search Function in Mail Merge

    Hello, I am new to the the forum 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 am using the "IF" function but rather than have it insert the additional text if the merge-field is "equal to" 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.

    This is because I have two different possible insertions depending on the merge field 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)

    i have tried adding "SEARCH" but without success.

    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.

    Alfred.
    Attached Files Attached Files
    Last edited by Alfred1; 05-23-2017 at 12:29 PM. Reason: Additional Information As Requested

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Set VBA search function to only search one row and also not show duplicates?
    By TomToms in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2014, 04:00 PM
  2. IF(count(search) Function not working when search from text from a cell
    By joshnathan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-09-2013, 05:13 AM
  3. MailMerge
    By turnej in forum Excel General
    Replies: 0
    Last Post: 05-17-2013, 10:20 AM
  4. [SOLVED] Search function to search if worksheet contains specified text
    By mougiasm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2013, 02:50 PM
  5. Replies: 1
    Last Post: 10-18-2012, 05:52 AM
  6. Mailmerge Search & Replace
    By PooH in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-21-2010, 06:04 AM
  7. mailmerge
    By frank in forum Excel General
    Replies: 1
    Last Post: 02-24-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1