Avatar of rvfowler2
rvfowler2
Flag for United States of America asked on

How do you code a Filemaker SMTP email so that the folder path is a hyperlink?

How do you code a Filemaker SMTP email so that the folder path is a hyperlink?
FileMaker Pro

Avatar of undefined
Last Comment
rvfowler2

8/22/2022 - Mon
Will Loving

Do you mean the folder path for the attachment?
rvfowler2

ASKER
Yes, example below.  I want it to be a clickable hyperlink when my boss receives it in Outlook for FM's SMTP email script.

N:\EXCEL\Files\FMexports\Tenants\Tenant Aging Report.xlsx
Will Loving

To the best of my knowledge, FileMaker's attachment option is designed to send an actual attachment, a file not a link. Normally, if FileMaker's Send Mail function supported HTML, you should be able to do something like this in the body of the email, though some browsers put restrictions on linking to files for security reasons.

<a href="file://N:/EXCEL/Files/FMexports/Tenants/Tenant Aging Report.xlsx">Tenants Report</a>

You could try inserting this link - it will have to be carefully coded in your calculation and tested due to various exception characters like slashes and quotes - and see if Outlook recognizes it as a link.

One option would be to use the SMTPit Plugin (or similar) that support HTML text in emails.
https://www.cnsplug-ins.com/Plug-ins/SMTPit_Pro/

Another would be to use FileMaker's WebDirect functionality. Store the document in a Container field (with External Storage turned on) and include a URL to the file to download. This involves turning on WebDirect, which makes the FM Server a web server as well and it will not open the file in one click, but it will make the file accessible without physically sending it as an attachment.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
rvfowler2

ASKER
Forwarded to myself until I got it to work in HTML.  FM may still send in plain text by default, but may get it to work if I can figure out how to have quotes left over before file and after xlsx.  How do you do the equivalent of double quotes so you still have quotes left that are included in the email?

<a href="file://N:/EXCEL/Files/FMexports/Tenants/Tenant Aging Report.xlsx">Tenants Report</a>
ASKER CERTIFIED SOLUTION
Will Loving

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
rvfowler2

ASKER
Thanks, that worked!