Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2020
    Posts
    1

    Outlook Email Attachment Logging in Access

    Hi everyone, I'm pretty new to Access but I was hoping to get some help with something I'm working on.

    I have an Access database that shares a linked table with a folder in Outlook. Messages are sent to the Outlook folder which contain no subject or body but an attachment with the same file name every time, containing .csv text. How can I get Access to read the Outlook email attachments as well as the email data?



    Any help is well appreciated

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,114
    You will probably still need to use OLE automation to get the attachments and import them (you can get the "email data" at that time too which I assume you refer to the email message body). There are multiple examples on the web and Access forums with VBA code for Outlook. Please feel free to use my free utility which should provide you with a good starting point:
    http://forestbyte.com/ms-access-util...ook-companion/

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 07-12-2018, 05:38 AM
  2. Importing Outlook Attachment into Access Table
    By MTSPEER in forum Programming
    Replies: 8
    Last Post: 08-08-2017, 12:06 PM
  3. Add attachment to Outlook Email from Table?
    By floyd in forum Programming
    Replies: 3
    Last Post: 11-27-2013, 12:04 PM
  4. Replies: 5
    Last Post: 10-08-2013, 08:16 AM
  5. Send email in Outlook with attachment
    By kelkan in forum Programming
    Replies: 1
    Last Post: 02-01-2013, 10:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums