UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Outlook Connection To Access, Office 2010    
 
   
MrSpadman
post May 19 2020, 06:30 PM
Post#1



Posts: 11
Joined: 8-October 10



Hi,

I have successfully linked an Outlook inbox to an Access database. So far so good.

But when I open the linked table in Access I get a 'From' and 'Sender Name' column (both contain the sender's name) but no sender's email address.

Also, why isn't there a column that contains a unique ID that originates in Outlook?

Thanks,

Scott
Go to the top of the page
 
June7
post May 19 2020, 06:56 PM
Post#2



Posts: 1,412
Joined: 25-January 16
From: The Great Land


Sender email is in a property called SenderEmailAddress. Access does not include this field in link. It can be retrieved with VBA.

Outlook does not use a relational database. There is no facility for assigning unique ID.

Review https://www.lifewire.com/mail-calendar-stor...outlook-1173668

This post has been edited by June7: May 19 2020, 07:24 PM

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page
 
DanielPineault
post May 20 2020, 06:49 AM
Post#3


UtterAccess VIP
Posts: 7,343
Joined: 30-June 11



You'd have to use automation to Access individual item EntryId's.

The following may give you a starting point: https://www.devhut.net/2019/07/15/vba-extra...-mail-messages/

Also, for accessing certain information, you may need to get into extracting properties, ancestor properties, ... and this can only be done with VBA automation (especially things like 'Sent on behalf of').

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
June7
post May 20 2020, 11:50 AM
Post#4



Posts: 1,412
Joined: 25-January 16
From: The Great Land


I stand corrected. Outlook does generate a unique identifier - of 140 characters. Looks like:

000000008B42EDCA7F3D484CB47A140BB8E661DF0700CCC2AC6C95715D4393FE4BFD53D002AE0000
0000010C0000CCC2AC6C95715D4393FE4BFD53D002AE0003DDE869A10000

Forum breaks the string into 2 lines.

This post has been edited by June7: May 20 2020, 11:52 AM

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    28th May 2020 - 10:12 PM