Hello everyone, I have a website with a form which when user submits updates the database that i have which is access 2007. However i wanted to be able to send an automated email to say that it has been updated, ive tried looking for some PHP scripts that could help me out but couldnt find a decent one. If someone was able to point me in the right direction then i would appreciate that Thank you
Iam using ASP for the database and HTML for the appearence of the web pages Okay thanks kaleshwar i will look into that
Hi! This code might help you. Remember, I am using IIS 7.0 to run this script. sendUrl="http://schemas.microsoft.com/cdo/configuration/sendusing" smtpUrl="http://schemas.microsoft.com/cdo/configuration/smtpserver" ' Set the mail server configuration Set objConfig=CreateObject("CDO.Configuration") objConfig.Fields.Item(sendUrl)=2 ' cdoSendUsingPort objConfig.Fields.Item(smtpUrl)="relay-hosting.secureserver.net" objConfig.Fields.Update ' Create and send the mail Set objMail=CreateObject("CDO.Message") ' Use the config object created above Set objMail.Configuration=objConfig objMail.From="jobs@jobads.pk" objMail.To=Request("email") 'This can be taken from database objMail.Subject="This is subject" objMail.TextBody="This is message" objMail.Send I hope, this script will work to send auto emails.
Here's a solution for that http://bytes.com/topic/asp-classic/answers/52561-email-notification-when-database-updated Thanks