aquanok
asked on
send reminder e-mails
hi
i'm preparing a project called smarthome. this project are similar to alert/reminder system. i'm using VB 6.0 and MS Access for my database and this system is a standalone.
in this system, users have to define their assets (let's say cars) date to be serviced. system will notify the user via e-mail when the time has arrived (or maybe 2 weeks before the actual date).
1) how do i determine the frequency of reminders. lets say the service date is on 3/04/2004. so the reminders will be sent 2 weeks before, 1 week before, 3 days before, the day before and the day itself.
2) reminders will be sent to user through e-mail defined by the user.
3) user's computer (in which the system is operating) must stay online to send messages. messages will stay pending if there's no connection to the internet. ( am i right?)
ok that's it.
I offer you my points...ALL OF IT !!!!!
hope you can help.
thanks
i'm preparing a project called smarthome. this project are similar to alert/reminder system. i'm using VB 6.0 and MS Access for my database and this system is a standalone.
in this system, users have to define their assets (let's say cars) date to be serviced. system will notify the user via e-mail when the time has arrived (or maybe 2 weeks before the actual date).
1) how do i determine the frequency of reminders. lets say the service date is on 3/04/2004. so the reminders will be sent 2 weeks before, 1 week before, 3 days before, the day before and the day itself.
2) reminders will be sent to user through e-mail defined by the user.
3) user's computer (in which the system is operating) must stay online to send messages. messages will stay pending if there's no connection to the internet. ( am i right?)
ok that's it.
I offer you my points...ALL OF IT !!!!!
hope you can help.
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OracleSWN
how do i send these messages when the time's arrived
without any interactions from the user.(no command button)
how do i send these messages when the time's arrived
without any interactions from the user.(no command button)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could post e-mails in your outbox (back to the sender) that are scheduled to be sent at the designated date (prior to the service) and then then next time following the "reminder" that e-mail is checked, the messages will return back into the inbox.
B)ye F)or N)ow,
f)an p)ages.
B)ye F)or N)ow,
f)an p)ages.
ASKER
leeechonhwee
how do i do that?
how do i do that?
The best way is to use Microsoft Scheduler to invoke your program at regular interval. Please provide your email if you need screenshots for it.
Better example of DateDiff usage:
http://www.dcomp.com/dci/Books/CCVisualBasic/CCVB5.htm
BFN,
fp.