how to upload CSV file on mailchimp
1. Make Sure the csv file is this format what I am showing on the video, For the column Address, Frequency, Duration, Addon/Stack Fee, Approval Add-on Fee, you can leave them blank
2. 2. But deadline, company name, first name, last name, email, approval amount, approval payment amount, payback== those column should be filled with data.. don't leave them blank on the csv
3. finaly go to mailchimp and from the top menu go for LIST and there is currently one list which I have modified.. (morgan cash LLC).. If you want to add a single data just click the + person icon on the right. and all required data to fill up will be available to you to manually enter them and save
4. But we are going for csv upload. Click on the List (Morgan Cash LLC) Currently it is showing 1 on the side of the List name because only one contact is there. Go to Add Contact to Import Contact ………. From next page select CSV radio button and click next. there is a file upload box where you should browse for the csv file you want to upload, then click next.. on the next screen don't do anything just simply click NEXT on the bottom (Everything I set it up for you here ).. On the next page VERY IMPORTANT... DONT FORGET TO TICK ON Auto-update my existing list. As we are manually entering deadline.. next time all you have to do is change the date while uploading the same csv file and only the deadline will change and everything will remain same on your mailchimp list. Click NEXT on this page of subscribe, unsubscribe
5. You can see all your data is in the list now. for template I name it Morgan Cash Final what you have to use
6. Now for the mass email sending or marketing lets create a campaigns.. Go to Campaign and click on Create Campaigns. Create an email. Name the Campaign Whatever you like. Now only have to fill up 4 things here. a) To : Click Add Recipients. and you can find your List (Morgan Cash LLC) and also personalized the to field like I did so that spam filters don't catch our mail :P
7. Save it and go for the next b) From : Just Do what I did here
8. Subject here you will put what you want to say in your mail subject in one two words
9. For the Content part: Select our MORGAN CASH FINAL template from Saved Template (You can preview it to see if everything works before sending.. that's what I did by enabling the top button on the template here) and that click save and exit on the bottom and you are done.. Now On the Campaign Page You can click on Send on the top right to send this mail to every recipient on the list and the data will be populated to the template from the file you have uploaded