It will look something like Stream_Autocomplete_ etc etc. You will need to manually browse to this location to find the file. The auto complete list is stored in the user profile, under %USERPROFILE%\AppData\Local\Microsoft\Outlook\ What if it didn’t find my auto-complete list? Under ‘Save as type’ choose ‘comma Delimited Text File (*.csv)’.Enter a name for the file under ‘File name’.Click on the ‘File’ menu then ‘Export Selected Items’.Select all the emails in the list (or the ones you want to export).It will automatically connect to the auto-complete list for the current user profile – if it does not, see below.Run NK2Edit.exe (if it doesn’t run, it’s possible your anti-virus software is incorrectly seeing it as a virus and stopping it from loading).Download NK2Edit (the ‘Download NK2Edit in a zip File’ link at the bottom of the page).How to export Outlook auto-complete to Excel Outlook doesn’t give you the option to export an auto-complete list, but with a third-party program called NK2Edit you can. This is a huge time saver, but what if you want to export the auto-complete list? The next time you type the email address into the ‘to’ field (as well as cc and bcc) – the auto-complete list appears, allowing you to select from the list instead of completely writing the address. Your email addresses will now all move over with commas which is how Mac Mail formats and. Click on the B column and add this text into the excel formula bar: A1&',' Double click the small dot in the bottom corner of the B cell. Open Excel and paste the email addresses into the A column.

In Outlook when you send an email the address is remembered and added to an ‘auto-complete’ list. Copy Multiple E-Mail Addresses Into Mac Mail.