| To copy the email addresses from your Microsoft | | | | and addresses you wish to copy. After selecting |
| Outlook distribution lists and paste them into | | | | them, select Edit/Copy. |
| Microsoft Excel, complete the following steps: | | | | After they are copied, you can then paste the |
| Open Outlook and select contacts. You will need to | | | | contents into Microsoft Excel by selecting Edit/Paste. |
| locate your distribution list within your contacts. If | | | | You may need to clean up the format but this beats |
| you don't see them, change you view by selecting | | | | typing the entire distribution list all over again. |
| View/Current View/Address Cards. This view gives | | | | This article is helpful if you plan to do a mass email |
| you a good view of the card details so they are | | | | mailing from Microsoft Word. Saving the information |
| easily identifiable. Once located, open the distribution | | | | from Outlook into Excel allows you have a source for |
| list. | | | | the email addresses when prompted by Word. This is |
| Select File and then select Copy to Folder. (If you are | | | | helpful because you can select some or all of the |
| using Outlook 2007, you will need to add this copy to | | | | information from the Outlook list. |
| folder button onto your ribbon). Once you have | | | | You may need to use the TRIM function to cleanup |
| selected the Copy to Folder button, click on OK. | | | | the email addresses. |
| The contents of your list is now contained in an email | | | | Instructions on using functions will be published in |
| style document. To select the names and email | | | | future articles. |
| addresses, use your mouse and drag over the name | | | | |