Dan Waters
dwaters at usinternet.com
Tue May 4 17:38:21 CDT 2004
Jeff - Is it something like this?
Private Sub AnnoyProspects()
On Error GoTo EH
Dim stgState as String
Dim stgPosition as String
Dim stg as String
Dim rst as DAO.Recordset
Dim stgOverHypedMessage as String
stgState = Call GetRandomState
stgPosition = Call GetAnyPosition(stgState)
stgOverHypedMessage = Call GetOverHypedMessage(stgPosition)
stg = "SELECT Person FROM tblProspectList" _
& " WHERE DateLastAnnoyed <= (Date() - 3)"
Set rst = DBEngine(0)(0).OpenRecordset(stg, dbOpenSnapshot)
If rst.EOF = False Then
Docmd.SendObject , , , rst!Person, , , _
"Your Perfect New Position!", stgOverHypedMessage, False
End If
rst.Close
Set rst = Nothing
Exit Sub
EH:
Call GlobalErrorHandler
End Sub
Having Fun,
Dan
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows
Sent: Tuesday, May 04, 2004 4:57 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] OT: Prosavvy
DO NOT REPLY TO THEM!!!!! If you do, you will get emails every three
days telling you about jobs all over the country that have little or
nothing to do with programming.
Jeff Barrows
Outbak Technologies, LLC
Racine, WI
www.outbaktech.com
-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com]
Sent: Tuesday, May 04, 2004 3:14 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] OT: Prosavvy
I googled it and it didn't look good!
John W. Colby
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Julie
Reardon-Taylor
Sent: Tuesday, May 04, 2004 3:55 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] OT: Prosavvy
Prosavvy has aggressively been targeting me for membership. Anyone had
any
dealings with this company or know anyone who has?
Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
108 Franklin Street
Watertown, NY 13601
(315) 785-0319
www.pro-soft.net
_________________________________________________________________
Express yourself with the new version of MSN Messenger! Download today -
it's FREE! http://messenger.msn.com/go/onm00200471ave/direct/01/
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com