Hello,

I'm very new to AppleScripting and I'm trying to find an AppleScript that will allow me to compose an email with multiple BCC contacts from my FM database. I've made a novice attempt so far to which I managed to set up a new draft window with the correct "to" recipient and a BCC recipient of the first record but cannot add more than one recipient. Any help with this greatly appreciated, Here's a copy of my current script:

tell application "FileMaker Pro"

set strURL to cell "g_email_to" of current record

set strSUBJ to cell "Subject" of current record

set strBCC to cell "email" of current record

set strCOUNT to cell "new_record_count" of current record

set strMAILTO to {"<" & strURL & ">"}

end tell

tell application "Microsoft Entourage"

activate

set theMSG to make new draft window with properties {to recipients:strMAILTO, BCC recipients:strBCC, subject:strSUBJ}

end tell

repeat strCOUNT - 1 times

tell application "FileMaker Pro"

tell database "Comms Contacts.fp5"

go to record after current record

set strBCC to cell "email" of current record

end tell

tell application "Microsoft Entourage"

tell theMSG

make new bcc recipient at end with properties {BCC recipients:strBCC}

end tell

end tell

end tell

end repeat

What works for me is to have the multiple addresses in the FMP field, seperated by commas. Then you don't have to manipulate the script, just add to the field then pass them all over to Entourage at once. So if the field is named "bccaddressess" set its content to "[email protected],[email protected]" etc.

Works a treat! Thanks!