COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Send mail script step - Sending mail to multiple addresses

  • Email
  • Follow


I have a file CLASSES with the classes of a school and a file STUDENTS with
the students of the shool.
The two files are related with the Class_ID field.

I have a layout with the data from one record of the CLASS file and a portal
showing all the students in that class.

I want to use a script to sent e-mails to all the students in that class
(assuming that there is a e-mail address field in students file). If I use
the "Use all Recordn in found set" flag the mail is sent to all the studends
of the school and not only to the students of that class. If I use "Use the
current record" flag the mail is sent only to the first student in the
portal.

Any HELP ?
0
Reply Hatzigiannakis 11/1/2004 12:20:13 PM

See related articles to this posting

On 2004-11-01 04:20:13 -0800, "Hatzigiannakis Nikos" <nikos@ypai.gr> said:

<snipped>

> 
> I want to use a script to sent e-mails to all the students in that class
> (assuming that there is a e-mail address field in students file). If I use
> the "Use all Recordn in found set" flag the mail is sent to all the studends
> of the school and not only to the students of that class. If I use "Use the
> current record" flag the mail is sent only to the first student in the
> portal.

Are you familiar with what a found set is?  A found set is a subset of 
all the records that match a certain criteria.  These are found using 
the find command or using the goto related records - show only related 
records script step.  Once you have create a found set you can select 
"Use all records in found set"

You can create a found set by going to related records (show only 
related rcords) from your classes layout and then put a find script 
step utilizing the "=" symbol and OMIT function in the email address 
field.

The "=" symbol by itself in a field finds all the records in which that 
field is empty.  Using the Omit function will remove those records from 
your "found set'.  Should also mention that when you use the find 
script step in your situation - that is, after going to the related 
records - you'll want to "constrain found set".  That means your Go to 
related records will create a found set and then within that found set 
you want to eliminate the records that have an empty email address 
field.

loulou
0
Reply Lou 11/1/2004 5:27:52 PM
comp.databases.filemaker 10692 articles. 16 followers.

1 Replies
377 Views

Similar Articles

12/11/2013 11:59:19 AM
[PageSpeed]

Reply:

Similar Artilces:

Mail.app script?
I would like to make a script that lets me remove mail from my popserver when I want to without having to open the preferences pane. Is this possible? Thanks, Martin (Please email me if possible: martin.rocek@gmail.com) ...

Help with mail script
Hi, I use the script below to send a email from a contact form but it would be nice if the conformed sent page showed what was sent.Question how can I do this ? Thanks Chris <?php $mailto = 'email@mail.co' ; $subject = "Feedback Form" ; $formurl = "http://page.co/ of form" ; $errorurl = "http://page.co/contact.php" ; $thankyouurl = "http://page.co/thankyou.php" ; $uself = 1; $headersep = (!isset( $uself ) || ($uself == 0)) ? "\r\n" : "\n" ; $name = $_POST['name'] ; $email = $_POST['email'] ; $comments...

Multiple Mail Labels
I'd like to print mailing labels. Simple enough eh? In the db I just took over, the previous fellow had some names listed multiple times, if those folk got more than one copy of the our monthly newsletter. I'd like to clean things up and have each name listed just once. Ideally, I'd have a column for 'number of copies'. Then, when my label report ran, it would read this number and print X number of labels. Is this possible? If so, can anyone offer a suggestion about how to set it up code wise? Thank you. Becky On Sun, 12 Nov 2006 08:13:12 -0800, "Rebecca Smit...

mail address problem?
Hi, I am not sure what the proper definition is for this but here is my problem. I have a name I type in one of the fields, say: vern and has an address My mail knows who is supposed to be vern, but it all shows a bogus name for just: ve How do I get mail to ignore ve? Thanks in advance. bosco In article <2007101123331716807-boscopelone@yahoocom>, bosco <boscopelone@yahoo.com> wrote: > Hi, > > I am not sure what the proper definition is for this but here is my problem. > > I have a name I type in one of the fields, say: vern and has an address > &...

