conditional macro
Allow for Conditional Macros so I can eliminate text when a macro field is empty such as:
Dear {First Name} If{Second Name}<> null then "and " {Second Name}
this might result in:
Dear Bruce and Barb
Dear Bruce
-
Robin Sapiro commented
Another possible solution is to use Integromat.
Do your original email in WA and only send it to yourself.
When you receive the email - save as HTML from your email client.Now in Integromat (assuming that you have already integrated with WA) set up to read through your contact/membership by whatever criteria you want.
Send everyone an email from a GMail account. For the email body, paste in the HTML previously saved and then Integromat will allow you to add in conditional text base on your criteria (could be content of any field in the WA contact/member DB).
So rather clunky again for 1 off emails - but works great for recurring emails. I send all my members wishes on the day of their birthday and anniversary (if married) like this. Runs automatically every day at 8:30am
-
Robin Sapiro commented
So this wish item is only just over 3 years old and only has 17 votes - so don't hold your breath waiting for this.
In the interim you can achieve this by creating a field in all profiles that is used just for special text in an email.
Then export all contacts and members with Contact ID, membership level and this field to an Excel spreadsheet.
Edit that sheet to insert the required text for the different membership levels and import back into WA.
Now use that field as a macro in your email.
Yes - really clunky but it does work. But also my experience is that if you import a spreadsheet into WA and any cells are empty and the corresponding WA filed already has text - this text will remain.
Also if you do embed an empty field into an email you will either get a double space somewhere or an extra blank line.
One way around this is for the blank fields - import a space into them, for the fields with content include both the leading and trailing space and then in the email don't put any spaces before or after the macro.
-
Anne commented
Would also be helpful for adding some content for members and other content for contacts (for example, interested but not yet a member, join now!)
-
Andrew Steele commented
This would be useful in other situations too, such as only listing guests for an event registration if there are in fact registered guests. Otherwise it looks like something is missing when the confirmation email contains "Guests:" with a blank afterward. We also have added a middle initial field, which we need to include on some materials, but leaves an awkward double-space for those who don't have this information.
-
For name, you can use Contact_FullName https://help.wildapricot.com/display/DOC/Using+macros+in+emails#Usingmacrosinemails-Contactmacros