Receiving and Auto responding to Email's

[Ihar]

I would like to know if it is possible to me get MS Access 2003 and or 2007 to monitor an email address and when an email arrives with certain subject lines to then have the database run a query or procedure and then email the results of that email address back to the originating email address.

If it is possible, where can i find more information on doing this?

Thanks in advance

 

[Guest]

Hi,

I dont think this will be possible with access, or at least possible for it
to work reliably. I would say your best bet would be to use php and mysql.
Although i cannot say exactly how it would be done as i am fiarly
inexperienced using them. But i'm sure a bit of research into php mailer
modules should highlight some possibilities.

HTH

 

[Tony Toews [MVP]]

I would like to know if it is possible to me get MS Access 2003 and or 2007 to monitor an email address and when an email arrives with certain subject lines to then have the database run a query or procedure and then email the results of that email address back to the originating email address.

Yes, you can do this inside Access. However you would need to run
Access at all times and it will have to periodically, every minute or
so, check that email address for emails.

There are a number of different methods of receiving and sending
emails.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Ihar]

Hi Tony

What you described is perfect for my solution, thanks very much

Regards

Steve

 

[Ihar]

Thanks Tony, it works like a dream

Yes, you can do this inside Access. However you would need to run
Access at all times and it will have to periodically, every minute or
so, check that email address for emails.

There are a number of different methods of receiving and sending
emails.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews [MVP]]

Thanks Tony, it works like a dream

Thanks for letting us know our solutions work.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm