Remove internal Exchange address: If you are using an Exchange account, then you’ll also see some addresses in the x500 format. If it opened with everything in a single column, use the Data-> Text to Columns feature to get the 2 fields in separate columns.ģ. Remove duplicates: Open the csv-file in Excel.
Export “From Name” and “From Address” to a csv-file: In this example, we’ll use the Inbox folder as a source but you can use any other mail folder as well.Ģ.
