Results 1 to 5 of 5
  1. #1
    Sparky-1165 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2018
    Posts
    3

    Cool Import Linked Outlook folder emails

    I am somewhat new to VB and MACROs, but OK with ACCESS database queries, tables, forms, and reports.



    My Issue is:
    In the Body of the OUTLOOK email there are only file names, there can be 10 or many more. Each file name starts with “/data1/” and ends with “.ctl”. What I need to do is extract each of the file names into a table field as its own record, so if I have 10 file names I will have 10 records. In the same table, in separate fields, duplicate the email “Subject” and “Created” field data for each file name record.
    NOTE: There may be more than 1 email in this folder at a time. Can this process be automated to import each email respectfully from a click of a button or only 1 email at a time? If automated to do more than one email it will need to correctly put the file names, their Contents and Subject field data in with the correct file name record.

    I have tried “Importing” an OUTLOOK email and the data in the Body is most often too long and will be truncated.
    I created a folder in Outlook named “GbrgImport” to store the emails I need to import into the ACCESS database.

    I have now “Linked” to the email folder and that works fine.
    When “Linked” to the email the table field names are:
    Importance, Contents, Icon, Priority, Subject, From, Message To Me, Sender Name, CC, To, Received, Message Size, Created, Modified, Subject Prefix, Has Attachments, Normalized Subject, Object Type, and Content Unread.

    The fields that are underlined are the fields with the data I need to use in a separate ACCESS table.
    Note: Subject and Normalized Subject seem to be duplicate information.
    The Contents field contains the file names starting with “/data1/” and ending in “.ctl”.
    Need to use either the Subject or Normalized Subject in a separate field to be duplicated for each file name record that came from the Contents field.
    Same goes for the Created field, (Which is a Date-Time), needs to be in a separate field, and needs to be duplicated for each file name record from the Contents field.

    Any help with this is greatly appreciated.

    Thanks in advance Sparky

  2. #2
    AccessToGo is offline Novice
    Windows 10 Access 2007
    Join Date
    May 2018
    Location
    UK
    Posts
    15
    Hi Sparky, so how will you want to use this in practice? e.g. have a form reviewing the records in the linked table and a button which "does this one" so you manually decide which you do and which you don't? What happens to those emails which have been done, deleted/moved updated somehow? Regards Chris

  3. #3
    Sparky-1165 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2018
    Posts
    3
    Hi Chris, This will be used to track what file names have been imported. Yes, I will have a form to view this information. I plan on using a split form as the end users are familiar with EXCEL. The emails, as we receive several of them daily, would be placed in an OUTLOOK "GbrgImport" email folder either manually or by creating an OUTLOOK rule to place them their. If you are asking to have the ability to choose which emails to import, nice feature if it had the ability to select individual emails or select all but not necessary, just needs to select all emails in the folder. What I would like is to move the information from the linked table to a separate table. The button will allow the data to be pulled from the linked table into the ACCESS table and if the same button can also create the records as described in the original post that would be great. After the emails have been imported, I would like to archive or move the emails to a different OUTLOOK email folder called "GbrgImported". I hope my responses to your questions are correct and helpful in getting this project started. I appreciate you responding and helping me in creating this project. Regards Sparky

  4. #4
    AccessToGo is offline Novice
    Windows 10 Access 2007
    Join Date
    May 2018
    Location
    UK
    Posts
    15
    Sorry Sparky, I've been thinking through this issue and I can't find a simple workable solution for you. It's going to need some advanced VBA event coding. I would suggest that you close this question and post a new one so somebody else picks it up. Apologies Chris

  5. #5
    Sparky-1165 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2018
    Posts
    3
    Thanks for sticking with it and trying to help me resolve this issue. Much obliged.

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

Similar Threads

  1. import outlook folder
    By ck4794 in forum Import/Export Data
    Replies: 1
    Last Post: 06-04-2014, 08:11 AM
  2. Import Outlook folder
    By jjitss in forum Import/Export Data
    Replies: 1
    Last Post: 05-07-2014, 11:20 AM
  3. import emails from outlook to access vba
    By live2ride in forum Import/Export Data
    Replies: 4
    Last Post: 10-22-2012, 06:10 PM
  4. Linked Outlook emails
    By crowegreg in forum Programming
    Replies: 2
    Last Post: 04-15-2012, 11:16 AM
  5. How to Import Outlook emails with embedded images
    By imav in forum Import/Export Data
    Replies: 1
    Last Post: 08-06-2011, 09:53 AM

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