Does anyone have an example of a script to split email recipients (customer records) into smaller groups prior to emailing?

My found set has maybe 500 and I want to split into groups of 50 or less in order to not annoy the ISP or be blacklisted as a spammer.

I used to do this with a scrip in Entourage called 'split recipients'. Now that I've "Upgraded" (ahem) to Outlook I'm unable to do this, so its up to FM to save the day.

Thanks

Phil

We do this using a looping script and a counter. Our "Send Queued Emails" script finds all email records that are waiting to be sent, and loops thru sending them until it reaches the counter value.

Thanks bcooney,

I send emails as one email with many BCC'd addresses, so I want to group email the first 50 in my found set, then the next 50, etc.

I'm thinking I need a field to assign a temporary serial number, then find numbers 1..50 and send, then find 51-100 and send?

I was hoping someone might already have one I could use as a reference.

Or, you could use the loop like bcooney mentioned, and add the BCC addresses to a variable, then use that variable in your Send Mail step. Are you using FileMaker 11's Send Mail step, with SMTP server option?

I'm using FM11 Send Mail script step, but not with SMTP because I want the user to have a record of the email in their mail client's sent items. This is preferred but not essential. Besides skipping the mail client, is there an advantage to using SMTP?

Can someone please tell how to properly format the "To" field so it works with the recipient's (FirstName, LastName, EmailAddress)? I am able to send mail via Apple Mail and Entourage with no problems but the people in our office that are using Outlook for Mac are getting errors. It appears that Outlook is trying to wrap whatever FileMaker is sending with < > which is causing an error. If I send to the recipient's email address and omit their name Outlook works fine.

My current calculation looks like this:

FirstName & " " & LastName & " <" & EmailAddress  & ">"