topic RE: Send email with predefined template in Product Forum

Send email with predefined template

Dylan1 — Mon, 14 Jun 2021 11:53:00 GMT

Hello everyone,

I have to use an email template to send some notifications, Something like this:

The table (Item | Description | Price) could have multiple rows. What is the best way to do this? For other projects, I run an Excel macro that sends the template and I replace the data fields with the information. I think this is not going to work with the table, and it's not too robust. I also tried to replicate the template using HTML but the result was awful.

Thanks,

BD

------------------------------
Dylan
-
-
America/Argentina/Buenos_Aires
------------------------------

RE: Send email with predefined template

AkhilThukral — Mon, 14 Jun 2021 12:46:00 GMT

Hi Dylan,

Please use the HTML tags only and inline style properties to achieve this, take some editor to see the progress first then you can copy that code to BP text data item and do not forget to insert the data items references in HTML code where you want dynamic data.

------------------------------
Akhil Thukral
Application Development Module Lead - Blue Prism
Telus International
Asia/Kolkata
------------------------------

RE: Send email with predefined template

GopalBhaire — Mon, 14 Jun 2021 12:52:00 GMT

Hi Dylan,

The HTML should work, it'll be better if you can share the HTML, so somebody can help you out with it.

Have you tried to fill the excel with the MS Excel VBO and then use the Run Macro action to run the macro?

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Send email with predefined template

AkhilThukral — Mon, 14 Jun 2021 12:56:00 GMT

Hi Dylan,

Please use the HTML tags and inline styling property to create such template. Use some HTML editor instead of directly using data item, once you got confidence on your create template, replace the data item reference form BP where you want to see the dynamic values.

------------------------------
Akhil Thukral
Application Development Module Lead - Blue Prism
Telus International
Asia/Kolkata
------------------------------

RE: Send email with predefined template

remko.bouwens — Tue, 15 Jun 2021 12:32:00 GMT

Hi,

If possible, you can also create an Outlook Emailtemplate in which you edit/insert the data you need.
This isn't a standard action in the VBO, but can be created by yourself. Using the code below can enable you to use a specific predefined template to use.

Dim mail = app.CreateItemFromTemplate(Emailtemplate)

Good luck

------------------------------
Remko Bouwens
RPA Specialist
Boels Rental
Europe/Amsterdam
------------------------------