I currently have about 200 users fill in online reports by having them click
an Excel 2003 attachment in an e-mail or calendar entry. This executes a
macro that, among other steps, asks for their employee number which is
actually their Alias in their Outlook properties, as each user has their
individual report file different from all the other users (i.e. everyone in
this organization has two e-mail addresses: the usual and
the Alias: )

Ideally I would like to have the Excel Macro obtain that Alias info
automatically without the user having to enter it as this will speed up the
process and avoid 'subscript out of range' errors or postings to the
incorrect report.

Can this be done?
--
fidgitthedigit

Am Tue, 30 May 2006 06:23:01 -0700 schrieb fidgitthedigit:

Yes, I think it can be done. What is the "Alias in their Outlook
properties"?

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


I currently have about 200 users fill in online reports by having them
click
an Excel 2003 attachment in an e-mail or calendar entry. This executes a
macro that, among other steps, asks for their employee number which is
actually their Alias in their Outlook properties, as each user has their
individual report file different from all the other users (i.e. everyone
in
this organization has two e-mail addresses: the usual and
the Alias: )

Ideally I would like to have the Excel Macro obtain that Alias info
automatically without the user having to enter it as this will speed up
the
process and avoid 'subscript out of range' errors or postings to the
incorrect report.

Can this be done?

The Alias is found under "Outlook Properties" in the General tab. In our
organization, this is always a six-character item either 6 digits or the
letter E followed by five characters.
--
fidgitthedigit


"Michael Bauer" wrote:

Am Tue, 30 May 2006 06:23:01 -0700 schrieb fidgitthedigit:

Yes, I think it can be done. What is the "Alias in their Outlook
properties"?

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


I currently have about 200 users fill in online reports by having them
click
an Excel 2003 attachment in an e-mail or calendar entry. This executes a
macro that, among other steps, asks for their employee number which is
actually their Alias in their Outlook properties, as each user has their
individual report file different from all the other users (i.e. everyone
in
this organization has two e-mail addresses: the usual and
the Alias: )

Ideally I would like to have the Excel Macro obtain that Alias info
automatically without the user having to enter it as this will speed up
the
process and avoid 'subscript out of range' errors or postings to the
incorrect report.

Can this be done?

Am Wed, 31 May 2006 06:34:02 -0700 schrieb fidgitthedigit:

Sorry, I don´t know what field you´re talking about.

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


The Alias is found under "Outlook Properties" in the General tab. In our
organization, this is always a six-character item either 6 digits or the
letter E followed by five characters.

It sounds like you're talking about reading an Exchange GAL, is that
correct?

You would have to get that as an AddressList, get its AddressEntries
collection and then use MAPI properties to extract that since it's not
exposed directly in the Outlook object model. CDO 1.21 or Extended MAPI or
Redemption (www.dimastr.com/redemption) could be used.

An alternative would be to extract the alias from the Exchange DN that you
could get from the Address property of the AddressEntry object. In untrusted
code that would fire the security prompts however unless you used something
like Redemption code.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"fidgitthedigit" wrote in message
...
The Alias is found under "Outlook Properties" in the General tab. In our
organization, this is always a six-character item either 6 digits or the
letter E followed by five characters.
--
fidgitthedigit