Reminders in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy UK - 30 Jun 2006 12:00 GMT

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

Reply to this Message

Arvin Meyer [MVP] - 30 Jun 2006 12:12 GMT

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

Signature

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

> Hi,
>
[quoted text clipped - 9 lines]
> Thanks,
> Andy

Reply to this Message

MurdocUK - 30 Jun 2006 14:21 GMT

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:
>
[quoted text clipped - 8 lines]
>> Thanks,
>> Andy

Signature

Murdoc

Reply to this Message

Arvin Meyer [MVP] - 06 Jul 2006 05:36 GMT

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

http://www.accessmvp.com/Arvin/Birthday97.zip

Signature

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

> sorry, I should have mentioned I am currently using Access 97. I can't
> open
[quoted text clipped - 12 lines]
>>> Thanks,
>>> Andy

Reply to this Message

MurdocUK - 06 Jul 2006 11:13 GMT

Thanks!

I'll have a look at this.

Andy.

>I built you a version to run on Access 97. It's on the Access MVP Web:
>
[quoted text clipped - 4 lines]
>>>> Thanks,
>>>> Andy

Signature

Murdoc

Reply to this Message