Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
![]()
Below is the example from VBA help that shows how to add members. I don't
find it intuitive but it is the way it is. Sub AddNewMembers() Dim myOlApp As New Outlook.Application Dim myNameSpace As Outlook.NameSpace Dim myDistList As Outlook.DistListItem Dim myTempItem As Outlook.MailItem Dim myRecipients As Outlook.Recipients Set myNameSpace = myOlApp.GetNamespace("MAPI") Set myDistList = myOlApp.CreateItem(olDistributionListItem) Set myTempItem = myOlApp.CreateItem(olMailItem) Set myRecipients = myTempItem.Recipients myDistList.DLName = _ InputBox("Enter the name of the new distribution list") myRecipients.Add myNameSpace.CurrentUser.Name myRecipients.Add "Dan Wilson" myRecipients.ResolveAll myDistList.AddMembers myRecipients myDistList.Save myDistList.Display End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I create a probability distribution in excel? | Excel Worksheet Functions | |||
can i create normal distribution curves in excel? | Excel Discussion (Misc queries) | |||
Creating Outlook Distribution List | Excel Discussion (Misc queries) | |||
How do I create an Outlook distribution list from an Excel column | Excel Discussion (Misc queries) | |||
How do I move excel address lists to outlook. and vice versa. | Excel Discussion (Misc queries) |