Email

[Lorraine]

Hi

I have setup an access database for reminding me of the tasks i have
completed and the ones to be completed, more or less a to do list, i have did
a table for Weekly and a table for Monthly, i have setup a querie a form and
a report for both, now what im trying to do is automate a macro to send me
the weekly report every week which i have managed to do but cant get it to
automatically send me the monthly one every month. anyone any suggestions

 

[Dorian]

The problem with automating the sending of emails is the Microsoft security
prompt - which requires a manual confirmation on the sending of an email. Why
not use Outlook for your task? - It's more suited to reminders than Access.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Arvin Meyer [MVP]]

You ought to be able to use the same code for monthly as you do for weekly,
changing the date value. Post your code, and we'll see what we can do to
change it for you.