Thanks for your time and help rollis,
Yes, it is not picking the first heading in case cell L11 is blank.
I need to find a way to covert the email body to HTML and I also need to copy the range P11:X24 as an image to the email body + attach a copy of the worksheet "Visit Checklist" as mentioned previously.




Reply With Quote