Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Central Florida, USA
    Thanked 0 Times in 0 Posts

    Email in memo fields (2k/XP)

    I have been asked to research alternatives to the following existing procedures which use Access and Outlook Express.
    The folks receive emails with information that relates to a specific record in their Access database. They select ALL the text in the email and copy it. They then search their records for that record, and paste the copied text into a memo field. They always put the most current information at the top of the memo.

    Is this the most automation possible, or is there a more efficient means of "linking" (for lack of a better word) or encapsulating the email within an Access record?



  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Sydney, Australia, New South Wales, Australia
    Thanked 4 Times in 4 Posts

    Re: Email in memo fields (2k/XP)

    I can think of many ways this could be approached.
    Perhaps the easiest (although still a bit manual) is to save the outlook message as a message file, and store the path and filename in Outlook.

    1. In Outlook, find the message. Save it to some file with File, Save As, path / filename. Make sure the save as type is msg.
    2. Store that path / filename in your Access table.
    3. You can open the email message (as a message) by double-clicking it from within Explorer. You can also open it with shell filename.msg (there's an association between *.msg and Outlook.

    It's possible to 'drive' Outlook from Access, getting Access to do the above, but it's quite a bit more coding.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts