A newsletter is a powerful marketing tool that can benefit by having as many email addresses in it as possible – so here is how to easily export every email address you’ve communicated within Outlook and then import it into MailChimp
Please Note: An Autocomplete List is different than a Contact List – Outlook builds a local cache of all the emails you have sent correspondence to – while a contact list is email addresses you have manually added as “contacts”
If you need a top managed IT services company to help with your Google Workspace, give LME a call
Exporting Contacts from Outlook is simple
- Open Outlook and click the File tab at the top left.
- At the top of the sidebar on the left, click Open & Export.
- Click Import/Export.
- Click Export to a file and click Next.
- Select Comma Separated Values and click Next.
- Select Contacts
- Name the file, select a folder, and then click Next and Finish
Exporting your autocomplete list is more work (but often more beneficial as it has way more email addresses)
How to export your Outlook Autocomplete list to CSV
The first thing you will need to do is download the program NK2Edit from here (scroll to bottom of page)
- Extract and install NK2Edit and then it will either find your autocomplete list or ask you to locate it
- Once NK2Edit has located your autocomplete list you will want to select all the email addresses (CTRL+A) and then choose “Edit” and “Copy Emails Only“
- Now open up Excel and Paste the contents
- You will have to clear out some bogus email addresses that you don’t want and then select “Save As” where it says “Save as Type” click the drop-down and choose “CSV”
- Save the file and now go into MailChimp to import the CSV into your lists
For more IT consulting services, click here.
Looking for a Cybersecurity Consulting Company, check us out
