Need help to pass excel file as link in email

Help Studio
1

Need to pass excel report as a link instead of attachment in the body of outlook mail when execution completed using UiPath. Can you please help with the expression how to send excel report as a hyperlink . Excel reports will be stored in network folder path

2

If you use Create HTML Content Activity and check IsBodyHTML in your Send Outlook Mail Message activity, you can use the WYSIWYG editor to make a hyperlink.

3

Hi @r0818

=> Use an Assign activity and give the below syntax:

emailBody= "Please find the Excel report at the following link: " + System.Environment.NewLine + "<a href='http://ftpdocs.mydocs.jobs/Automation/StatusFiles/Sample.xlsx'>Click here to access the Excel report</a>"

Note: emailBody Datatype is of Systyem.String

=> Use Send Outlook Mail Message Activity to Compose and send the email.
Configure the Send Outlook Mail Message activity with the following properties:

  • To: Recipient’s email address
  • Subject: Subject of the email
  • Body: emailBody
  • IsBodyHtml: Check this option to interpret the email body as HTML.

The below will be your process:

Assign (emailBody):
    To: emailBody
    Value: "Please find the Excel report at the following link: " + System.Environment.NewLine + "<a href='http://ftpdocs.mydocs.jobs/Automation/StatusFiles/Sample.xlsx'>Click here to access the Excel report</a>"

Send Outlook Mail Message:
    To: Recipient's email address
    Subject: Your Subject
    Body: emailBody
    IsBodyHtml: True

Hope it helps!!

1 Like
4

@r0818

Replace any space with %20 in your filepath

So that it will come as hyperlink

1 Like
5

@r0818

Please try this

"<a href="+YourPathVariable.ToString+">Click Here</a>"

Cheers

1 Like
6

I will try . thank you

1 Like
7

Thank you! I will try and let you know

1 Like
8

@r0818

Happy Automation

Hope this helps

Cheers

9

Hope this helps

Happy Automation

10

Same as any other html link…

<A href='http://ftpdocs.mydocs.jobs/Automation/StatusFiles/Sample.xlsx'>Some text here</a>

If you want the URL to come from a variable, just do…

String.Format("<A href='{0}'>Some Text</a>",yourURLVar)

If you also want “Some Text” to be dynamic:

String.Format("<A href='{0}'>{1}</a>",yourURLVar,yourTextVar)

11

I did send link as clickable link with display text “click here to download” but when clicking on it from outlook ,excel report is not downloading. But using same hyperlinkI can download when clicked from Word document.

Can you please help if anything that I can change settings or something to make it as downloaded when clicked from email body

12

Outlook has security built in. When you mouse over the link in the email, does it say something about holding CTRL to click it?

13

yes
Thank you for your response

14

Did you hold CTRL to click it?

15

yes, its working fine now
Thank you so much.

1 Like
16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.