Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning Outlook email addresses
I have the following code working - talking to outlook. However, whenever I
try to return the email address of the contact, I get 'object doesn't support this property or method' thanks for any help. Dim OLF As Outlook.MAPIFolder Dim olContactItem As Outlook.ContactItem Dim ToContact As Recipient Set OLF = GetObject("", "Outlook.Application").GetNamespace("MAPI").GetDef aultFolder(olFolderContacts) Set itms = OLF.Items For i = 1 To itms.Count Set itm = itms(i) strContactName = itm.LastName & ", " & itm.FirstName & " " & itm.MiddleName strEmail = itm.email Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding email addresses from Excel into Outlook | Excel Discussion (Misc queries) | |||
import email addresses into a outlook distribution list | Excel Discussion (Misc queries) | |||
How do I export email addresses from Excel to Outlook? | Excel Discussion (Misc queries) | |||
How do I export email addresses from excel to outlook? | Excel Discussion (Misc queries) | |||
Extracting email addresses from Outlook Contacts | Excel Programming |