Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / May 2006

Tip: Looking for answers? Try searching our database.

Importing Outlook Alias info into an excel 2003 macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
fidgitthedigit - 30 May 2006 14:23 GMT
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 name@company.com and
the Alias: employee-number@server.com)

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

fidgitthedigit

Michael Bauer - 31 May 2006 05:30 GMT
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"?

Signature

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
[quoted text clipped - 10 lines]
>
> Can this be done?
fidgitthedigit - 31 May 2006 14:34 GMT
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.
Signature

fidgitthedigit

> Am Tue, 30 May 2006 06:23:01 -0700 schrieb fidgitthedigit:
>
[quoted text clipped - 18 lines]
> >
> > Can this be done?
Michael Bauer - 31 May 2006 15:42 GMT
Am Wed, 31 May 2006 06:34:02 -0700 schrieb fidgitthedigit:

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

Signature

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.
Ken Slovak - [MVP - Outlook] - 31 May 2006 16:22 GMT
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.

Signature

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

> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.