Need some fresh ideas - incoming email to db

Posted on 2006-04-06
Last Modified: 2010-04-18
Hello Everyone,

Is there a way to get incoming email that is going to an account (example and save it to a database as a .msg file so that I can create an email once a day that links to the new messages on the server.

Any Ideas would be great

Question by:jmcdonald69124
    LVL 23

    Accepted Solution


    Depends on the time you would like to spend getting this to work and the amount of money you have to spend..
    I know that GFI MAil Essentials can do this for you, normally Outlook and Exchange are to dumb to pull this one off.. And for as far as i'm aware it cannot be done with the basic functionality of Outlook and Exchange (you would have to write a .vbs script that will be activated after receiving the mail)..
    LVL 23

    Assisted Solution

    There may be other "ways" to accomplish the task you are looking for.  If you explain the overall idea in more detail, leaving out the technical solution you think is needed, we may have better/easier ways to accomplish what you are needing to do.

    Author Comment

    Here is a more detailed description of what I want to do, first, I have an email address like where anyone can send a message that they want to be visible to all users who have access to the company intranet. This message would go to the server (db?) and be stored in a table, I would probably have Title, Date, Msg, Allow_View fields. The message field would contain a link to the .msg file that is on the server, the title, date, fields would be stripped from the message and placed into the db. Then after someone checks the allow_view checkbox in the db that is associated with the message it can be placed on a daily email like the one below and sent to all users –

    The following Postmaster messages have been posted on blahblah for 21 Mar 06.
    Messages to be posted on Postmaster should be submitted prior to 0830 hours.

    NOTE:  If you are not physically located in the main bldg by clicking on this link (Postmaster Message).
          Tuesday, March 21, 2006  9:09 AM      1259008 Adoptable Animals.msg
          Tuesday, March 21, 2006  9:09 AM        20992 Donated leave request.msg
          Tuesday, March 21, 2006  9:09 AM        34304 For Community Calendars-Immediate Release.msg
    LVL 21

    Assisted Solution

    I would suggest setting up a blog on your intranet and just having users check it now and again if they want to see these "public messages"  Have a look at the link great here!

    Author Comment

    Maybe email to DB is what I am looking for?
    LVL 23

    Assisted Solution

    that sounds like something Sharepoint would handle.

    As far as submitting an email to a database itself...that's something beyond my expertise.  I could google it and guess but that won't be far from what you've already done.

    Have you tried posting this question or a pointer in the SQL or Database channels?

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    So you have two Windows Servers and you have a directory/folder/files on one that you'd like to mirror to the other?  You don't really want to deal with DFS or a 3rd party solution like Doubletake. You can use Robocopy from the Windows Server 200…
    Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video discusses moving either the default database or any database to a new volume.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now