Getting (internal) sender's account ID (userID)

  • Thread starter Thread starter ker_01
  • Start date Start date
Status
Not open for further replies.
K

ker_01

I've got some basic code that scrapes email sender, subject, and some

selected line contents and dumps them into Excel.

That data is then edited and uploaded into our Learning Management System

(LMS). In order to be uploaded, each record needs to include the employee's

numeric employee ID. The reference table I have that includes employee ID

also has their userID, but does not match up with with general sender name

due to the use of nicknames, maiden names, etc.

Given that these are internal employees in our own activedirectory(?), is

there any way to get Outlook to return the EmployeeID of the sender via VBA?

For example: I can draft an email inclduing recipients. If I right-click the

name of a recipient and click properties, the data I want to grab is contents

of the field "Alias" on the General tab. I don't know if that is included in

any hidden fields in the inbound email, or if I'd need a way to ping the

directory with each name to get the alias.

Note: it may be possible that we'd have two different people with the same

first and last name; their userID/alias and full email address would be

unique, but I can't guarantee that their common names would be unique, so any

ping might result in multiple returns, which further complicates this.

Can getting the alias/userID be done with VBA, and if so, can anyone give me

any pointers (what to look for in the help files, etc)? I'm not familiar with

the Outlook object model, but I'm willing to learn.

Thank you!

Keith
 
For reference, I'm writing the code on an 2003 machine, but it is intended to

also be used on 2007 machines.

"ker_01" wrote:



> I've got some basic code that scrapes email sender, subject, and some
> selected line contents and dumps them into Excel.

> That data is then edited and uploaded into our Learning Management System
> (LMS). In order to be uploaded, each record needs to include the employee's
> numeric employee ID. The reference table I have that includes employee ID
> also has their userID, but does not match up with with general sender name
> due to the use of nicknames, maiden names, etc.

> Given that these are internal employees in our own activedirectory(?), is
> there any way to get Outlook to return the EmployeeID of the sender via VBA?

> For example: I can draft an email inclduing recipients. If I right-click the
> name of a recipient and click properties, the data I want to grab is contents
> of the field "Alias" on the General tab. I don't know if that is included in
> any hidden fields in the inbound email, or if I'd need a way to ping the
> directory with each name to get the alias.

> Note: it may be possible that we'd have two different people with the same
> first and last name; their userID/alias and full email address would be
> unique, but I can't guarantee that their common names would be unique, so any
> ping might result in multiple returns, which further complicates this.

> Can getting the alias/userID be done with VBA, and if so, can anyone give me
> any pointers (what to look for in the help files, etc)? I'm not familiar with
> the Outlook object model, but I'm willing to learn.

> Thank you!
> Keith
 
You'd need to use an LDAP query to query the AD to get any internal data

like that. It really has nothing to do with Outlook. You can search for

information on LDAP queries to see how you will need to set up the query and

you'd need to know the internal data fields you want to query.

"ker_01" <ker01> wrote in message

news:92025226-6BE1-4A1D-B8B4-31298BEAD1E0@microsoft.com...
> For reference, I'm writing the code on an 2003 machine, but it is intended
> to
> also be used on 2007 machines.

> "ker_01" wrote:
>
>

>> I've got some basic code that scrapes email sender, subject, and some
> > selected line contents and dumps them into Excel.
>

>> That data is then edited and uploaded into our Learning Management System
> > (LMS). In order to be uploaded, each record needs to include the
> > employee's
> > numeric employee ID. The reference table I have that includes employee ID
> > also has their userID, but does not match up with with general sender
> > name
> > due to the use of nicknames, maiden names, etc.
>

>> Given that these are internal employees in our own activedirectory(?), is
> > there any way to get Outlook to return the EmployeeID of the sender via
> > VBA?
>

>> For example: I can draft an email inclduing recipients. If I right-click
> > the
> > name of a recipient and click properties, the data I want to grab is
> > contents
> > of the field "Alias" on the General tab. I don't know if that is included
> > in
> > any hidden fields in the inbound email, or if I'd need a way to ping the
> > directory with each name to get the alias.
>

>> Note: it may be possible that we'd have two different people with the
> > same
> > first and last name; their userID/alias and full email address would be
> > unique, but I can't guarantee that their common names would be unique, so
> > any
> > ping might result in multiple returns, which further complicates this.
>

>> Can getting the alias/userID be done with VBA, and if so, can anyone give
> > me
> > any pointers (what to look for in the help files, etc)? I'm not familiar
> > with
> > the Outlook object model, but I'm willing to learn.
>

