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

Ova tema je arhivirana. Pitajte drugo pitanje ako vam je potrebna pomoć.

Using if then else in Mail Merge Add-on

  • 1 odgovor
  • 0 ima ovaj problem
  • 1 view
  • Posljednji odgovor poslao 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|