Send email with predefined template

[Dylan1]

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
------------------------------

[AkhilThukral]

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
------------------------------

[GopalBhaire]

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
------------------------------

[AkhilThukral]

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
------------------------------

[remko.bouwens]

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
------------------------------