I'm looking for a way to implement keywords inside the body message.
The algorithm will read the body message and add the keywords inside the same body message.
Read > Extract the keywords by using the RemoveStopWords Function > Write the keywords inside the message body.
Keywords: Sales...
Understood. In this case, due the size of the field the best option I guess is to set as a Memo field.
StoreID =472 Characters
EntryID =140 Characters
And also I don't know if the quantity varies.
I am developing an Access database where I will save information from Outlook to one Access table.
Basically I will save the following data:
EntryID
StoreID
ReceivedTime
Subject
Sender
I would like to know what is the format for EntryID and StoreID?
Luthius
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?
Sub openOutlookEmailByAccess()
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
Sub openOutlookEmailByAccess()...
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...
Hi everyone
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.