Forum Discussion
Solved
VBA - .Body & .HTMLBody Indent and Default Signature Issue
Hello, I've set up a macro to send an e-mail through Outlook. .Body is read from a cell inside the file with indents. Since the value will change depending on the usage, I need to reference t...
- I've figured it out. I edited the cell indents(CHAR(10)) to something called "helper" then I simply used Replace function.
.HTMLBody = Replace(body, "helper", "<br>") & sig
I've figured it out. I edited the cell indents(CHAR(10)) to something called "helper" then I simply used Replace function.
.HTMLBody = Replace(body, "helper", "<br>") & sig
.HTMLBody = Replace(body, "helper", "<br>") & sig