Mail and Address app question
When I get new email how can I adjust either my mail app or the address book so the email addresses of all new incoming mail are automatically saved in my address book as new contacts? nickravo <nickravo@gmail.com> wrote: > When I get new email how can I adjust either my mail app or the address > book so the email addresses of all new incoming mail are automatically > saved in my address book as new contacts? Do you REALLY want that? I'd rethink that one. It sounds like one of those ideas that look good on paper, but may not be in practice. -- /Jon Put "jaalborg&qu...

mail command automated in a script
Please help in creating this shell script, its to email users regarding a process status I want to generate a email from a system, attach a log file to it, everytime this script is run, towards the end of it mail a1@a1.com, a2@a1.com, b2@b1.com how to include this in the script, i want to avoide the ^C everytime and automatically see my emails thru. Thanks JN Unix-Solaris wrote: > Please help in creating this shell script, its to email users regarding > a process status > > I want to generate a email from a system, attach a log file to it, > everytime this script is run,...

What e-mail addresses are compulsory?
Hello all, I'm setting up my own website and an e-mail service at the same domain. I have heard say that there are some e-mail addresses/aliases I *need* to create at my domain. Is there a RFC or other resource that specifies these addresses? I know that, for example, abuse@mydomain.com should exist. What other aliases do I need to create to be compliant with the norms? All help appreciated. - G. Amik The mandatory one is "postmaster" as required per RFC 821, 2821 and 1123. "abuse" and others are covered in RFC 2142 "MAILBOX NAMES FOR COMMON SERVICES, ROLES ...

Redirect all mail to a single address
Hi. I'd like to configure sendmail [8.11.6p2 / AIX 5.1] so it redirects ALL mails to a single remote address. It seems you can easily redirect all mails to a local address, using 'mailertable' by adding this rule : .. local:some_local_user Nevertheless I would like to do so to an external address, say, 'alfred.hitchcock@vertigo.com'. Furthermore, I'd like the solution to be simple, of course ;-) If anyone could give me a hint, it'd be nice ! Thanks in advance. eb -- ----------------------------------------------- Emmanuel Bompard Paris - France...

multiple mail hosts in sendmail
I'm trying to configure my sendmail to use a different mail host (relay host) depending on what the destination address is. The reason for this has to do with our internal security setup. I'm on a solaris 9 platform. So if I have mail to send to xxx@abc.com I would like to use mailhost1, and if I have mail for xxx@anythingelse.com I would like to use mailhost2. Do I have to modify the sendmail.cf manually by creating a private Ruleset which modifies the macro setting for what the mailhost is? thanks for any help. Voltaire <neil_s_chopra@yahoo.com> wrote: > I'm tryi...

E-mailing everyone in my Address Book
Is it possible to send an e-mail to everyone in my address book. I am in the process of changing my e-mail address and find the thought of individual e-mails exhausting. In article <0001HW.C166771500234FEAF0284530@news.claranews.com>, Peter James <pfjamesAT@clara.co.uk> wrote: > Is it possible to send an e-mail to everyone in my address book. I am in the > process of changing my e-mail address and find the thought of individual > e-mails exhausting. For essentially that exact purpose try File->Send Updates -- My personal UDP list: 127.0.0.1, 4ax.com, bu...

Strange IP addresses in script steps
Been working on a project lately which has involved development on different machines. When it is all together on the server Ive noticed that some of the script steps seems to have IP addresses of the developers machines in them. Sometime when I click on them they disappear. Sometimes not. What is happening here? Ive read in the other posts that this could be the cause of a big performance hit. As stated in my other post we are seeing a major degradation on the combined FM5.5 server and FM6 web server running on the same machine. Maybe this is the reason. cheers m Sleepy <ticked.off@rea...

