How to Export Your Autocomplete Contact List from Outlook and Import Email Addresses into MailChimp

Joe Engelking

Ready to Solve Your IT Problems and/or Protect Your Systems?

 

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” 

Chicago MSP help with email issues

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)

Outlook experts near Chicago, Illinois

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)

  1. Extract and install NK2Edit and then it will either find your autocomplete list or ask you to locate it
  2. 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
  3. Now open up Excel and Paste the contents
  4. 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”
  5. 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

 


[DISPLAY_ULTIMATE_PLUS]

AWARD-WINNING CYBERSECURITY AND I.T. SERVICES

TOP 10% OF ALL REVIEWED I.T. PROVIDERS
UPCITY TOP REVIEWED I.T. PROVIDER
EXPERTISE CURATED TOP PICK
DESIGNRUSH TOP CHICAGO I.T. PROVIDER
RANKED TOP 5 ON GOODFIRM’S TOP CYBERSECURITY PROVIDERS LIST
National IT & Cybersecurity Coverage
Managed IT Services
System Audits/Assessments
Design & Installation
Software Implementation
Custom Software Development
Remote Monitoring
24/7 On-Call Support
Cybersecurity
ISO Consulting
SOC Consulting
HIPAA Consulting
Systems Monitoring
Policy Development
Fraud Prevention
Data Protection
Tools
Download
Contact
Headquarters
Chicago, Illinois
847-496-5196
Schedule a Free Consultation