<div>
It is possible, but the easiest way is to use Access. You can run access application from batch file and close it after actions.
</div>


It is possible, but the easiest way is to use Access. You can run access application from batch file and close it after actions.

<div>
It seems like it would be more efficient to have the process that sends the email also send one to you. &nbsp;Why do this in two steps when you can do it in one?
</div>


It seems like it would be more efficient to have the process that sends the email also send one to you.  Why do this in two steps when you can do it in one?

<div>
That's the point of this... sometimes the process which sends the initial email hangs up, so I need to get notified that it is hung up. The initial send is inside VB code that could be hung up for whatever reason, still investigating that. In meantime, I need to know when it hangs so i can go in, stop the service, close the mdb, start the service, and get the email sent that was supposed to go out.
</div>


That's the point of this... sometimes the process which sends the initial email hangs up, so I need to get notified that it is hung up. The initial send is inside VB code that could be hung up for whatever reason, still investigating that. In meantime, I need to know when it hangs so i can go in, stop the service, close the mdb, start the service, and get the email sent that was supposed to go out.

<div>
<div class="content wysiwyg-content">
I have a timestamp field named quote_created for when the record was created. I also have a field named send_email in that record. <br />
<br />
If the quote was created more than ten minutes ago AND send_email=1, I need to be notified via email. We have Exchange 2007.<br />
<br />
Possible?
</div>
</div>


I have a timestamp field named quote_created for when the record was created. I also have a field named send_email in that record. 

If the quote was created more than ten minutes ago AND send_email=1, I need to be notified via email. We have Exchange 2007.

Possible?

Access 2003, batch file to detect new record in table

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.