Important Notice: We're experiencing email notification issues. If you've posted a question in the community forums recently, please check your profile manually for responses while we're working to fix this.

On Monday the 3rd of March, around 5pm UTC (9am PT) users may experience a brief period of downtime while one of our underlying services is under maintenance.

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Este fío arquivouse. Faga unha nova pregunta se precisa axuda.

Using if then else in Mail Merge Add-on

  • 1 resposta
  • 0 have this problem
  • 3 views
  • Last reply by Matt

mandm.neave
mandm.neave
more options

I’m wanting to include one of two sentences in my email depending on the content of a “Status” field, which will be either N or R. The syntax I tried was {{Status |N|Thank you very much for joining our Society. |Thank you for renewing your membership of our Society}} However, all the resulting emails contained the second text… Could anyone tell me what I am doing wrong please?

Malcolm

I’m wanting to include one of two sentences in my email depending on the content of a “Status” field, which will be either N or R. The syntax I tried was {{Status |N|Thank you very much for joining our Society. |Thank you for renewing your membership of our Society}} However, all the resulting emails contained the second text… Could anyone tell me what I am doing wrong please? Malcolm

All Replies (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

This is not the support forum for the addon. The author provides an email address for this if I recall correctly.

However the download page offer this 

{{name|if|then|else}}
If the value of the field name equals if, then the variable will be replaced by then, else by else.

A couple of things spring to mind. If using CSV files, often you find blank spaces before of after values which do not translate to the value you see and are testing. Commonly text values are wrapped in "quotes" when you test on them. None of the examples are, but I do wonder if they need to be in practice.

Or perhaps Status | is what is not recognized and it should be expressed as Status|