• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • 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

Thanks,
Joshua
0
jmcdonald69124
Asked:
jmcdonald69124
4 Solutions
 
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)..
0
 
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.
0
 
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
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
0
 
jmcdonald69124Author Commented:
Maybe email to DB is what I am looking for?
0
 
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?
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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