I'm trying to send an email automatically through Excel, but the new line commands aren't working! I've tried <br/>, vbCrLf and vbNewLine
.HTMLbody = "Hello" & vbNewLine & "Please find attached the above invoices and backup" & vbNewLine & _
"Any queries please let me know" & vbNewLine & "Regards" & vbNewLine & Signature
It keeps just giving Hello Please find attached the above invoices and backup Any queries please let me know Regards as one line!
May be you can try this instead: Use
.HTMLbody = "Hello" & "<br>" & "Please find attached the above invoices and backup" & "<br>"
instead of vbnewline