PC Review


Reply
Thread Tools Rate Thread

Database triggered auto-email?

 
 
Clark
Guest
Posts: n/a
 
      3rd Feb 2005
My site is FP2000 - generated, operates in a Windows environment, uses Access
for the database, and has several DRW-generated queries in operation.

The database records all contain email addresses and a timestamp indicating when
the record was added among other things.

What I hope to do: I would like to automatically email all the email addresses
in the database whose timestamp is 90 days old. I know how to make an Access
query that produces the emails.

I have two questions:

1. What tools would be required to pull this off?
2. Will I need special things running / available at my host?
3. Can someone point me to code examples and/or useful reading to bone up on
this?

Thanks
 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      3rd Feb 2005
You just need to write the emailing functions that loops thru the recordset and then sends the email
via CDOSYS or CDONTS. Just do a search in the IE address bar as:

? ASP Sending Email CDOSYS

or

? ASP Sending Email CDONTS

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Clark" <non-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> My site is FP2000 - generated, operates in a Windows environment, uses Access
> for the database, and has several DRW-generated queries in operation.
>
> The database records all contain email addresses and a timestamp indicating when
> the record was added among other things.
>
> What I hope to do: I would like to automatically email all the email addresses
> in the database whose timestamp is 90 days old. I know how to make an Access
> query that produces the emails.
>
> I have two questions:
>
> 1. What tools would be required to pull this off?
> 2. Will I need special things running / available at my host?
> 3. Can someone point me to code examples and/or useful reading to bone up on
> this?
>
> Thanks



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Email auto linking in a shared database Kevin Microsoft Outlook BCM 1 28th Aug 2008 04:06 PM
Email triggered by Reminder john Microsoft Outlook VBA Programming 1 25th Sep 2006 07:01 PM
Which event is triggered when user saves email item? Kasper Microsoft Outlook Program Addins 4 22nd Sep 2006 02:26 PM
can an exchange email be triggered? Jason Shohet Microsoft C# .NET 2 6th Jan 2005 03:08 PM
Time triggered auto-delete and save richlee_uk Microsoft Excel Worksheet Functions 1 27th Sep 2004 10:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:02 PM.