Get email address from name
 

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 !
--
Arnaud

Get email address from name
 

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

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

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


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 !
--
Arnaud

Get email address from name
 

Michael Bauer [MVP - Outlook] wrote:
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
--
Arnaud

Get email address from name
 

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

No.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Michael Bauer [MVP - Outlook] wrote:
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
--
Arnaud

Get email address from name
 

Michael Bauer [MVP - Outlook] wrote:
Am Thu, 14 Sep 2006 09:11:22 +0200 schrieb Arnaud Lesauvage:
Is the current user always included in the contacts collection ?
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 !

Get email address from name
 

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

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

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Michael Bauer [MVP - Outlook] wrote:
Am Thu, 14 Sep 2006 09:11:22 +0200 schrieb Arnaud Lesauvage:
Is the current user always included in the contacts collection ?
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 !

Get email address from name
 

Michael Bauer [MVP - Outlook] wrote:
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 !

--
Arnaud