Email Report

[Guest]

I have a macro set up that will email my report but I need to know how to
email the report automatically based on a date. For example: I am sending a
permit out to be reviewed - I log the permit to a person and the date I send
it. I want Access to look at the date sent and send a reminder a week from
that date. Is there anyway to do this?

 

[Mink]

You can set up an If/Then statement that runs stating the folowing

If [reportDate] = DateAdd("d",-6,Date()) then
(Generate your email)
Else
End Sub
End If

This will only tell if it was exactly one week ago though, so if the
command is not run daily it would not work. Perhaps someone else will
be able to expand on this.

HTH
Mink