Office

  • Office 2010
  • Office
  • All forums
Question

Mail merge rules using if then else for a date

Applies To:
I am trying to find out with in word 2010 how to use mail merge and the If...Then....Else with a date.  My data source has a field called "due date" and I want to run a mail merge that says "If due date is greater than or less than 5 Oct 2011 say "insert text" else "insert test".

Is this possible?
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation
2 People had
this question

Dono81

Dono81

Was this helpful?

1

Vote

Answer
Yes it is possible

{IF {Mergefield Due_Date \@ "yyyyMMdd" } > 20111005 "Greater" "Not Greater" }

See also http://www.gmayor.com/formatting_word_fields.htm
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Graham Mayor

Graham Mayor MVP
Community Star
http://www.gmayor.com

Was this helpful?

Answer

You may refer to the link below and follow the steps mentioned in ‘To use the IF field as part of a mail merge’ to use the (If… then… else) option while doing a Mail merge.

http://office.microsoft.com/en-us/word-help/field-codes-if-field-HP010077969.aspx

If you are using multiple conditional formatting statements you may post your query in the customization forum below:

http://social.answers.microsoft.com/Forums/en-US/officeprog/threads

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Raju S Das

Support Engineer
Raju S Das
Community Star

Was this helpful?

Answer

You may refer to the link below and follow the steps mentioned in ‘To use the IF field as part of a mail merge’ to use the (If… then… else) option while doing a Mail merge.

http://office.microsoft.com/en-us/word-help/field-codes-if-field-HP010077969.aspx

If you are using multiple conditional formatting statements you may post your query in the customization forum below:

http://social.answers.microsoft.com/Forums/en-US/officeprog/threads

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Raju S Das

Support Engineer
Raju S Das
Community Star

Was this helpful?

1

Vote

Answer
Yes it is possible

{IF {Mergefield Due_Date \@ "yyyyMMdd" } > 20111005 "Greater" "Not Greater" }

See also http://www.gmayor.com/formatting_word_fields.htm
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Graham Mayor

Graham Mayor MVP
Community Star
http://www.gmayor.com

Message marked as answers cannot be deleted

To delete this message, first unmark this message as an answer, then delete it.

Reason to remove escalation


Merge

Enter the thread ID of the thread you are merging into


Reply will be posted to a public thread

You are replying to a public portion of this thread. To reply privately, click Cancel, click the Private Messages tab, and Reply on that private message.

Don't show this message again

To report abuse, sign in or continue without signing in

Thank you.

Report abuse

Abuse type:

Details (optional):

Report abuse

Abuse type:

Details (required):
Enter the characters you see (required):
Type the numbers that you see in the picture.
Play audio and type the numbers that you hear.
Show a different picture.

Sign in

Hotmail, Xbox Live, Messenger, or msn accounts will also work.

Don't have one of the above accounts?

Signing in...
This page will automatically update after you are signed in.
If you are having problems, you can close this message and try to connect again.