Can I send an e-mail when an Access table has been updated?

[mvital]

Hello All,

Someone generated forms using PHP so they are on a website. The forms are updated via the website and Access tables are populated.

Is there a way that I could fire off an e-mail to people when the Access tables have been updated? PHV helped me with sending e-mails when a form in Access was updated.

It sounds like the PHP route has issues. My collegue said that The mail() protocol is not well supported in windows and we are having issues routing mail through the exchange server.)

Any ideas on what we could do?

thanks,

MV

 

[Remou]

Why not send an email using PHP?

 

[mvital]

We have been able to figure that out. We have an Apache server for the PHP and it is communicating with an exchange server. I am not too familiar with these things and our IS and the website form developer don't know either.

Is this hard to do? Can give me some ideas on how to get started or what else to check?

Maribel

 

[Remou]

There is a PHP forum in Tek-Tips:
How do I send a multipart email (both HTML and plain text)?
faq434-2681
Form/Email Validation & Form Mailer
faq434-2909
Send email that its content created in HTML
thread434-1255128

And so on.

 

[danvlas]

You would need a trigger, which Access does NOT have. SQL Server has it (as well as other servers).
For Access, you would need the interface (VBA, PHP, ASP, whatever) to do it.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html