Stored Procedure to email

[cumap]

Hi all,

I'm looking for a stored procedure to automatically check for expiration date and send STMP email when the date matched. I am working with MS Access 2007 and ASP.

So far, my obstacle is how to send the email if the requirement meet.

Thank you for any input.

 

[smedvid]

I have used a free SMTP DOS Based Command Line Tool called BLAT successfully yo send SMTP Emails.

Another option I have not used in many years is CDO...

I believe you can also attach directly to some Outlook libraries...

There are plenty of CDO Examples out there as well as on this site (as I recall)... Search for MS Access CDO Email...

I hope this was helpful....



Steve Medvid
IT Consultant & Web Master

 

[cumap]

Thank you Steve,

In my case, the website is not hosted locally, so how can I attach directly to the Outlook libraries? do you (or anyone else) suppose Godaddy has that option included? Or maybe I should check with them directly.

After so much thought, I start to believe that maybe this is not the way we want to follow. Maybe, it is better to add code to check expiration date whenever user login and display the message right on their screen instead of worrying whether the emails should somehow go to spam/junk folder.

Oh well, thanks again for the suggestion!

 

[smedvid]

Always best to limit externals stuff like email if it is not really needed... Good luck...

Steve Medvid
IT Consultant & Web Master