Sending Emails - Reading HTML Text and Referencing Data Items

[RileyMcCabe]

Hello,

I am currently trying to send an email where I am reading the email message from an excel file that is already in HTML format. However, I'd like to reference a data item within this message so that when BP reads the email template from excel, it can include the data item in the message.

For example, I currently have this in the excel file:

<p>Hello,</p>
<p>Please reference &[Data Item]&</p>
<p>Thank you,</p>

In BP, it would look like this:

"<p>"&"Hello,"&"<p/>"&
"<p>"&"Please reference "&[Data Item]&"</p>"&
"<p>"&"Thank you,"&"</p>"

The data item call is a success when formatting in BP. The email bodies can dynamically change so it would be ideal to be able to keep referencing the excel text rather than updating and formatting the HTML message in BP. Is it possible to be able to reference a data item through reading HTML text?

Note: This is all using the MS Outlook Email VBO

Thanks,
Riley

[TusharVarshney]

@Riley McCabe - Firstly - if you pass this information in SMTP send email object, you have option to set if the text is HTML or not. Pass the value as true and Use 'Replace' function ​to replace the &[Data Item]& text with required value in Body text.

Hope it's helps!!