I want to use a simple 1 line of query results saved as an HTML file as the body of an email. This way the recipients of the email won’t have to launch Excel to see the data.
The problem I am having is the script fails sometimes because it says the HTML file is locked. I assure you it is not locked.
I would be fine with appending the date/time to the file name but i cannot figure out how to use this file as the body of the email. I know how to do this when using the variable file name as an attachment but not when using it as the body of an email.
Any help would be greatly appreciated.