Link to home
Start Free TrialLog in
Avatar of jmcdonald69124
jmcdonald69124Flag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of rhandels
rhandels
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jmcdonald69124

ASKER

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
SOLUTION
Avatar of Bradley Fox
Bradley Fox
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Maybe email to DB is what I am looking for?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial