Try
Note: Your code was incomplete. It is missing GetCurrentItem()myRecipient = oMail.Recipients.Item(1).AddressEntry.GetExchangeUser.Firstname
Try
Note: Your code was incomplete. It is missing GetCurrentItem()myRecipient = oMail.Recipients.Item(1).AddressEntry.GetExchangeUser.Firstname
To debug, mouse-click anywhere in the code. Press F8 repeatedly to step through the code. http://www.cpearson.com/excel/DebuggingVBA.aspx
If your problem has been solved in your thread, mark the thread "Solved" by going to the "Thread Tools" dropdown at the top of the thread. You might also consider rating the thread by going to the "Rate Thread" dropdown.
Posting Permissions
Reply With Quote