email script

[Shawn]

Hi,

I have been using the below script to attach text files to a email and send
the email to whoever. But, I'd like to change the file Type to attach a
Excel file instead of a text file. What type of changes would I need to
make?

Thanks,
Shawn

#!/usr/local/bin/perl5.6

use lib "lib";
use MIME::Lite;

$msg = new MIME::Lite
From => "$ARGV[0]",
To => "$ARGV[1]",
Subject => "$ARGV[2]",
Type => 'TEXT',
Path => "$ARGV[3]",
Encoding => '7bit';
attach $msg
Type => 'TEXT',
Path => "$ARGV[4]",
Filename => "$ARGV[5]";
$msg->send;

--

[Bob Walton]

Shawn wrote:

....

> I have been using the below script to attach text files to a email and send
> the email to whoever. But, I'd like to change the file Type to attach a
> Excel file instead of a text file. What type of changes would I need to
> make?

....

> Shawn
>
> #!/usr/local/bin/perl5.6
>
> use lib "lib";
> use MIME::Lite;
>
> $msg = new MIME::Lite
> From => "$ARGV[0]",
> To => "$ARGV[1]",
> Subject => "$ARGV[2]",
> Type => 'TEXT',
> Path => "$ARGV[3]",
> Encoding => '7bit';
> attach $msg
> Type => 'TEXT',
> Path => "$ARGV[4]",
> Filename => "$ARGV[5]";
> $msg->send;

Try [untested]:

...
attach $msg
Type => 'application/msexcel',
Disposition=>'attachment',
Path => "$ARGV[4]",
Filename => "$ARGV[5]";
...

--
Bob Walton

[David Averbach]

I like how you can link FileMaker to your email program--clicking on
the email address will take you to, for example, outlook and address a
blank email.

But is there any way to turn off the feature that will lock Outlook
and FileMaker until you save or send the email? It seems like the
script is still running and it won't end (and take you back to
filemaker) until one of these is done.

Thanks

David Averbach
UC Berkeley

[Alan Lawrance]

You may be better served with the following plugin:

[url]https://www.productive.cc/pci_cart/FMPro?-DB=PCSC_Products.FP5&-Format=catalog.htm&-Lay=CGI&ID_No=40&-Find[/url]


"David Averbach" <davidaverbach@earthlink.net> wrote in message
news:a76dec2d.0309300940.5986fe33@posting.google.c om...

> I like how you can link FileMaker to your email program--clicking on
> the email address will take you to, for example, outlook and address a
> blank email.
>
> But is there any way to turn off the feature that will lock Outlook
> and FileMaker until you save or send the email? It seems like the
> script is still running and it won't end (and take you back to
> filemaker) until one of these is done.
>
> Thanks
>
> David Averbach
> UC Berkeley

[Ben Bradley]

I found this problem annoying too. Being locked in the view.
But i was pointed in a very easy to achieve direction.

Instead of using Send Mail script step, use Open URL instead and use
OpenURL[mailto:email_address_field@anywhere.net]

Just create a calculation field in your database that looks like this:
"mailto: " & THE_NAME_OF_YOUR_EMAIL_ADDRESS_FIELD
Then point the openURL script to that field value.

Works a treat because as far as FileMaker is concerned, Internet Expolorer's
dealt with the url request and all is fine. Little does it know it craftily
opens your message in your default email program.
You can add a bit more to this too, by adding ?subject=SUBJECT_NAME to after
the mailto:email@anywhere.net you can specify the subject of the message.
So mailto:email@anywhere.net?subject=SUBJECT_OF_MESSA GE

I think I've seen websites with BCC and CC done as well as the subject, but
I'm not sure.
And this ?=subject business only works with Outlook Express or Outlook as
far as I'm aware.

I've never had reason to test it to be honest.

HTH

I think it's a genius solution, just wish I thought of it myself!

Ben Bradley.



"Alan Lawrance" <ajlawrance@home.com> wrote in message
news:ZEkeb.52512$TM4.35738@pd7tw2no...

> You may be better served with the following plugin:
>
>

[url]https://www.productive.cc/pci_cart/FMPro?-DB=PCSC_Products.FP5&-Format=catalog.htm&-Lay=CGI&ID_No=40&-Find[/url]

>
>
> "David Averbach" <davidaverbach@earthlink.net> wrote in message
> news:a76dec2d.0309300940.5986fe33@posting.google.c om...

> > I like how you can link FileMaker to your email program--clicking on
> > the email address will take you to, for example, outlook and address a
> > blank email.
> >
> > But is there any way to turn off the feature that will lock Outlook
> > and FileMaker until you save or send the email? It seems like the
> > script is still running and it won't end (and take you back to
> > filemaker) until one of these is done.
> >
> > Thanks
> >
> > David Averbach
> > UC Berkeley

>
>

[Mariano Peterson]

One thing to watch out for with the open URL is that FMP will only accept
something like 453 characters in the URL itself. This is problematic if you
need to send long emails.