Link to home
Start Free TrialLog in
Avatar of AngeloGregori
AngeloGregoriFlag for Italy

asked on

Manage outgoing messages from VBA in ooutlook 2003

Hello,

I'm writing two macros that archive some ingoing message and outgoing message from outlook 2003, based on email of the sender or the destination.
For incoming messages I've no problem: I open the message from VBA and I can find the email address in: Application.ActiveInspector.CurrentItem.SenderEmailAddress
For outgoing message I use
Application.ActiveInspector.CurrentItem.To
Some time I get the email address, but some time I get a person name, i.e. 'Mark Brown' instead of mark.brown@gmail.com.
There is a way to get the email address every times? I've explored the outlook data model without finding a property telling the address.
Thanks in advance.
Angelo

Avatar of Chris Bottomley
Chris Bottomley
Flag of United Kingdom of Great Britain and Northern Ireland image

I presume mark brown is a recipient in the exchange server?  If so then yes it can be worked around

Chris
ASKER CERTIFIED SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That's so much easier than I was thinking :o)

Chris
Avatar of AngeloGregori

ASKER

Perfect, Thanks a lot.
You're welcome.