Results 1 to 2 of 2
  1. #1
    recon2011 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    28

    Emails saved to Access possible?

    I need a way of saving a copy of an email in Access. I am using Outlook for an email client. I have heard I can create a command or procedure in Outlook that will open a window (combo box?) with case numbers linked to an existing Access database. By selecting the case number a copy of the opened email will be created that can later be accessed (no pun intended) through Access. Is this possible? Thanks in advance. Please keep in mind that my Access skills are functional but code is not my strong suit.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,956
    This code http://www.blueclaw-db.com/read_emai...ss_outlook.htm saves parts of email into separate fields of a table.

    This code saves emails to a file folder http://www.vbaexpress.com/kb/getarticle.php?kb_id=875

    Also review this thread http://www.techrepublic.com/forum/questions/101-207331

    I can't find any examples of VBA saving email to table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Using Access to move Outlook Emails
    By crowegreg in forum Access
    Replies: 1
    Last Post: 09-28-2011, 02:25 PM
  2. Access 2010 Saved Imports
    By Tomfernandez1 in forum Access
    Replies: 1
    Last Post: 09-27-2011, 12:27 PM
  3. emails from Access making the emailid hyperlink work
    By techexpressinc in forum Programming
    Replies: 3
    Last Post: 08-30-2011, 06:56 AM
  4. Access emails
    By Gargen in forum Access
    Replies: 5
    Last Post: 08-04-2010, 01:10 PM
  5. Emails from Access
    By dbn00bz in forum Access
    Replies: 0
    Last Post: 12-07-2009, 07:55 AM

Tags for this Thread

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