|
| 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
May 31st 06, 04:22 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Importing Outlook Alias info into an excel 2003 macro
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 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Importing Outlook Alias into an Excel 2003 macro | fidgitthedigit | Outlook - General Queries | 2 | May 30th 06 02:11 PM |
| Excel macro to create e-mail in Outlook Web Access | fitful_thought | Outlook - General Queries | 0 | April 15th 06 10:23 AM |
| Outlook 2003: While importing contacts from Excel 2003, ISAM error | Juzar | Outlook - Using Contacts | 1 | April 10th 06 10:20 PM |
| Outlook 2003 when importing from Excel | Renae | Outlook - Using Contacts | 4 | March 4th 06 03:41 AM |
| Importing from Excel 2003 to Outlook 2003 | Andrew H | Outlook - Calandaring | 0 | February 15th 06 10:30 AM |
Hybrid Mode
