Retrieve my E-Mail Address in VBA

[Scorcel]

Anybody please help me how to retrieve my e-mail address
using Visual Basic Code or VB?

Thank you very much.

 

[Michael Bauer]

Hi,

it´s in Application.Session.CurrentUser.Address

 

[Scorcel]

Thanks a lot for your help, but it only shows my Complete
Name and not my complete e-mail address (like
(e-mail address removed))

Again thanks a lot!

 

[Michael Bauer]

Ok, that should work with CDO 1.21.

("Should" because I´m a little confused at present: My own CurrentUser
tells me, I´m unknown?!)

--
Viele Grüße
Michael Bauer


Thanks a lot for your help, but it only shows my Complete
Name and not my complete e-mail address (like
(e-mail address removed))

Again thanks a lot!

 

[Sue Mosher [MVP-Outlook]]

It's somewhat dependent on the Outlook version, as well as the profile
accounts. Most recent versions don't report a CurrentUser address, unless
it's an Exchange profile.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Scorcel]

OK, Again thanks so much.

-----Original Message-----
Ok, that should work with CDO 1.21.

("Should" because I´m a little confused at present: My own CurrentUser
tells me, I´m unknown?!)

--
Viele Grüße
Michael Bauer


Thanks a lot for your help, but it only shows my Complete
Name and not my complete e-mail address (like
(e-mail address removed))

Again thanks a lot!


.

 

[Michael Bauer]

Hi Sue,

thanks. I´m still working with OL2k without Exchange. Via the Outlook
object model there is a CurrentUser address, via CDO it isn´t.

 

[Scorcel]

But my Outlook is in the Mail Exchange and I could not see
my email address using the code you gave. Thanks again.

 

[Michael Bauer]

Did you try it via CDO?


--
Viele Grüße
Michael Bauer


But my Outlook is in the Mail Exchange and I could not see
my email address using the code you gave. Thanks again.

 

[Guest]

OK so which is it?

All I want to do is compare the to e-mail address with my own one, if we can
do this in CDO, has anyone got a few sample code lines?

 

[Sue Mosher [MVP-Outlook]]

Outlook version and mail server(s)?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Running Outlook 2003, with exchange 2003, I have now started to look and see
if redemption can help me at all. It appears there is a parameter in RAW mapi
PR_SMTP_ADDRESS, I suspect this is the parameter I am after, I now have
redemption installed, where do I find values for all the hex codes used?

 

[Sue Mosher [MVP-Outlook]]

PR_EMAIL (&H39FE001E) is the field you want to use. (You can also use CDO
1.21 instead of Redemption). See
http://www.outlookcode.com/d/code/getsenderaddy.htm#redemption and
http://www.cdolive.com/cdo5.htm#EMailAddressOfSender for general examples
using an AddressEntry object.

See http://www.cdolive.com/cdo10.htm for a general primer on MAPI
properties.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers