Knowledge Base

SmartSerialMail



Question / Problem

I’ve imported from a Excel sheet a list which shall distinguish between three salutation possibilities: male, female and undetermined. I want the software to generate the following salutations: Dear Mr John Doe (for male) Dear Mrs Jane Doe (or female) Dear art lover (in any other case) Is this possible ?

Answer / Solution

There is no possibility for performing this kind of rule application in SmartSerialMail yet. But there is another way to achieve the desired result:

  • Open the Excel spreadsheet in Excel
  • Chooseunder menu "Edit" the "Replace" function, and replace ‘male’with ‘Dear Mr. John Doe’, etc
  • Store yourlist under a different name (if you want to keep the original list
  • Start SmartSerialMail
  • Right-clickon the list of recipients and choose "Add a new column
  • Name this column, e.g. "Salutation
  • Import your new list
  • Insert the tags %Salutatuion% %First_name% %Last_name% in the proper spaces of your mail