Can't expose sender email address when linking outlook to access

Status
Not open for further replies.

Brian Tyrrell

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
I am trying to link emails received in outlook 2016 to an access 2010 database, the clients records in the database are identified by their unique email addresses and I wish to link the client records and the linked outlook tables by exposing the "sender email field" in the outlook records. I have used Diane's excellent solution to expose the sender address in outlook but when I link the inbox to access it only links\exposes predefined fields and "Sender Email" is not one of them. Any suggestions very welcome.
 

Brian Tyrrell

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
Does it link to the 4 user fields? If so, copy the address to one of those field (User1 - User4). (It's been forever since i last linked to access and i don't recall if it does all fields or a subset.)
Hi Daine
Thanks for coming back to me. The issue is that I have over a thousand emails in my Outlook inbox and corresponding client records in Access, I use Access to record phone calls, assets held and link into to other third party data suppliers and wanted to create a linked table into Outlook Inbox so as to be able to see email received from the clients also, ergo linking on Sender Email address which would qualify as a one to many between the client record and the linked Inbox table.
You have identified the issue in your reply, the Linked Table Wizard in Access only exposes a predefined subset of the Outlook fields available regardless of the "columns displayed format" chosen in Outlook.

I imagine what I need to do is to find some way to define which fields are exposed in the linked table subset which links to Access.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
As far as I know, you can't change the fields that are linked. If you are only working in mail, then my user1 - user4 fields won't work as they are contacts, not mail, fields. :(
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
D Reply with a template loose the sender's embedded image Outlook VBA and Custom Forms 0
J Outlook 2016 How tell Outlook not to trust sender? Using Outlook 1
M Screen Scrape Sender IP Address Outlook VBA and Custom Forms 6
S Meeting Invite arrives from Wrong ("send-as") Sender Using Outlook 1
icacream Rule based on sender / wrong sender sent to folder Using Outlook 7
D Moving Emails Based on Recipient/Sender Outlook VBA and Custom Forms 4
B Looking to filter (or just find/search) for only messages that the sender has sent more than 1 messa Using Outlook 2
I How to display sender's name instead of email address in outlook 2013 message Using Outlook 5
A Sort emails into subfolders based on sender and deleting emails automatically Outlook VBA and Custom Forms 3
C Display Sender As Contact Outlook VBA and Custom Forms 4
Ed Sheehan Unusual behaviour in setting Sender (Outlook 2016) Outlook VBA and Custom Forms 4
J Auto Forward - Include Attachment and change Subject depending on original sender Outlook VBA and Custom Forms 3
Q Undisclosed recipients does not include sender Using Outlook 1
M Move new mail to folder based on sender address Outlook VBA and Custom Forms 2
D Inserting sender name and address with vba Outlook VBA and Custom Forms 1
M Blocked Sender List @Domain Not Working Using Outlook 0
P MS OUTLOOK 2013 - Adding Sender on the CC line Using Outlook 5
J Saving attachments from specific sender (phone number) to specific folder on hard drive Using Outlook 3
Diane Poremsky Use VBA to create an Outlook Search Folder for Sender New Slipstick.com Articles 0
K Extract email to excel from a specific sender Outlook VBA and Custom Forms 3
D Change sender name outlook vba 2010 Custom Userform Outlook VBA and Custom Forms 1
O See recent emails from a sender Using Outlook 2
S announce email sender and subject when new email arrives... Using Outlook 7
K check for sender, follow to my personal adress and delete the sent folder. Outlook VBA and Custom Forms 1
P Mail delivery failed returning message to sender Using Outlook 1
K Outlook moves sender's mail, but there is no rule Using Outlook 0
Diane Poremsky Sort messages by Sender domain New Slipstick.com Articles 1
B Find related messages to sender Outlook VBA and Custom Forms 7
B Find Related Emails to sender Using Outlook 1
Simon How does the sender/organizer to dictate the color of a meeting invitation. Using Outlook 3
V move emails to windows folder and show sender details Using Outlook 7
L Adding sender's e-mail to global address book DL Outlook VBA and Custom Forms 1
M How to call custom email form when sender = x Using Outlook 3
Digitally Hip Outlook 2010 (32) and Exchange 2010 (sp3) sender info not displaying in Outlook Using Outlook 1
K Outlook 2013 Multi Accounts set Default different calendar Sender Using Outlook 2
H Macro to file Outlook email by sender's email address Using Outlook 11
Steve Jacobs Possible to configure TNEF options based on *sender*? Exchange Server Administration 3
T How to remove "automatically delete messages form this sender"? Using Outlook 1
D Messages received from only one sender arrive with dark gray text background Using Outlook 1
E Add sender to distribution list? Using Outlook 3
L Auto Forward without presenting the original sender Outlook VBA and Custom Forms 1
D Macro for sorting email according to sender and subject Using Outlook 0
N How to know the email sender (windows logon profile) from a Shared Mailbox Using Outlook 2
K TextBox on Custom Form Page :: Passing value from sender to the recipient Outlook VBA and Custom Forms 1
D Outlook 2007 Find All Related and Messages From Sender not working Using Outlook 3
J outlook having sort by date or from unable to display sender name. Using Outlook 2
D Outbox will not send, error code 0X800CCC78 with 550 sender restricted. Using Outlook 3
S Outlook 2k/2k3 Reply or Forward: Signature image replaced by original sender Using Outlook 3
N Changed the "sender" account and lost all my text Using Outlook 2
T Find the sender who sent the mail from Generic Mailbox. Using Outlook 4
Similar threads


















































Top