Issue Getting the Outlook Activity to Read Variable in Hyperlink Path

Help Activities
, ,
1

I’m at the final stage of automation where I send out an email with a link to the output. The preceding process creates a new file folder each time the process is run.

The hyperlink in the body of the email that’s sent out looks like the following; for the present run, {{FolderName}} is = Details thru 2023-10-31_20231207

FAKE FILE PATH\2023{{FolderName}} or with the variable resolved, it’s FAKE FILE PATH\2023\Details thru 2023-10-31_20231207

Where {{FolderName}} is the name of the variable for the new folder that’s created each time the process is run.

When I try to embed the example hyperlink above, the displayed blue text is correct, but the link path is incorrect when the mouse is hovered over the hyperlink. It currently shows up as this:

FAKE FILE PATH\2023\Details thru <[Notes.Sheet(Date!LastMonthEndDate}>_<[Notes.Sheet(Date!YYYYMMDD]>

I’ve tried creating a variable for the file path and then inserting that variable into the advanced text editor for the Outlook activity, but I can’t seem to get it to work. I’ve attached my advance text editor from the Outlook activity to this post. Any help you can provide would be greatly appreciated!
Advanced_Text_Editor.txt (1.8 KB)

2

@Iffrig_David

Welcome to the community

  1. Are you using create html content?
  2. Can you show some screenshots and did you try to print the variable data in log messages

Cheers

3

Assign the FolderName & LastMonthEndDate to a variable & use the following code in your HTML body

“<a href=”“file://FAKE%20FILE%20PATH/2023/” & LastMonthEndDateText & “_” & FolderName & “”“>Your Link Text”