Using MS Access and CDO, I have started to use the .CreateMHTMLBody(filename) method to generate emails, which has fixed a number if issues.
However I need to modify the emails before sending. To do this I create a temporary, html file, which I then run through this command. However, for some reason, I cannot delete the temporary html file until I exit Access. I haven't got any public variables and am wondering if it could be CDO itself.
In order to work around this issue, I was wondering if there was a similar command that could use a variable (containing the html code), rather than a file?