Skip to content
Template email a PDF
Email A PDF
More
Share
Explore

Email A PDF

Using a File URL
Christiaan Huizer
Below the code you can use to get the file URL, however I have in one column the URL and in the next one the HyperLink() Function.

ParseJSON(thisRow.File._Merge().ToText(),path: "$.publicUrl").Hyperlink()

Initially I started with SetControlValue() and that works rather well. You name the controllers and this naming helps to avoid mistakes when adding the value like the first name. However the better option seems to me to use Format(). Although I had used this function before in this context, it was
Joost
⁠
who showed me how he did it in his company. That inspired me to work out two solutions you see below. The invoices are fake. Just pdf’s to have something.
Email a PDF
0
Send Email
EmailPerFile
Firstname
File
FileLinks
Results
Email
Signature
1
Email Invoice
Email Invoice
christiaan
Invoice 0128.pdf
Invoice 0129.pdf
Invoice 0130.pdf
Invoice 0128.pdf
Invoice 0129.pdf
Invoice 0130.pdf
182e46d0d5a54edf
christiaan.huizer@gmail.Com
Christiaan Huizer ​Founder Huizer BV Paul Fredericqstraat 24 BE-9000 Ghent Belgium
Open
2
Email Invoice
Email Invoice
​
Invoice 0128.pdf
Invoice 0130.pdf
Invoice 0128.pdf
Invoice 0130.pdf
​
​

Open
3
Email Invoice
Email Invoice
​
220824 Dimitri Demo Fake Invoice.pdf
220824 Dimitri Demo Fake Invoice.pdf
​
​

Open
There are no rows in this table
⁠

The article that explains a bit of the background you find below ⬇️

⁠
This link can't be embedded.
⁠
⁠

⤵️ how it looks in an email:
⁠
image.png
⁠
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.