Recent content by dcorleto

Thanks much it is working!!

One last time - I've gotten this far, but get a type mismatch error and can't seem to find why - can you please have a look and help me out - thanks! Dim appOutlook As Outlook.Application Dim olMailItem As Outlook.MailItem Dim rsRecord As ADODB.Recordset 'I would give this a more meaning name...

Dear rolaaus - I can't thank you enough for the quick response - I'll test this out and try to play around with it - I am taking a class in a couple of weeks in VBA for Access and can't wait to get started. This is so frustrating to not understand all this terminology and want to do these...

This is wonderful - thanks! But I guess I need the statements that runs the SQL query in the background first so that I can get the Me.expr1 - sorry but I am really new to all of this -

I have created a SQL Query in Access that reports the number of remaining inventory as Expr1. When a command button is clicked on a form, I would like it to send an email to a person if the Expr1 is less than 4. Can someone helps me start with the VBA code that I would need to acomplish this?