Jump to content
davidnickerson

Workaround for attaching a PDF or screenshot to email

Recommended Posts

I have a client using FM12 Server and Client.  He's requesting a "screenshot" of a table of related data to be attached (in-line) to a script-generated email.  I know of no way of scripting a screenshot within FileMaker without the use of a plugin.  I was thinking of saving as a PDF and then attaching to an email, but his users cannot mount the FM Server, so there is no path I can assign to the exported PDF.  Is there a clever workaround to achieve the desired result?  I'm aware than I can display each field in the body of the email, but he wants it to be formatted in columns and rows the way it looks on the layout.

Thanks for your help.

Share this post


Link to post
Share on other sites

You can assign the export to the users Temp folder on their computer for attachment.

Get (TemporaryPath)

Share this post


Link to post
Share on other sites

Thanks.  Not sure why I forgot about using temporary path.  However, as this does allow me to attach a PDF I can't quite achieved the desired result of having the PDF displayed inline (in the body of the email).  I don't think FM has any control over this...pretty sure its a local preference on each users Mail client...so I'm still looking for a workaround.  I've tried using Set Field to set a container field with the PDF, but that's not working.  Any ideas?

To simplify my original request, I'm looking for a way to generate an email that displays (in the body of the email) a group of fields on a layout (arranged in rows and columns). 

Share this post


Link to post
Share on other sites

You're right - won't go inline.

After that, I'd probably construct a calculated field to display the data - the fun comes in getting everything to line up. Even using a tab marker, different fonts may produce different results. 

Share this post


Link to post
Share on other sites

Hmm.  That's an interesting suggestion.  I may have to create rounding calcs for every number field (eg. 2 decimal places) in order to ensure that columns line up.  Thanks for the tips.

Share this post


Link to post
Share on other sites

Export as html table and include the html in the email? Alternatively, you can create all the html in a script and format it just the way you like. Then use something like BaseElements to send an html email.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Who Viewed the Topic

    1 member has viewed this topic:
    Terrible Toll 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.