Exporting Contacts from Outlook, Yahoo, and Gmail to Import into the Address book

You can import email addresses into the Blackbaud NetCommunity Fundraiser Address book from various email programs such as Outlook, Yahoo, and Gmail. To import (BB491948) into the address book, you need the First Name, Last Name, and Email address fields formatted in a CSV file. Let's take a look at exporting out of each program:

From Microsoft Outlook:

1. Select File, Import and Export from the Outlook action bar.
2. In the Choose and Action to Perform field, select Export to File, and then click Next.
3. Select Comma Separated Values (Windows) and click Next.
4. Select the Contacts folder. Click Next.
5. Browse to the location where your export file will save and name your export file and then click Next.
6. Click Map Custom Fields beside the following actions will be performed field. Click Map Custom Fields.
7. Click Clear Map, and drag First Name, Last Name, and Email Address from the From box to the To box. Click OK and Finish.

From Yahoo!:

1. In the Yahoo! mail screen, click Options and then select Mail Options.
2. In the left navigation bar, click Contact Options.
3. Click Import/Export in the Management box.
4. Under the Export section, click Yahoo! CSV.
5. Save the export to a location on your workstation
6. Open the yahoo_ab.csv file. Rename cell A1 to First Name, cell to C1 Last Name, and cell E1 to Email Address.
7. Click the top left cell to select the entire spreadsheet, and then select Data, Filter, AutoFilter from the action bar.
8. Select (NonBlanks) in the dropdown for the First Name, Last Name, and Email Address columns.
9. Select the entire spreadsheet and press Ctrl+C on your keyboard to copy it.
10. Press Ctrl+N to open a new worksheet and press Ctrl+V on your keyboard to paste the copied cells.
11. Save this spreadsheet as your import spreadsheet and use it in your import.

From Gmail:

1. In the Gmail mail page, clic Contacts on the left navigation bar.
2. Click Export in the top right corner.
3. Select to export all contacts or only one group.
4. Select Outlook CSV and then click Export Contacts.
5. Save the file to your workstation
6. Open the Excel file. Because Gmail does not separate the contact name into first name and last name columns, you must separate the columns:
   1. Insert a new column between A and column B.
   2. Highlight column A and select Data, Text to Columns from the action bar.
   3. Select Delimited as the file type and then click Next.
   4. Mark Space as the Delimiter. Click Next, and then click Finish
7. Rename cell A1 as First Name, B1 as Last Name, and C1 as Email Address.
8. Save the spreadsheet and use it in your import.

Welcome to The Connector

Welcome to The Connector, the product blog for Blackbaud NetCommunity. The new blog that takes its moniker from the BBNC customer e-newsletter.

In the coming days, weeks, months, and years this blog will have a variety of contributors to talk about all things BBNC. From using the solution, to things on the white board in future releases, and just about everything in between.

Let's get started...