I am developing an Access database where I will save information from Outlook to one Access table.
Basically I will save the following data:
I would like to know what is the format for EntryID and StoreID?
Well, I'm trying to use your suggestion as per code below. But is saying that a variable was not set. Err 91. Why is not working?
Dim OutLookApp As New Outlook.Application
Dim OutLookNameSpace As Outlook.NameSpace
Dim OutLookMail As Outlook.MailItem...
Scratching the helper, I could develop the code below.
Now my problem is the EntryID field that I don't have on my Access table because when using the assistant, the build in feature don't retrieve this field.
My problem now is how to import/link this field
When using the built in option to link my access table to outlook folder, it doesn't show any ID field for email. So manually there is no way to get this field from Outlook that's why my only option was the Subject field.
Actually the record exists on Outlook due its a linked table to Outlook...
I linked my Inbox folder to MS access table. It means that every time I open my access table, it is updated as per current emails in my inbox - It is already an built in feature on MS Access.
I would like to know on how from my MS Access, using the Subject field in my linked table I...