Format a .csv for Mail Merge

Heres a few tips to ensure you successfully upload your .CSV to Mail Merge.

 

In this section:

Step One:.CSV Best Practices

Step Two: Upload .CSV to ContactMonkey sidebar 

 

 

Step One: .CSV Best Practices 

  • First column is entitled "Email", and has the recipient's email addresses 
  • Emails formatted correctly: all have domains, no spaces before/after
  • Column Names: Must be one word, no spaces ( e.g. "Company Name" will not be accepted, but "Company" or "CompanyName" will)
  • NO duplicate email addresses 
  • remove columns not being used as a merge field 
  • File saved as CSV (Comma delimited) (*.csv) or .csv UTF-8

Upload CSV Limit

ContactMonkey has a limit of up to 10,000 recipients for any one .CSV file. 

 

Step Two: Upload .CSV to ContactMonkey Sidebar

Use ContactMonkey's CSV validator to ensure it is formatted correctly. To do so upload your CSV to the ContactMonkey sidebar.

Capture22.PNG Capture1.PNG

Feel free to download our sample CSV file as an example below.

Check out this video for a more detailed explanation!

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.