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!
Re: MailMerge and IF statement
All,
I figured out what I was doing wrong.
Here's the info from this site: http://word.mvps.org/faqs/mailmerge/mmergeiffields.htm.
I was justing typing in the curly brackets, so Word didn't know that was supposed to be a MergeField rather than text.Where the curly brackets represent field braces, which you must insert by pressing Ctrl+F9 (you can't type them). A real example might be:
{ IF { MERGEFIELD Gender } = "Male" "Him" "Her" }
Again, all of the curly brackets must be inserted by pressing Ctrl+F9.
Ctrl+F9 puts in the curly brackets, then you just cut-and-paste between them.
Good stuff!
Respectfully,
Lost
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks