VBEval - Escaping Parameters Passed

[MikeB941]

Macro Scheduler Pro 12.1.10

I'm attempting to send email via SSL using a VBScript function called by VB Eval (i.e. http://www.mjtnet.com/forum/viewtopic.php?t=5128) however my email body string variable contains characters that are causing the dreaded error 1033 unterminated string constant.

VBEval>SendGmail("%VBSEmailSubject%","%VBSEmailFrom%","%VBSEmailTo%","%VBSEmailBody%"),CS_SendMailResult

Is there a way (a function, "escaping", etc.) to make the email body string variable "safe" to pass as an argument to VBEval.

I've tried double quoting:
VBEval>SendGmail("%VBSEmailSubject%","%VBSEmailFrom%","%VBSEmailTo%","""%VBSEmailBody%"""),CS_SendMailResult

but that didn't work.

Thanks very much for your help. Take Care... Mike.

[Marcus Tettmar]

You probably have the quote char inside one of your variables.

Double quote them by replacing all occurences with another:

Code: Select all

StringReplace>VBSEmailSubject,","",VBSEmailSubject
StringReplace>VBSEmailBody,","",VBSEmailBody
StringReplace>VBSEmailFrom,","",VBSEmailFrom
StringReplace>VBSEmailTo,","",VBSEmailTo

VBEval>SendGmail("%VBSEmailSubject%","%VBSEmailFrom%","%VBSEmailTo%","%VBSEmailBody%"),CS_SendMailResult