Get email address from name


B

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

Advertisements

M

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.
 
A

Arnaud Lesauvage

Michael said:
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
 
M

Michael Bauer [MVP - Outlook]

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

No.
 
A

Arnaud Lesauvage

Michael said:
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 !
 
M

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.
 
Ad

Advertisements

A

Arnaud Lesauvage

Michael said:
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 !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top