Get email address from name

[Bingo]

Hi group !

I wonder how I can find an email address from a real name in VBA ?
I am tweaking a macro to export an appointment to an ics file, and
I need to set the "ORGANIZER:" field to "MAILTO:<organizer's email
address>".
The AppointmentItem.Organizer only contains the name of the
organizer, not his email.
Is there an easy way to do this ?

(Actually, the organizer is always the current user, so I kind of
need to retrieve the current user's email address, if it is easier
this way)

Thanks for your help !

 

[Michael Bauer [MVP - Outlook]]

Am Tue, 12 Sep 2006 11:20:04 +0200 schrieb Bingo:

Arnaud, you can search for the name in the contacts.

 

[Arnaud Lesauvage]

Am Tue, 12 Sep 2006 11:20:04 +0200 schrieb Bingo:

Arnaud, you can search for the name in the contacts.

Thanks Michael !
Is the current user always included in the contacts collection ?

Regards

 

[Michael Bauer [MVP - Outlook]]

Am Thu, 14 Sep 2006 09:11:22 +0200 schrieb Arnaud Lesauvage:

No.

 

[Arnaud Lesauvage]

Am Thu, 14 Sep 2006 09:11:22 +0200 schrieb Arnaud Lesauvage:
No.

Is there a way to retrieve the current user's email address then ?
All our appointment have their user as the organizer, so my macro
should retrieve his address !

 

[Michael Bauer [MVP - Outlook]]

Am Thu, 14 Sep 2006 14:59:40 +0200 schrieb Arnaud Lesauvage:

In OL 2003 you can read the Session.CurrentUser.Address property.

 

[Arnaud Lesauvage]

Am Thu, 14 Sep 2006 14:59:40 +0200 schrieb Arnaud Lesauvage:

In OL 2003 you can read the Session.CurrentUser.Address property.

In OL2000 too !!
Excellent !
Thanks a lot Michael !