I am trying to copy entourage messages to filemaker 8.0 database and have the following script. If there are more than 1 email recipient, how do I get that into my “to” cell in filemaker?
set emailSender to ""
set emailDate to ""
set emailRecipient to ""
set emailSubject to ""
set emailContent to ""
set eTo to " "
tell application "Microsoft Entourage"
activate
set theMsg to item 1 of (get current messages)
tell theMsg
set emailSender to the address of the sender
set emailDate to the time sent
set theRecipients to every recipient of theMsg whose recipient type is to recipient
tell address of thisRecipient to set eTo to its display name & space & "<" & its address & ">"
set emailSubject to the subject
try
set emailContent to the content
end try
end tell
set citation to "From: " & emailSender & return & "Date: " & emailDate & return & "To: " & emailRecipient & return & "Subject: " & emailSubject & return & return & emailContent as text
set the clipboard to emailDate
end tell
tell application "FileMaker Pro"
set newRecord to create record at end of database "Entourage Archive"
tell newRecord
set cell "Sender" to emailSender
set cell "Body" to emailContent
set cell "Subject" to emailSubject
set cell "To" to thisAddress
set cell "eDate" to emailDate as text
end tell
do script "Ask Folder"
end tell