|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
September 12th 06, 11:20 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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 
|
|
#2
September 13th 06, 06:47 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
|
#3
September 14th 06, 09:11 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
|
#4
September 14th 06, 02:40 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
|
#5
September 14th 06, 02:59 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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 !
|
|
#6
September 15th 06, 07:18 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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 !
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook should alllow sorting address book by email address. | Henry Morgan | Outlook - Using Contacts | 1 | August 1st 06 07:48 PM |
| Can I automatically save email address to address book from inbox | 1stCaravanHire | Outlook - Using Contacts | 2 | June 14th 06 04:18 PM |
| How do I make a new email address supercede an old email address? | dhbirt | Outlook - Using Contacts | 3 | May 13th 06 05:38 AM |
| Outlook 2002 Uses email address not in Contacts or Address book | Pagen | Outlook - Using Contacts | 1 | February 1st 06 06:11 PM |
| Set which local email account can send mail to contacts in address book. (associating an email address with a contact) | Scott Streit | Outlook - General Queries | 3 | January 27th 06 03:57 PM |
Hybrid Mode
