Guess this has been covered before but what I'm trying to do is do a search in a FM8 DB and then send a mass email.

We send out a newsletter and need to send it in one email using BCC so the email addresses are not on display for all to read and keep our clients private.

This I have got to work but I think it's a bad idea to send say 50-150 (depends on the search) email addresses using just one email in case it gets classed as spam.

So what I would like to do is have a script that will take the found records after we have seached them and then batch the addresses say into 20 email addresses then send that over to our email client and into a blank email then send another 20 over.... until all the email addresses in the found records have been sent, of course this could create a few emails but that's OK as we shall then just copy and paste the email content in the email client for each of the emails with the 20 BBC addresses

Hope that makes sense

Any ideas if this could be done?

Ray

Edited March 8, 200718 yr by Guest

Go To Record[First]

Loop

Set Variable[$i ; 0 ]

Set Variable[$exitAt ; 20]

[color:blue]Add this step --> Set Variable[$emailBatch ; "" ]

Loop

Exit Loop If[ $i = $exitAt]

Set Variable[$emailBatch ; emailAddressField & If(not IsEmpty($emailBatch) ; "; " & $emailBatch]

Set Variable[ $i ; $i + 1 ]

Go To Record[Next ; Exit After Last]

End Loop

Set Field[ emailAddressesGlobalForCopy ; $emailBatch ]

Copy[ select ; emailAddressesGlobalForCopy ]

Pause[indefintiley]

#Pauses to give you a chance to go to your email client and paste your email addresses

Exit Loop If[Get(RecordNumber) = Get(FoundCount)]

End Loop

EDIT: Forgot to clear $emailBatch variable after each loop.