|
| |
|
|
travismp
Posts: 233
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline
 |
automatic email from spooky? - 4/24/2008 12:10:21
I use the spooky log-in system for my web. My site has two databases, one for Spooky, one for my client records. I require my users to have an email address in the spooky db. I have 1856 clients. We upload about 500-600 records daily to my records db. Some clients may have one record, while others may have close to a hundred.
Right now we send out an email to each client at the end of the day with the same data that is uploaded. It takes up to two hours of time. I would like to get away from these daily emails at the end of the day and see if I can find a way for the Spooky login system to replace this in-house project.
My question is this:
Can I write a query or something that says look at query “qry_DailyTests” and email them template “template_TESTS” using their email address within the spooky DB? My backend DB has all of the Spooky log in names and the Spooky DB has the same username and then their password.
So if client “Walmart” has 3 tests done today a template would email them saying “You have new tests online, please go review”
I hope this is clear. Thank you.
|
|
|
|
travismp
Posts: 233
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline
|
RE: automatic email from spooky? - 4/25/2008 16:46:51
It could be a generic template that says something like
"You have new records online. Please log into the site to review. Thank you"
My issue is that some of my clients only get a handful of records per year. They do not need to log in daily to check for updates. They only want an email when there is something new posted, which may only be once a quarter.
This way if I upload 250 records for 55 companies today, 55 generic emails would go out, telling them to log in and see their new records.
| |
|
|
|
travismp
Posts: 233
Joined: 2/1/2002
From: hutchinson ks USA
Status: offline
|
RE: automatic email from spooky? - 4/25/2008 17:14:02
My DB is an Access DB. I can set up a query in there with all records for today with the [ComUserName] which matches up with [UserName] in the Spooky DB.
Do you have an known examples of a modified "pop_email_users.asp" so I can see an example of that?
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 