download mail multiple times in Outlook?
My question is basically this: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q216366 But the answer there seems to apply only to Outlook Express, not Outlook. Does anyone know how to get Outlook to download mail left on the server multiple times? Thanks! ...

Script to strip old mail from mailbox
I'm in need of a script that can parse a mailbox and strip out mail older than a given date (lets say a week). I know I've seen them before but I can't for the life of me remember where I saw the various scripts at. I also can't think of a good search string for freshmeat.net. I plan on running the script on each individual user's pre-sorted Spam mailbox and automatically deleting mail older than a week or two. Does anyone know of a script that can do such a thing? I can handle the part about handling each user's spambox easy enough. I need a script that can strip...

FAQ: How do I check a valid mail address?
This message is one of several periodic postings to comp.lang.perl.misc intended to make it easier for perl programmers to find answers to common questions. The core of this message represents an excerpt from the documentation provided with Perl. -------------------------------------------------------------------- 9.17: How do I check a valid mail address? You can't, at least, not in real time. Bummer, eh? Without sending mail to the address and seeing whether there's a human on the other hand to answer you, you cannot determine whether a mail address is valid. Eve...

Finding all e-mail addresses in files on server.
Looking for advice and/or examples on how to audit a server to find all possible e-mail addresses listed in files. Need to verify and possibly consolidate addresses for server monitoring and administration. What I have been doing is greping thru the filesystem and checking for matches to entries in /etc/mail/aliases, /etc/password and any lines containing "mail" (case insensitive) or "@" in crontabs, and scripts. What I would like to do is create an exclude list of certain directories. Then go through the remaining dirs. and extract mail addresses and print them to a file...

mail address faq@tex.ac.uk
apparently, the address has been listed as a soft touch for idiot questions about tex. i've switched the address off (mail to it will bounce). the new address, which makes clear its purpose, may be found in the html version of the faq. (it's not yet in the version on ctan.) -- Robin (http://www.tex.ac.uk/faq) Fairbairns, Cambridge ...

Yahoo Mail Problem
I have two Yahoo e-mail accounts that I access via POP. One of them has two digits at the end of my username. In the past few days, I've had two friends report problems with e-mails to me at this address being bounced back occasionally. Strangely, the bounced message that comes back does not show the two digits in my address. They've been stripped off. It looks as if my friends have e-mailed the wrong address, but they haven't. (My address is in their address book properly.) The user id without the digits is not known to Yahoo, so Yahoo bounces it back at them. Again, t...

Multiple read/write mailbox & filtering mail
I have both Outlook and Pine setup to filter mail based on a header (it filters it to an alternate folder). Each client works fine by itself. However, when both clients are running at the same time, 2 copies of each message ends up in the destination folder. I think this is because Outlook copies the message, and then marks it deleted. Pine moves the message. This gets awful annoying, is there anyway to prevent this from happening (short of yelling at Microsoft to actually make an IMAP-compliant and IMAP-friendly client)? Matt Matt Cuttitta wrote: > I have both Outlook and Pine setup...

Scheduled job to limit the number for mail from the same sender address
Dear all, From my maillog, I observed that some IP address or sender address sending a lot of email to my server within a short interval(5 minutes). Is there any tools or scripts which can grep those information from maillog and add to the access list? Can it also include white list? Any suggestion? ...

Rewriting the sender address for all outgoing e-mail #2
I'm sure this must be a simple task, but we are trying get our mailhub to re-write all sender addresses from internal mail hosts(hostname.leicester.gov.uk) to leicester.gov.uk. Our current topology is that we have several mail servers internally that interact with the mail hub. The mail hub then passes all of the outgoing mail to the mail-relay in the DMZ which then sends to other mail servers on the internet. For incomming addresses, the mailhub uses the alaises.db to determine which internal server to deliver to. We have had a look at the sendmail FAQ which directed us to the manual p...
Privacy Policy | All Times Are GMT(UTC)