Please Help - setup auto-reminder for billing

They have: 5,633 posts

Joined: Jan 1970

I currently have a website which customers can login and view their account information stored on a ms access database (which they can update).

i host the website with my own server. win02 advanced server, iis, website comprised of asp.

ive been searching for weeks on how to implement auto-email reminder by email for instance bills to customers on a bi-weekly basis or every month automatically pulling data from my ms access database.

I would appreciate it if anyone can tell me how i can accomplish this. ive looked at mail merge programs etc. but i require somthing that can run on my iis server. asp, vb, etc preferred . not perl, php .

im not familiar with this so i may have to use a windows based mail merge program..

please let me know

They have: 30 posts

Joined: Aug 2003

devrycis, you will need to write a script that does the following:

1. checks the database to see who needs a reminder
2. sends them reminder

then you need to set up this script to run like every hour. not sure how to do this on a win server.

if you want help with the code, please post the parts wher eyou have problems.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.