Recent content by Juliano

  1. J

    Implement Keywords based on body message

    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...
  2. J

    What is the best EntryID format to set on MS Access table

    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.
  3. J

    What is the best EntryID format to set on MS Access table

    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
  4. J

    Open an outlook email by Subject on MS Access linked table with VBA

    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...
  5. J

    Open an outlook email by Subject on MS Access linked table with VBA

    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()...
  6. J

    Open an outlook email by Subject on MS Access linked table with VBA

    Is there a way we can import all outlook table fields so we can get the proper email ID avoiding duplication? I really don't know how to proceed.
  7. J

    Open an outlook email by Subject on MS Access linked table with VBA

    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...
  8. J

    Open an outlook email by Subject on MS Access linked table with VBA

    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...
Back
Top