AngeloGregori
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.ActiveInspecto r.CurrentI tem.Sender EmailAddre ss
For outgoing message I use
Application.ActiveInspecto r.CurrentI tem.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
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.ActiveInspecto
For outgoing message I use
Application.ActiveInspecto
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's so much easier than I was thinking :o)
Chris
Chris
ASKER
Perfect, Thanks a lot.
You're welcome.
Chris