G
Guest
Hi!
I have a problem I am working on for a long time with no success.
In a userform I wrote code in VBA to read a current email body and send it
to a table in access.
Everything works fine. The only problem is when I read the address:
in Inbox: the address "To" ("From" I was able to read)
in Sent Items: the address "From" ("To" I was able to read)
I usually use the mailItem.To and mailItem.SenderEmailAddress and they work,
but if there is a name of a customer instead of the address, I get the name!
(and I need the address!)
I searched in outlookcode site and checked many code examples, but as I
said, no success.
Please, can anyone help???
Thanks,
Yonina.
I have a problem I am working on for a long time with no success.
In a userform I wrote code in VBA to read a current email body and send it
to a table in access.
Everything works fine. The only problem is when I read the address:
in Inbox: the address "To" ("From" I was able to read)
in Sent Items: the address "From" ("To" I was able to read)
I usually use the mailItem.To and mailItem.SenderEmailAddress and they work,
but if there is a name of a customer instead of the address, I get the name!
(and I need the address!)
I searched in outlookcode site and checked many code examples, but as I
said, no success.
Please, can anyone help???
Thanks,
Yonina.