OL98: (CW) How to use Excel as a Dynamic Distribution List
ID: Q192262
|
The information in this article applies to:
-
Microsoft Outlook 98
-
Microsoft Excel for Windows 95
NOTE: These procedures only apply if you have installed Outlook with the
Corporate Workgroup/Other option. This option allows you to use Messaging
Application Programming Interface (MAPI) services. To determine your
installation type, on the Help Menu click About Microsoft Outlook. In About
Microsoft Outlook you should see "Corporate" if you have the Corporate
Workgroup installation.
SUMMARY
This article describes how to use Microsoft Excel to create an e-mail
distribution list to use with Microsoft Outlook.
MORE INFORMATION
You can use Microsoft Excel to create and maintain an e-mail distribution
list to use with Outlook. In the spreadsheet you simply type full names, or
e-mail addresses, or e-mail aliases.
To use the worksheet as a source for e-mail names, the following conditions
must exist.
- Each address or name must be in one cell. You can't have the first name
in a cell and the last name in another, even if it is adjacent to the
first name cell.
- If you are using full names or e-mail aliases, the names must exist in
the address book of the mail server. This way the names will be resolved
to the correct e-mail addresses. This would be the case with MS Mail,
Lotus ccMail, and Microsoft Exchange Server.
Copy the Names From the Spreadsheet
- Click to select the names in the spreadsheet. Hold the SHIFT key
down while clicking to select consecutive names. To select specific
names from the spreadsheet hide the rows that contain
the names not to be included. See Excel Help for information
on how to hide rows.
- On the Edit menu, click Copy.
- Open a new mail message in Outlook.
- Click in the To address field, and on the Edit menu, click Paste.
- On the Tools menu, click Check Names, or simultaneously press CTRL+K to
resolve the names against the Global Address list.
Additional query words:
98
Keywords : kbinterop
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbhowto kbinfo
Last Reviewed: August 3, 1999