Need some fresh ideas - incoming email to db

Hello Everyone,

Is there a way to get incoming email that is going to an account (example post@abc.org) 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

Thanks,
Joshua
jmcdonald69124Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rhandelsCommented:
Hi,

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)..

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TheCleanerCommented:
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.
jmcdonald69124Author Commented:
Here is a more detailed description of what I want to do, first, I have an email address like posts@test.com 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
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

mcsweenSr. Network AdministratorCommented:
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 below...works great here!

http://sourceforge.net/projects/pwrblog
jmcdonald69124Author Commented:
Maybe email to DB is what I am looking for?
TheCleanerCommented:
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?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.