A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How to Get Username from Global Address Book



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2  
Old November 13th 09, 12:02 AM posted to microsoft.public.outlook.program_vba
Dmitry Streblechenko
external usenet poster
 
Posts: 2,116
Default How to Get Username from Global Address Book

Use ExchangeUser.Alias. Call AddressEntry.GetExchangeUser to get
ExchangeUser object - it will be null unless the item comes from GAL.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Benjamin" wrote in message
...
I l'd like to look up the username from a cell in Excel,
which would contain their full name.
Then populate the next cell with the username I looked up.

Example:
Smith, Trevor J
Woo, Thomas

alias:
smithtj
twoo

I need to use the global address book in outlook.
I'm fine with Excel code, but Outlook I haven't ever stepped into.

Can someone shed some light on this, maybe some code to get the user
alias,
from looking up the full name.

-Thanks in advance,



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
global address book Ernie Outlook - Using Contacts 5 December 29th 07 08:36 PM
Cant send mail to public address book listed in Global Address Lis Mike Outlook - Using Contacts 0 September 21st 07 03:26 AM
Global Address Book Charlie Outlook - Using Contacts 1 June 15th 07 10:01 PM
Global Address Book batgirl Outlook - Installation 0 February 9th 07 03:32 PM
? posting an item from Address Book [Global Address List] to a specific form and folder luckily Outlook - Using Forms 3 September 11th 06 10:01 PM


All times are GMT +1. The time now is 03:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.