Email break calculation...

[Jalz]

Hi Guys,

Need some help with a calc. I have a database which stores contact details which includes email addresses. I use Outlook to send the emails out from FileMaker 9. Unfortunately, outlook has a limit of 32000 characters and occasionally when we send out bulk emails, they exceed the character limit which means we dont send out emails to those recipients at the bottom in the list.

What I would like to do is split the field (collection of all the emails) I have which contains all the emails into two and send two emails out, one with the first half of upto 32000 characters, and then a second with the remainder.

Can someone tell me how I can calculate obtaining the last "full" email address before the 32000 character limit.

The email addresses are seperated using a semicolumn, so a sample could be....

[email protected]; [email protected]; [email protected];

and so forth.....

Finally I'm not using a looping script to send out an email from FM, because FileMaker uses standard Mapi to connect to outlook which causes alot of security warnings, so the idea is to collect the emails into two fields and send two emails out from the BCC field.

Many Thanks

Jalz

[comment]

how I can calculate obtaining the last "full" email address before the 32000 character limit

Try something like:

Left ( text ; Position ( text ; ";" ; 32000 ; -1 ) )

[Jalz]

Thank you,

That is exactly what I wanted!