CSV from Excel - Import to Mailchimp

1. Open “Test CarerMate_with_Macros-26-Feb.xlsm”
2. Go to CSV tab
   
   
3. Click viewà macrosàselect ExportCSV
   
   
   
4. Click on Run
5. It asks for range provide as below
   
   

And click OK

Prompts for file

Provide any name as below and save

It confirms the file is saved as below

Go to the CSV file location and open

It opens like this

MailChimp Part

Login to MailChimp

Click on Lists

Click import against the list

Select the file you saved and click on next

It automatically populates values as below

I am pasting the screenshots of each field (since I have predefined the structure in the list we don’t have to do anything in the list)

Click next

Click on Import

You can see 4 contacts were added.

Click on Templates

Select the list that is updated above

And send