Outlook Contacts Export Guideline How to export your Outlook contacts

1. Outlook ContactsExportGuidelineHowtoexportyour Outlook contacts

2. Export contacts from Outlook Steps to export from Outlook 2007/2010 (For OWA, skip ahead): • Summary of Steps (please see following pages for screenshots): • For Outlook 2007, Select File | Import and Export from the File menu. For Outlook 2010, Select File tab, Open | Import from the File menu. • Make sure Export to a file is highlighted. Click Next >. • Now make sure Comma Separated Values (Windows) is selected. Click Next > again. • Highlight the Contacts folder. Click Next >. • Use the Browse... button to specify a location and file name for the exported contacts. Something like "Outlook.csv" or "ol-contacts.csv" on your Desktop should work fine. Click Next > (once more). • Confirm the action item Export "Contacts" from folder: Contacts is checked. Click on Finish and the data will be exported. Back to Contents

3. Export contacts from Outlook Outlook 2007 Instructions (For OWA, skip ahead): • Step – 1: Select “File” | “Import and Export” from the File menu. Back to Contents

4. Export contacts from Outlook Outlook 2010 Instructions (For OWA, skip ahead): Step – 1: Select the File tab, then select “Open” | “Import” from the File menu. Back to Contents

5. Export contacts from Outlook Outlook 2007 & 2010 Instructions (For OWA, skip ahead): Step 2: Click on "Export to a file“. It should be highlighted. Click Next >. Back to Contents

6. Export contacts from Outlook Outlook 2007 & 2010 Instructions (For OWA, skip ahead): Step 3: Select Comma Separated Values (Windows) or Microsoft Excel 97-2003 for an Excel file. Click Next > Back to Contents

7. Export contacts from Outlook Outlook 2007 & 2010 Instructions (For OWA, skip ahead): Step 4: Select the Contacts folder to export from. Click Next > Back to Contents

8. Export contacts from Outlook Outlook 2007 & 2010 Instructions (For OWA, skip ahead): Step 5: Specify the folder and filename for the export file. Click on Next > Back to Contents

9. Export contacts from Outlook Outlook 2007 & 2010 Instructions (For OWA, skip ahead): Step 6: Confirm the action item is checked. Click on “Finish” and the data will be exported. Back to Contents

10. Export contacts from Outlook Outlook Web Access (OWA) Instructions: Outlook Web Access does not come with an export feature but you can manually copy the contact information into a file. Extracting Contacts From Outlook Web Access Involves Two Primary Sets of Steps: Extracting Contacts From Outlook Web Access(six steps) Moving the Contacts to Excel(thirteen steps) Back to Contents

11. Export contacts from Outlook Outlook Web Access (OWA) Instructions: Outlook Web Access does not come with an export feature but you can manually copy the contact information into a file. Manually extracting contacts from Outlook Web Access involves two primary sets of steps: Extracting Contacts From Outlook Web Access(six total steps) Moving the Contacts to Excel(thirteen total steps) Back to Contents

12. Export contacts from Outlook Outlook Web Access (OWA) Instructions: Extracting Contacts From Outlook Web Access To manually copy the contact information into a text file: Click the folder in Outlook Web Access that contains your contacts. You will see the contact details, such as name, email address, etc. Click and drag your cursor so that you have selected the contacts. Click Edit | Copy to copy the information. Open a plain text file (TXT) in a program such as Notepad. Click Edit | Paste to paste the information.Note: If you have many contacts, Outlook Web Access may split them into several pages. Click the page arrow and repeat these steps until you have copied the contacts from all pages into the text file. Click File | Save As. Save the text file to somewhere you can easily locate it. Next, you will move the list into Microsoft Excel for easy uploading. Back to Contents

13. Export contacts from Outlook Outlook Web Access (OWA) Instructions: Moving the Contacts to Excel To transfer the contact information into Microsoft Excel: Open Excel, which should open a new file by default. Click Data | Import External Data | Import Data. Select the text file that contains your contacts. An import wizard will appear. Choose "Delimited" and click Next. Under Delimiters, choose Tab and Space and click Next. Click Finish. Choose Existing Worksheet. The contacts should now appear properly split into multiple columns in Excel. Go to next slide to continue... Back to Contents

14. Export contacts from Outlook Outlook Web Access (OWA) Instructions: Moving the Contacts to Excel Move the email address to the first column for ease of import. You can also label your columns, though this is optional. Click File | Save As. Under Save As Type, choose CSV (Comma Delimited or *.csv). Save the text file to somewhere you can easily locate it. Click OK on the message "The selected file type does not support workbooks that contain multiple sheets". Your contacts are now ready to be converted into the required format to import into DonorCommunity. Back to Contents

15. Export contacts from Outlook Remaining Steps to be Performed: • Export contacts from Outlook • Modify the exported file to conform to DonorCommunity import file • Import into DonorCommunity Back to Contents

16. Export contacts from Outlook Remaining Steps to be Performed: To complete the remaining steps, simply follow the instructions in the CRM Upload Guideline that you have been provided! Back to Contents

17. If you need any assistance, please contact us at support@donorcommunity.com Back to Contents