Share

Add Your Outlook Contacts to Barracuda Whitelist

These steps will allow you to export your Outlook Contacts to Excel. You can then cleanup the email addresses and add them to your Barracuda Whitelist.

Note: The Export steps will walk you through exporting only the main email Address value for a contact. If you want to gather other addresses, Examples: E-mail 2 Address, E-mail 2 Address, you can repeat the export process to gather these addresses. The E-mail Address Cleanup in Excel is much easier if you are only dealing with a single column of data.

Export Steps for Outlook 2013 and Outlook 2016

  1. Click the File tab, and then select Options.
  2. In the navigation pane (left pane), click Advanced.
  3. In the Export section, click the Export button.
  4. Click Export to a file. Click Next.
  5. In Create a file of type, choose Comma Seperated Values.  Click Next.
  6. In Select folder to export from, scroll up and select the Contacts folder. Click Next.
  7. Click Browse.
  8. Name the file EXPORT CONTACTS. Click OK. Click Next.
  9. Click the Map Custom Fields button.
  10. Click Clear Map.
  11. From the left side, scroll down to locate E-mail. Click the plus sign ( + ) next to E-mail to expand the choice.
  12. Drag the E-mail Address value to the right side of the dialog box. Click OK.
  13. Click Finish. Click OK. You can now go to the E-mail Address Cleanup section.

Email Address Cleanup

Note: These steps assume that you will be using either Excel 2013 or Excel 2016.

  1. Open EXPORT CONTACTS.xls.
  2. Right-click on Row 1 and choose Delete.
  3. Click the A COLUMN ID (the entire column should become selected).
  4. In the Cells group, click Format and then select AutoFit Column Width.
  5. In the Editing group, click Sort & Filter and then select Sort A to Z.
  6. Save the file.
  7. Click the Data tab.
  8. In the Data Tools group, click Remove Duplicates. Column A should be checked. Click OK.
  9. If any duplicates are found, you will be told. Click OK.
    Note: To use these addresses for the Barracuda Whitelist, the addresses must be in the format of username@domainname. Examples: abc1@psu.edu, redcross-email@usa.redcross.org
  10. Perform cleanup on the addresses. Delete any rows that don't have valid E-mail addresses.
  11. When you are finished editing, Save the file.

Note: Use the steps in the following How To to add the email addresses of your Contacts to your Barracuda Whitelist.