How to Get Username from Global Address Book

Status
Not open for further replies.
B

Benjamin

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,
 
Use ExchangeUser.Alias. Call AddressEntry.GetExchangeUser to get

ExchangeUser object - it will be null unless the item comes from GAL.

Dmitry Streblechenko (MVP)

-

"Benjamin" <Benjamin> wrote in message

news:F8ECB0BE-31C6-4B40-9388-B20C1A6582C3@microsoft.com...
> 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,
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Rupert Dragwater Outlook began asking for username and password Using Outlook 9
C Outlook 2010 keeps asking for username and password Using Outlook 1
C Outlook 2016 Username Not Working in Scheduling Assistant (Cache Mode) Using Outlook 0
T Exchange setup not possible with outlook.de username Using Outlook.com accounts in Outlook 0
P Constant Username Password Prompt Using Outlook 2
smokiibear windows security mail application not accepting username and password Using Outlook 0
C Problem accessing events for folder "username" Server Threw Exception Using Outlook 1
K Outlook keeps prompting for Microsoft username and password for share calendar Using Outlook 0
S Script to parse email subject, get Username, look up in GAL and redirect email Exchange Server Administration 6
B [SOLVED] Forced to type Domain/username for OWA 2003 with IE 7 or 8 Exchange Server Administration 3
L Exchange Management Console - Initializtion failed on Logon Failure: unknown username or bad passwor Exchange Server Administration 4
Diane Poremsky How to perform a global search and replace Using Outlook 0
I Global variables in ThisOutlookSession Outlook VBA and Custom Forms 1
Diane Poremsky Hiding Global Address Book Fields Using Outlook 0
E Are reminders local or global? Using Outlook 2
L Adding sender's e-mail to global address book DL Outlook VBA and Custom Forms 1
F Outlook 2010, reading pane, global settting for fields? Using Outlook 1
S change default contact list in Outlook 2010 to "contacts" rather than "global" Exchange Server Administration 1
C How do I hide distribution list from global contacts for certain users? Exchange Server Administration 1
H Cannot share calendar, global address book not updating Exchange Server Administration 1
K Extract Global Address List Using Outlook 1
R Outlook 2003 - Exchange 2010 global address list not updating Using Outlook 3
L How do I set up or transfer a distribution list into Global contac BCM (Business Contact Manager) 1
D Accessing Global Address List details with VBA Outlook VBA and Custom Forms 1
P Email address auto-completes work fine on laptop, but no longer on desktop Using Outlook 2
H Copying email address(es) in body of email and pasting in To field Outlook VBA and Custom Forms 1
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
Rupert Dragwater How to permanently remove an email address Using Outlook 9
Bardiferous Weird Contacts Behavior - Can't find any in any address book, but they're in there Using Outlook 3
L Specific Incoming Email Address Immediately Deleted Using Outlook 2
L Unable to Use Alias as From Address Using Outlook 2
H Preventing the 'email address fetch from Exchange' crashing email reading code Exchange Server Administration 0
D multiple email accounts - why do I have to choose the "from" account address?? Using Outlook 2
whizzard Change FROM address based on TO or CC address Outlook VBA and Custom Forms 8
C Outlook FROM ADDRESS -Outlook.com and Android Using Outlook 1
O What would be the recommended way to change an email address (family member)? Using Outlook 0
L Checking Sender Email Address for trusted domain from list on intranet Outlook VBA and Custom Forms 4
J How do you disable address search box when typing @ in body of email? Using Outlook 0
Victor.Ayala Automated way to check the option "Show this folder as an email Address Book" Outlook VBA and Custom Forms 2
D Wrong email address in Outlook 2003 "From" tab in new outgoing emails Using Outlook 4
M Gmail address associated with Outlook on new phone Using Outlook 9
e_a_g_l_e_p_i Outlook 2010 How to set default email address for website links Using Outlook 3
O Same email address, same person, names in so many ways Using Outlook 4
R Capture Sender's Display name and Address Outlook VBA and Custom Forms 3
D auto forward base on email address in body email Outlook VBA and Custom Forms 0
N contact list seen in Contact folder but knot in Address book or when 'TO' button is clicked in new email Using Outlook 0
C WARNING - DO NOT USE AN OUTLOOK.COM ADDRESS FOR GOOGLE ACCOUNT RECOVERY EMAIL Using Outlook 10
D Outlook Address Book Using Outlook 0
Terry Sullivan Sender Field Displays My E-Mail Address, Not My Name Using Outlook 1
L Email with correct To address but displaying name of a related person Using Outlook 0

Similar threads

Back
Top