Importing Outlook Alias info into an excel 2003 macro

[Guest]

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 (e-mail address removed) and
the Alias: (e-mail address removed))

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?

 

[Michael Bauer]

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"?

 

[Guest]

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.

 

[Michael Bauer]

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

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

 

[Ken Slovak - [MVP - Outlook]]

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.