Start a conversation

Export contacts into Excel List for Mailshot

How to export contact search into Excel for Mailshot

It is possible to run a contact search and then export the results of the search into MS Excel.
This MS Excel list can then be used as the basis of a mailshot by third party products such as Campaign Monitor, Mail Chimp, Survey Monkey, etc. The benefits of using such tools is that you can more easily design HTML mailshots where the content of the mailshot is the actual body of the email and contains pictures and media. Many of these tools also have analytical capabilities to allow you to see how many emails have been opened, read, delivered, etc.

How to Run Search and export into MS Excel.

1) From the workbench choose [Searching], [Contacts], then [New]

2) Once the search opens, specify the search criteria then press [Search] at the bottom left to return a list of contacts.
Once the list has been returned, give the search a name using the Description[         ]  field at the bottom of the screen.

3) Click the [tick All] button at the top left, to place a tick in the 'Inc' column next to every record you want to export.

4) Finally, click the small 'Printer' icon at the top of the screen, choose the 'email shot' option, then press [OK]
You will be required to enter a password, and then the details of your search will be exported to MS Excel, in the format:


Full name, Title, Forename, Surname, Company Name, Address, Postcode, email, Fax, Telephone


You may then save the MS Excel file, and import this into your chosen "Mass emailing" tool, such as Mail Chimp, Survey Monkey, Campaign Monitor, etc.


[Keywords: export contacts to CSV, export to mail, contact export to mail, mailshot, csv export ]

Choose files or drag and drop files
  1. Graeme Orchard

  2. Posted
  3. Updated