Sending Emails - Reading HTML Text and Referencing Data Items
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-12-20 06:41 PM
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
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
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-03-21 06:44 AM
@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!!
Hope it's helps!!
Tushar Varshney
Senior Consultant - Intelligent Automation
Ernst & Young India
+91-9880188366
