Send email macro

[jvonschmittou]

I'm looking to make a macro that will send a email to people as a alert if a criteria goes below a certain number. Anyone have any suggestions on how to go about this?

 

[Starman]

I think you're going to have to write some VBA code if you want to accomplish this.

 

[scott-atkinson]

I'm looking to make a macro that will send a email to people as a alert if a criteria goes below a certain number. Anyone have any suggestions on how to go about this?

Is your installed email software, Lotus Notes, or Outlook?

 

[ksalansky]

Use the sendobject command to create the macro and name it autoexec so it runs automatically when you open the database. If you want the database to automatically open you need to use the windows scheduler in the control panel and schedule a task to open your database, like weekly or monthly (whatever you want). These two things together will allow an automatically generated email to be created with information from a report or query in access.