• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

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

4 Solutions

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)..
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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!

jmcdonald69124Author Commented:
Maybe email to DB is what I am looking for?
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?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now