Reminders in access

  • Thread starter Thread starter Andy UK via AccessMonster.com
  • Start date Start date
A

Andy UK via AccessMonster.com

Hi,

I have set up a basic dbase containing a list of subscribers to a news letter.
I have the date of subscription as a field name and would like to set up a
reminder one month before the subscription is up (working on a 12 month basis)
.. I would also like to email the subscribers auomatically to let them know
the subscription is up. Can anyone help please?

Thanks,
Andy
 
I built you a version to run on Access 97. It's on the Access MVP Web:

http://www.accessmvp.com/Arvin/Birthday97.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

MurdocUK via AccessMonster.com said:
sorry, I should have mentioned I am currently using Access 97. I can't
open
the dbase within the .zip file.
Have a look at the demo database on my website:

http://www.datastrat.com/Download/Birthday2K.zip

and some Outlook code:

http://www.datastrat.com/Code/MultipleEmail.txt
Hi,
Click to expand...
[quoted text clipped - 9 lines]
Thanks,
Andy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top