- In new Outlook for Windows, Outlook on the web or Outlook.com, select People on the side panel.
- On the ribbon, select Export contacts, or Manage contacts then
Export contacts in Outlook on the web and Outlook.com. - In the dropdown, select All contacts, or the folder that holds the contacts you email.
- Select Export: the .csv file lands in your Downloads folder.
Tip
PricklyMails only needs the addresses: open the file in a spreadsheet, keep the email address column alone, and delete its header row before moving on.
Tip
In classic Outlook, the export is a wizard: select File then
- Import or export contacts in Outlook using a .csv file (opens in a new tab)support.microsoft.com
- Export contacts from Outlook.com or Outlook on the web (opens in a new tab)support.microsoft.com