I need to get vba to look at the name in column G and find the email in outlook global address list. Thanks
I need to get vba to look at the name in column G and find the email in outlook global address list. Thanks
There's a method called Resolve in Outlook. Try to look it up, and you'll be able to figure out how to get an email address from the global directory, by passing the name.. You must remember that if exactly same names exist in the global list, then you will not get a valid email ID.
Just refer to http://www.excelfox.com/forum/f2/out...nt-and-cc-628/ as a starting point.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Try this one as a test.
Remember that Fullname has to be exactly the same as in addresslist otherwise you recieve an errormessage.Code:Sub Read_Contact_Email() c00 = "Fullname" With CreateObject("Outlook.Application").GetNamespace("MAPI").GetDefaultFolder(10).Items(c00) c01 = .Email1Address End With MsgBox c01 End Sub
Bookmarks