Tuesday, February 12, 2013

How to Create a Distribution List to Import Into Outlook 2007


1. Open a blank Excel worksheet. Enter 'First Name' into cell A1. Enter 'Last Name' into cell B1. Enter 'Email Address' into cell C1.
2. Enter the first name of the first person you want to add to the distribution list into cell A2. Enter that person's last name and email address into B2 and C2. Enter the names and email addresses of all of the contacts you want to add to the distribution list into the cells in the appropriate columns.
3. Click the 'File' tab in Excel 2010. Click 'Save As.' Enter a name for the file, such as 'Distribution List,' into the File Name field. Change the 'Save as Type' to 'CSV (Comma Delimited).' Click 'Save.'
Import the List
4. Open Microsoft Outlook and select 'Contacts' in the navigation pane on the left. Right-click your contact list and select 'New Folder.' Enter a name that relates to your distribution list and click 'OK.' Double-click the new folder to open it.
5. Click the 'File' tab, select 'Open' and choose 'Import.'
6. Select 'Import from Another Program or File' and choose 'Next.' Select 'Comma Separated Values (Windows)' and click 'Next.' Click the 'Browse' button. Find and select the Excel file you created and click 'Open.'
7. Choose whether you want duplicates allowed and click 'Next.' Select the folder you created in your contact list and click 'Next.' Click 'Finish' to import your distribution list.
Create the Distribution List
8. Select the folder containing the list you imported.
9. Click on 'New' and select 'Distribution List' or 'Contact Group.'
10. Type a name for the distribution list into the Name field.
11. Click 'Select Members' or 'Add Members.' Select the new folder in the Show Names From list.
12. Click on the contact at the top of the list. Press and hold the 'Shift' key and select the contact at the bottom of the list to select all of the contacts. Click 'Members,' click 'OK' and click 'Save and Close' to save your new distribution list.

Blogger news