Creating an After Update macro to email a customer

An After Update data macro allows you to perform an action upon adding, updating…or deleting a record.…In our database, when a customer's order is marked Complete, it will be nice to…send them an e-mail letting them know that their olive oil has been shipped.…We can build this action right into our Orders table.…To do this, open up your Orders table, and up on the Ribbon under Table tools,…click on the Table tab, click on the After Update button.…A Macro window will appear.…In the first box, pull it down and choose If, and our criterion is going to…be [OrderStatus.]…And notice, as soon as I start typing, it auto fills with my possible matches.…

I will pick OrderStatus off of my list.…Put in an equals sign, a quotation mark, and then the word Complete.…The square brackets around OrderStatus tell Access to look in that field, the…equals sign tells it what to look for, and the Complete goes in quotes to show…that it's a text value.…Now, we will add an action.…So If [OrderStatus] = "Complete ", we want it to send an e-mail.…