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

    Saving html, mht, or other email format to a Memo control

    Is there a way to open an email in Outlook and then send it (copy) to a form in an Access database. I am looking for a way of saving emails i get from clients. I have a form from a table that is basically just a Memo field that has a CaseNumber control on it. I would like the email copied into the Memo control on the form based on the CaseNumber.

    Example:



    I open Outlook and look at the inbox. I have an email from a client that I need to save. I already have a database (Access 2007) set up. I want to save the email specifically to a form called EMails that has a control called CaseNumber that I can use as a filter. When I go to save the email I need a form to open and request the CaseNumber. I type in the Case Number and click OK. This will then open the Emails form in Access (basically just a Memo control) where the email will copy to. The purpose is to save all emails from clients. When I open the form Clients I can click the Email button and look at all the emails from just that client.

    I have searched within the forum but haven't located this specific operation. Maybe it cannot be done. Keep in mind that my Access skills are limited but I can navigate fairly well other than VBA. Thanks in advance.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Google: Access VBA import email. For starters
    http://www.fabalou.com/Access/Genera...ng_outlook.asp
    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. Replies: 0
    Last Post: 12-01-2011, 01:38 PM
  2. Saving a report to PDF format
    By Musicguy2112 in forum Reports
    Replies: 2
    Last Post: 10-28-2011, 12:06 PM
  3. Replies: 0
    Last Post: 03-24-2011, 11:09 PM
  4. Need help with Memo field text format
    By sprovoyeur in forum Access
    Replies: 1
    Last Post: 05-14-2010, 08:03 AM
  5. HTML tags in memo field
    By sprovoyeur in forum Access
    Replies: 0
    Last Post: 05-11-2010, 01:33 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