I am fairly new with VBA and need your help to write a macro that will send an email automatically once a criteria is met. My workbook is being updated every minute through a query, and the information is constantly changing. Let's say I want to send an email through Outlook if any cell in column Y meets a criteria based upon a formula that cell already has. I have the specific email in column R that is also being updated every time the query updates. The subject of the email will be in column A combined with cell $AB$2. Finally the body of the email will be a combination of data in column E and column O, which is changing row after row.
I hope you can help me with this, and thank you in advance for your time.
Attached is a dummy version of the file I am running.
Thanks a lot!
I hope you can help me with this, and thank you in advance for your time.
Attached is a dummy version of the file I am running.
Thanks a lot!