dbTalk Databases Forums  

Mail Hyperlinks to files with Outlook 2007

comp.databases.filemaker comp.databases.filemaker


Discuss Mail Hyperlinks to files with Outlook 2007 in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Christoph Kaufmann
 
Posts: n/a

Default Mail Hyperlinks to files with Outlook 2007 - 09-18-2011 , 09:31 AM






The powers that be make me work in a place where some people don't have
Filemaker and everybody uses Outlook 2007.

I want my FMP 10 to send an e-mail to people working in the same place,
thus accessing the same file system, and say "please have a look at this
file" without sending the file itself as attachment (since this results
in numerous file duplications)

Outlook provides a feature called hyperlink which works in rich text
format only - we use the attachment feature to paste a clickable path to
the desired file in the mail body.

If I use the send mail script step in Filemaker 10, I can re-create this
path by

- using readastext ( container field with reference) to extract the path
- strip the result from the first value, eliminate the "Filewin:/" and
replace all the "/" with "\"

The string in the mail body now looks exactly as it does if I insert the
path using the Outlook feature. However, Outlook doesn't treat it as
clickable :-(

Part of the problem ist that the Mail is in plain text format, but
there's no change if I switch it to rich text format.

Any ideas?
--
http://clk.ch

Reply With Quote
  #2  
Old   
Your Name
 
Posts: n/a

Default Re: Mail Hyperlinks to files with Outlook 2007 - 09-19-2011 , 08:23 PM






In article <1k7sth2.r4ihvk1rlrsp0N%clk (AT) tele2 (DOT) ch>, clk (AT) tele2 (DOT) ch (Christoph
Kaufmann) wrote:
Quote:
The powers that be make me work in a place where some people don't have
Filemaker and everybody uses Outlook 2007.

I want my FMP 10 to send an e-mail to people working in the same place,
thus accessing the same file system, and say "please have a look at this
file" without sending the file itself as attachment (since this results
in numerous file duplications)

Outlook provides a feature called hyperlink which works in rich text
format only - we use the attachment feature to paste a clickable path to
the desired file in the mail body.

If I use the send mail script step in Filemaker 10, I can re-create this
path by

- using readastext ( container field with reference) to extract the path
- strip the result from the first value, eliminate the "Filewin:/" and
replace all the "/" with "\"

The string in the mail body now looks exactly as it does if I insert the
path using the Outlook feature. However, Outlook doesn't treat it as
clickable :-(

Part of the problem ist that the Mail is in plain text format, but
there's no change if I switch it to rich text format.

Any ideas?
Nobody seems to be answering this one so ...

Are you sending the email from FileMaker Pro directly or sending it via Outlook?

I don't know about FileMaker 10, but in older versions FileMaker only
created plain text emails. To get a "fancy" email you had to do some
background playing to get FileMaker to create the HTML code and then
basically copy-pasting that across to the email application - in your case
that would mean you would need to create the appropriate HTML code for the
link and then transfer that to Outlook rather than use FileMaker's
in-built Send Mail command.

When you insert the path in Outlook, it's Outlook that automatically
creates the HTML code for the link behind the scenes.

When creating the HTML code for the link, it will need some sort of prefix
to signify it's a file link, but I'm not sure what that would be (e.g.
website links need "http://", email links need "mailto://", FTP links need
"ftp://", etc.). Simply putting "mydirectory\myfile.doc" in the email code
won't create an actual link.

Helpful Harry )

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.