Exporting contacts to Mailchimp

In order to build your business, you may want to run a marketing campaign. For example, by sending an email to all customers or a subset of customers.

With Okappy and Mailchimp, this can be done in 3 quick steps.  Read on for step-by-step instructions.

1. Generate your contacts list

First determine who you want to market to. This could be your customers, subcontractors or even employees.

Once you have decided, download the relevant report from Okappy.  For further information see

2. Manipulate your list

Once you have your complete population, the next step is to determine who from that list you want to market to.

For example you could send an email to customers who you have not done any jobs for in the last 6 months or for those customers with site addresses in a certain geographical area.

3. Import your your finished list into Mailchimp

From within Mailchimp

  • Choose your audience.

mailchimp audiences

  • Click Add contacts and then Import contacts

mailchimp choose method

  • Select the option for CSV or tab-delimited text file
  • Click Continue To Setup >

mailchimp browse contacts

  • Click Browse and then find the spreadsheet containing your contacts
  • Click Continue to Match

mailchimp select columns

  • For each column in the spreadsheet, if you want to import it, select edit
  • Choose the relevant field you want to import into
  • Click Save to move onto the next field
  • If you don’t want to import the column, click Skip
  • Click Continue to Organize >

mailchimp organise

  • Add tags and choose the status of these contacts in Mailchimp
  • Click Continue to Review >

mailchimp all set

  • If you’re happy with the import, then choose Import

Your contact will be downloaded into your audience.  You can then create your campaign and send them to your audience.

Further information

For further information on creating campaigns on Mailchimp, check out their Mailchimp 101. For more information on the different reports you can generate from Okappy, check out our Okappy support pages.