Results 1 to 2 of 2

MailMerge and IF statement

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    02-26-2010
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003/2007/2010/2016
    Posts
    432

    Talking MailMerge and IF statement

    Hello!


    I can't figure out how do do the syntax for this. If the Status field value is "Item on Hold", color the text red. If Accepted Item, blue, and anything else, yellow.

    I can do the font color part, but it is the IF, quotes, brackets, = Text part that is stumping me. Here's what I have so far:

    IF{MERGEFIELD "Status"} = ITEM ON HOLD" {MERGEFIELD "Status"}" "{IF {MERGEFIELD "Status"} = ACCEPTED ITEM "{MERGEFIELD "Status"}" "{MERGEFIELD "Status"}"}"

    I appreciate the help!

    Respectfully,

    Lost
    Last edited by leaning; 08-10-2011 at 12:25 PM. Reason: Solved!

Thread Information

Users Browsing this Thread

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

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