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?