LisaHoerster
asked on
Dephi Email Autoresponse with data from SQL
Looking for resources, ideas, experiences, components, units, third party solutions, etc. to help me get down the road with a new project which is an email autoresponse system that responds back with status data based on a common ID number in the subject line.
Here is how it might work:
1) We setup a dedicated email account to receive emails from a customer.
3) Customer sends email to that account with common ID number in subject line.
4) Return email address and common ID number are extracted from email for processing.
5) System retrieves status information from our SQL database based on dedicated email account it was sent to (to identify which customer) and common ID number to identify specific order they want status on.
6) System sends status information back to the requestor in an autogenerated return email with status in the body of the email or attachment.
Current System details:
Exhange 2010, SQL 2005, Delphi XE2 or prior, Windows hyper-v environment.
Thanks for your thoughts on this.
Here is how it might work:
1) We setup a dedicated email account to receive emails from a customer.
3) Customer sends email to that account with common ID number in subject line.
4) Return email address and common ID number are extracted from email for processing.
5) System retrieves status information from our SQL database based on dedicated email account it was sent to (to identify which customer) and common ID number to identify specific order they want status on.
6) System sends status information back to the requestor in an autogenerated return email with status in the body of the email or attachment.
Current System details:
Exhange 2010, SQL 2005, Delphi XE2 or prior, Windows hyper-v environment.
Thanks for your thoughts on this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Geert Gruwez -
Thanks for input. We already have web site. Not mobile friendly enough and dealing with large group of third party stakeholders, potentialy thousands, that we do not want to deal with user login authentication. At least with email we can tell who is sending the inquiry and allow based on the domain sent from and the email they sent the request to.
Thanks for input. We already have web site. Not mobile friendly enough and dealing with large group of third party stakeholders, potentialy thousands, that we do not want to deal with user login authentication. At least with email we can tell who is sending the inquiry and allow based on the domain sent from and the email they sent the request to.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
> login form
> input form with common id number
> return output
you don't need email ... :)