New Hire Bot 2.zip (140.1 KB)
Bot Template.docx (13.5 KB)
New Hire Password Sheet - merge data - 1-15-21.zip (22.5 KB)
Before reviewing the solution, I want to address a few issues with this automation:
-
The “Word Document” option can only be used with Outlook app so this won’t work with Gmail.
-
Other issue encountered: the email sent keep using the default template instead of the new Word document with replaced data: it is because under Send Email card, on Property window, you have the template as “.data/HtmlContent0.html”. Bot will put the default value of this template in the email body together with the value you put in html body property:
-
Current issue: even though the data in the email is correct, bot sends email with a block of text instead of using the format in “Bot Template.docx”. See solution below.
Solution: New Hire Bot_Solution_HN.zip (196.6 KB)
-
if you want to send the email under the template that you shared (with text color, different font, etc.) using Gmail, you have to choose “HTML” option. This way you can format the email body using html tags.
-
In the “Bot Template.docx” file, format everything using html tags instead of text (see the solution file)
-
Under Send Email’s property window, remove the html template value because the template under folder .data/HtmlContent0.html is incorrect.
-
Remove the Delay activity because it did not address the original problem and causing the automation to slow down.
I also optimizing your code a bit.
Thanks,
Hannah
—Please mark my answer as Solution 
if it helps you solve your problem, this will help others who has the same issue —
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.