I’m new to AppleScript and I’m trying to write a script that will go down a list of e-mail addresses in an AppleWorks spreadsheet and use these to compose an E-mail. To make it more complicated I have some text in a TextEdit document that I want to use as the content of the E-Mail. Below is the script so far:
set mail_subject to “International Friends”
tell application “Mail”
activate
end tell
tell application “Finder”
open “Macintosh HD:users:rachelma:documents:international friends:open home.rtf”
end tell
tell application “TextEdit”
select
copy it to clipboard
end tell
tell application “AppleWorks 6”
activate
open “Macintosh HD:users:rachelma:documents:international friends:autumn03.cwk”
tell document “autumn03.cwk”
set CellNumber to 1
repeat until CellNumber is equal to 2
set NumberCell to “B” & CellNumber
set studentAddress to formula of cell NumberCell
if studentAddress contains “@” then
tell application “Mail”
open location “mailto:” & studentAddress & “?subject=” & mail_subject
end tell
end if
set CellNumber to CellNumber + 1
end repeat
end tell
end tell
I’m using AppleScript 1.8.1 on Mac OS X 10.1.5.
Can anyone recommend any documentation that has a full list of the available syntax available to this version of AppleScript.
Thanks for the help in advance and a Happy New Year to you all.