How to display recipients' names in the 'To' field when sending emails with Mergo

By default, Mergo tries to extract names from email addresses. This works well with formats like firstname.lastname@domain.com  or firstname@domain.com . For example, an email like toto.shinnigan@gmail.com  would display as "Toto Shinnigan" <toto.shinnigan@gmail.com>.

If this default behavior is not enough for your need, follow these steps:

1. Prepare your data: Ensure you have a spreadsheet where one column contains the full names of the recipients and another column contains their email addresses.
2. Create a new column: In a new column, you will concatenate the names and email addresses.
3. Use a formula: If column A contains full names and column B contains email addresses, enter the following formula in cell C2:
   • =""" & A2 & """ <& B2 & ">"

   • Alternatively, you can use:

     =CHAR(34) & A2 & CHAR(34) & " <" & B2 & ">"

4. Apply the formula: Drag the fill handle down to apply this formula to the rest of the rows in your spreadsheet.
5. Select the new column in Mergo: When setting up your email campaign in Mergo, select the new column as the recipient column.

By following these steps, emails sent through Mergo will display the correct names in the "To" field.