Link to home
Start Free TrialLog in
Avatar of rvfowler2
rvfowler2Flag 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?
Avatar of Will Loving
Will Loving
Flag of United States of America image

Do you mean the folder path for the attachment?
Avatar of 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
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.
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
Avatar of Will Loving
Will Loving
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, that worked!