Email based on criteria

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I know how to do this in excel however I am new to access.
I have a form that is to be updated in three parts. If the form is not
updated after a certain period then an exception is generated identifying the
party that has not completed their task.

My question is this a report function or another method to accomplish this?
The intent is that a button is on the switchboard that generates this liost
that is to be emailed.

Thanks
Robert
 
Hi Robert,

You can use SendObject, which will use your default eMail program

'========================================= Email
'SendObject
'[objecttype]
'[, objectname]
'[, outputformat]
'[, to]
'[, cc]
'[, bcc]
'[, subject]
'[, messagetext]
'[, editmessage]
'[, templatefile]

It would be good to make a report and send that ... but if what you are
sending is just a list, perhaps a query would work best ...


Warm Regards,
Crystal

*
(: have an awesome day :)
*
 
Back
Top