I have a macro which currently updates to tell me when a certain range is filled with data (the range will not always have data, only on certain dates).
I want to create an email which is automatically triggered in outlook when there is data in the range.
Ideally the email would copy-paste the data in the above range and display in outlook to send.
Any help would be really appreciated Thanks