>> Thank you!
> > Keith
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Getting Index from dropdown inserted on ribbon Outlook VBA and Custom Forms 3
e_a_g_l_e_p_i Question about installing my Gmail account on my iPhone but still getting messages downloaded to my desktop Outlook. Using Outlook 3
P now on office 365 but getting error messages about missing Outlook 2013 cache folders Using Outlook 2
W Outlook 365 I am getting the "Either there is no default mail client" error when I try to send an email on excel Office 365 Using Outlook 1
H Outlook 365 issue getting details from embedded files, crashing routine Outlook VBA and Custom Forms 0
A Links in email getting error message about group policy Using Outlook 4
Commodore Getting rid of "This computer only" Using Outlook 4
V Outlook 2016 Multiple recurring tasks getting created Using Outlook 0
P PST file is getting huge under POP 3 Using Outlook 2
N contact notepad 'style' getting changed after clicking and running Activities Using Outlook 2
S Outlook [Online - Office365] perfomance is getting affected when accessing the mails using Redemptio Using Outlook 1
D Close Oulook after sending emails via vba without outbox getting stuck. Outlook VBA and Custom Forms 1
C im getting a type mismatch error Outlook VBA and Custom Forms 3
William getting custom form to load category colors Outlook VBA and Custom Forms 4
C Getting back previous computer owner Outlook email Using Outlook.com accounts in Outlook 1
B Recipient of a forwared message getting multiple emails Using Outlook 2
S Outlook 2010 I am getting error code 0x8DE00006 'the operation failed'. outlook 2010 send/receive progress Using Outlook.com accounts in Outlook 2
S Mails getting downloaded multiple times Using Outlook 1
Rory Campion Not getting a warning when a shared calendar item has been updated by someone else Using Outlook 2
E Getting IMAP email into existing pst file Using Outlook 6
J Just installed Outlook 2010 on computer and user is getting a 0x80004005 error Using Outlook.com accounts in Outlook 1
R Getting a colleagues appointments and calendar entries Using Outlook 1
E Getting Outlook full name correct with AddressLayout Using Outlook 1
P I'm getting an error when opening Outlook "Mobile me stopped working Using Outlook 1
D Need Help with Script. Keep getting Runtime Error 438 BCM (Business Contact Manager) 4
R Need help getting BCM to work with my Outlook 2014 Using Outlook 4
D Help Getting Started? BCM (Business Contact Manager) 4
P I am getting an error msg = cannot open file access denied Using Outlook 3
K why is a user getting email respond for invite respond that she didn't set up. Using Outlook 3
B email getting cut off Using Outlook 9
L Need help getting calendar/contacts/tasks/notes back! Using Outlook 3
M Email Format getting changed to Plain Text Using Outlook 1
G Outlook 2013: Getting meeting invites in OWA format Using Outlook 9
M Getting messages from multiple email address Using Outlook 1
B not getting email from people Using Outlook 3
L Outlook 2010 - Keep getting "Corrupted File" Msgs Using Outlook 4
mrje1 Assigned Categories keep getting deleted in mail, bug? How to fix if possible? Using Outlook 5
Commodore Why some RSS feeds stop getting updates? Using Outlook 12
M All e mails seem to be getting blocked BCM (Business Contact Manager) 7
J Send/receive getting stuck Using Outlook.com accounts in Outlook 1
R Getting my Claendar additions to appear in Outlook Today Using Outlook 7
J Getting Contact Name to show on Calendar Using Outlook 2
D outlook getting stuck receiving Using Outlook 1
Y MICROSOFT OUTLOOK 2007 - i KEEP GETTING THE "ENTER NETWORK PASSWORD" BOX POPPING UP - IT IS ALREADY Using Outlook 4
T getting an error This file does not have a program associated with it for performing this action. C Using Outlook 7
C getting the subject line out of a mail Outlook VBA and Custom Forms 2
S Trying to install BCM 2010 x64, getting error BCM (Business Contact Manager) 8
Q I cannot start Outlook 2007 I keep getting this error: __'Cannot start outlook window. Invalid XML,the view cannot be loaded.' Using Outlook 3
N Getting the attachments in MailItem Outlook VBA and Custom Forms 1
S MAcro - Need help in getting the recipients in to filed / cc field toput in an array Outlook VBA and Custom Forms 4

Similar threads

Back
Top