Email scripting

[hfinger]

I have a class registration database which has a script (runs daily) that searches for the students for that day and sends them a reminder email. Problem is that the email address that is generated (I'm using the "Get values from every record in found set" button) is separated by semicolons not commas and the emails are not getting to the students.

Anyone know how to rectify this problem?

[Reed]

You could script it in a loop and send one email at a time instead of using the whole found set in one email. This way each recipient would only see their address in the To: field, and not the whole distribution list.

[hfinger]

That's my backup plan. I'd like to do it with one email if possible.

BTW, it worked correctly in Filemaker 6.

Edited October 7, 2005 by Guest

[maulanday]

I want to write a script for a button that will allow me to email a group of people in a portal?

How do I do that?

[mr_vodka]

Well if you are using FM8 this is pretty easy. In your script, Go to Related Records that your portal is based off of (with the option of show only realted records on). Then in your Send Mail script, there is an option for mutilple emails (found set)

[maulanday]

Okay...I'm sorry but I have never worked with FileMaker until about 1.5 months ago. I don't know how to write scripts.

Here's a break down of what I need to do. I have a record for 100 different groups. Within those groups I have a portal with its members. In the portal, I have their name, phone and emails. Some of those portals have more than one member. The portal is related to another table. So, what I would like to do is create a button at the bottom of the portal, where the email application pops up and list the people's email addresses within that portal from that record. Did I confuse you? I tried your suggestion, but it didn't do what I wanted. Sorry:(

[mr_vodka]

Take a look at this mock file.

email.zip

[maulanday]

:yay:

THANK YOU SOOO MUCH!!!

You have no idea how much you have helped me!!!

:thankyou:

[maulanday]

OOOPS!!! I have a problem. I want send an email the members from one group, which I have a record for each one. This option is having me email all the groups.

For example, I have one group (record) called "Alaska." In that record, I want to be able to email everyone on that record. Now I have a different group (record) called "Minnesota." The people in Minnesota are not the same people in the "Alaska" group. I want to be able to email people from only that "Minnesota" group.

Is that possible?

Okay also if I don't have an email for one of the fields in that record, is possible to still email the people who do have email addresses in that email field.

Edited November 17, 2005 by Guest

[mr_vodka]

The example that posted for you email each seperate group; not all the groups.

As for those that do not have email addresses, if it is blank it will not include all their email address.

Maybe I am not understanding you?

[maulanday]

I'm sorry for the confusion.

I have it set right now the way you have it on the example. But instead of collecting email addresses just from that specific record it's collecting email addresses from all the records. And I don't know why it's doing that.

Edited November 17, 2005 by Guest

[mr_vodka]

can you post a zipped copy of your file.

[maulanday]

I would like to but a lot of information is confidential. Hmm...how else should I do this...

[mr_vodka]

make a copy of the file. Delete the records in the copied file. Then zip and upload.

[maulanday]

Mr_Vodka,

Here is a copy of my file. Thank you for your help.

Is there a way to include in my script to filter my portal into a found set? How do I change my file type?

Edited November 18, 2005 by Guest

[curious99]

Hi,

I'm trying to do the same, i.e. email to a group, but in version 6. I'm hoping to email from file "a" but the records containing the email adresses is in file "b". I do not want to email to all the records of file "b" only those that match. Is it tough to do in version 6?

[mr_vodka]

I do not see a file.

[mr_vodka]

Luc, why dont you try something like this.

Email_FM6.zip

[curious99]

Hi Mr_Vodka,

It is exactly what I needed. You've solved an issue I've had for a long while. It will definitely help me a lot.

Thanks so much for your prompt help.

Have a great weekend!

-)

Luc