Recipients from File

Features ›› Using Mail Merge ››
Parent Previous Next


Excel File


Loading recipients from an excel file


To load recipients from an excel file follow these steps:


  1. Click on "File".
  2. Select "Excel Sheet" in the field type.
  3. Click "Choose file..." and select an excel file.
  4. Click "Load recipients".


Structure of the Excel File


The Excel file must be structured like the following example:



The data must be contained in the first worksheet in the excel workbook.


The columns Firstname, Lastname and Gender are optional.

If you do not provide a gender, then Reply Assistant will detect the gender based on the name.


The column Gender can contain the values "Female" or "Male".


CSV File


Loading recipients from a CSV File


To load recipients from a CSV file follow these steps:


  1. Click "File".
  2. Select "CSV File" in the field type.
  3. Click "Choose file..." and select a CSV file.
  4. Enter the CSV delimiter in the field "CSV delimiter".
  5. Click "Load recipients".


Structure of the CSV file


The CSV file must be structured lke the following example:


Email;Firstname;Lastname;Name;Gender
john.doe@example.com;John;Doe;John Doe;Male
susan.doe@example.com;Susan;Doe;Susan Doe;Female


The columns Firstname, Lastname and Gender are optional.

If you do not provide a gender, then Reply Assistant will detect the gender based on the name.


The column Gender can contain the values "Female" or "Male".


XML File


Loading recipients from a XML File


To load recipients from a XML file follow these steps:


  1. Click "File".
  2. Select "XML File" in the field type.
  3. Click "Choose file..." and select a XML file.
  4. Click "Load recipients".


Structure of the XML File


The XML file must be structured like the following example:


<Recipients>

 <Recipient>

   <Email>john.doe@example.com</Email>

   <Firstname>John</Firstname>

   <Lastname>Doe</Lastname>

   <Fullname>John Doe</Fullname>

   <Gender>Male</Gender>

 </Recipient>

 <Recipient>

   <Email>susan.doe@example.com</Email>

   <Firstname>Susan</Firstname>

   <Lastname>Doe</Lastname>

   <Fullname>Susan Doe</Fullname>

   <Gender>Female</Gender>

 </Recipient>

</Recipients>


The nodes Firstname, Lastname, Name and Gender are optional.

The node Gender can contain the values "Male" and "Female".

If you do not provide a gender, then Reply Assistant will detect the gender based on the name.