4 replies
by rpost Accepted solution
by robo_dev Accepted solution
File > Import and Export
See the aptly named article
"How to import contacts into Outlook from Excel"link below:
http://support.microsoft.com/kb/295664
by rpost Accepted solution
by zorrodidit Accepted solution
Here's a macro code that works for me in Excel 2007 and Outlook 2007, except it places the email address both under Name and Email in the Distribution List.
I have three columns of data in Excel, i.e. Company, Name, E-mail Address
Public Sub DistributionList()
Dim objOutlook As New Outlook.Application
Dim objNameSpace As Outlook.Namespace
Dim objDistList As Outlook.DistListItem
Dim objMail As Outlook.MailItem
Dim objRecipients As Outlook.Recipients
Set objNameSpace = objOutlook.GetNamespace("MAPI")
Set objDistList = objOutlook.CreateItem(olDistributionListItem)
Set objMail = objOutlook.CreateItem(olMailItem)
Set objRecipients = objMail.Recipients
objDistList.DLName = InputBox("Enter name of Distribution List")
For i = 1 To Cells(ActiveSheet.Rows.Count, 1).End(xlUp).Row
objRecipients.Add (Range("C" & i).Value)
Next i
objDistList.AddMembers objRecipients
objDistList.Display
objRecipients.ResolveAll
Set objOutlook = Nothing
Set objNameSpace = Nothing
Set objDistList = Nothing
Set objMail = Nothing
Set objRecipients = Nothing
End Sub
This discussion is closed to new replies.
Trending Software posts
Sort by Trending