Re: Creating a email list based on a another field

In article <120rg1i85hlu355@xxxxxxxxxxxxxxxxxx>, Howard Schlossberg
<howard@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

sasampson@xxxxxxxxx wrote:
I know about the buttons that will run an email script, but but what I
want to do is to mass email a whole team at a time instead of
individuality. I have one table that has all my contacts' information,
name, sport, phone, email etc, I have another table which is my email
table, that has the subject line, and body fields for the email button
script,(they are related by the sport field) what I do not know how to
do is to select a sport, say football and have all contacts with sport
football be emailed in one button click. thanks for your help

You can get your found set of 'football' either manually or with a script.

Whether you use the Send Mail menu item or script step, you have the
option of sending "one email using data from the current record" or
"Multiple emails (one for each record in the found set)". From there,
you can assign which fields to use as subject, recipient, body, cc, bcc,
attachment, whatever you'd like.

However, to send one email using the recipients represented by all
records in the found set, you would have to have your script loop
through all records and store the list of emails to a local variable or
to a global field, and then send the email using the 'one email' option
and using that variable or global as your recipient.

Not quite true.

Unless it's been removed in newer versions of FileMaker, there is an
option to use the entire Found Set, although I've never tried it so I'm
not sure how well or otherwise it works.

- Add the Send Mail command to your script

- Click on the Specify button

- Click the To or CC options to 'Field Value'

- You now get the usual 'pick a field' window, BUT underneath
there's an option to either 'Use the current record' or
'Use all records in found set.'

That should send the message to everyone in the Found Set, but it has
to be the same message (and same attachment if used), so you can't
personalise the messages that way, ie. "Dear Fred, ..." is not
possible, you'd have to have "Dear Team Member ..."

Also, the Send Mail command appears to be rather flakey, but that's not
really FileMaker's fault and is due to the wide variety of email
applications around and the way they handle being told what to do by
another application.




Remi-Noel suggests using SMTPit, which is a great plug-in that I often
use -- but I just don't see how that would make anything any easier in
this case.

Not to mention that it's expensive. :o\



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.

Relevant Pages

  • Re: Creating a email list based on a another field
    ... Correct you are Harry. ... Right under where you specify the 'to' field, there is a checkbox option for "For each message, collect addresses across found set". ... script,(they are related by the sport field) what I do not know how to ... Whether you use the Send Mail menu item or script step, you have the option of sending "one email using data from the current record" or "Multiple emails ". ...
    (comp.databases.filemaker)
  • Login Scripts email function
    ... of them with a login script the emails me me when they login. ... GenericSendmail SMTPserver, From, Recipient, Subject, Message ...
    (microsoft.public.scripting.vbscript)
  • Re: Log date
    ... It seems you can't use the "`" syntax because a crontab is not a script. ... If you had installed the mail command, you would have received a mail ... with the problem every time cron failed to execute your command. ... but what I would like is to create a log file with a date in the name ...
    (Ubuntu)
  • Re: how to configure mail command to use a specific mail server?
    ... think the mail command will be of great use. ... its a single perl script that you can copy to your /bin/. ... The most that I believe you an do is to configure the local postfix ... or send a blank email message to: ...
    (RedHat)
  • Re: local mail
    ... normal cron job reports, etc.). ... simple 30-lines script via sudo. ... Now I can use mail command in a usual way. ...
    (comp.os.linux.misc)