Copy email addresses from excel into outlook for mac

broken image
broken image

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’ You can use any list of email addresses to create a DL (or Contact Group), including from Excel or a custom view in Outlook (with only the display name and.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).

broken image

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. In Outlook when you send an email the address is remembered and added to an ‘auto-complete’ list.