I'm working on adding email directly from my macro and I want to add a comma in the HTML body. Currently I'm not able to get it to work in-line. If I say Let>body=Sincerely, and reference the variable it works. But if I try in the SMTPSendMail command directly it does not. I'm assuming it has something to do with the commas being separators for the various parts in the command. Can anyone tell me if there is a way to make this work or am I just out of luck? Here's my working v. non-working versions...
working...
Code: Select all
Let>SENDMAIL_STATUS=1
Let>SMTP_AUTH=1
Let>SMTP_SSL=1
Let>SMTP_USETLS=3
//Let>TLS_VER=12
Let>[email protected]
Let>SMTP_PASSWORD=hahaha
Let>SMTP_PORT=587
Let>SMTP_HTMLBODY=1
Let>body=Sincerely,
SMTPSendMail>[email protected],smtp.office365.com,[email protected],Server,Test,body,C:\Users\meDownloads\Report.pdf
Message>Result of SendMail: %SMTP_RESULT%
Code: Select all
Let>SENDMAIL_STATUS=1
Let>SMTP_AUTH=1
Let>SMTP_SSL=1
Let>SMTP_USETLS=3
//Let>TLS_VER=12
Let>[email protected]
Let>SMTP_PASSWORD=hahaha
Let>SMTP_PORT=587
Let>SMTP_HTMLBODY=1
SMTPSendMail>[email protected],smtp.office365.com,[email protected],Server,Test,<p>Please find the attached Report</p><p></p><p>Sincerely,</p><p></p>,C:\Users\me\Downloads\Report.pdf
Message>Result of SendMail: %SMTP_RESULT%