Filemaker Pro Script Needed
Filemaker Pro Script Needed
- Subject: Filemaker Pro Script Needed
- From: Howard Sambol <email@hidden>
- Date: Thu, 18 Jul 2002 16:55:26 -0700
To all:
I need an Applescript that extracts email addresses from records in a
Filemaker found set and creates a string of these addresses separated
by commas. The script then pastes this string of addresses into the
proper place in Eudora. The script below is what I have so far. This
one is designed for one email address being viewed rather the entire
found set. All suggestions are appreciated.
Sincerely,
Howard
-- set AppleScript's text item delimiters to {""}
set dnArrow to ASCII character 31
-- set AppleScript's text item delimiters to {"/"}
set theDate to month of (current date) & day of (current date) &
year of (current date)
set goFlag to false
tell application "FileMaker Pro 5"
try
set {fname, email} to ({cell "First Name", cell "Email Address"} of
current record of front document)
-- tell current record
-- set cell "Relevant Data" to (cell "Relevant Data") & "; Email Sent on "
-- end tell
set goFlag to true
end try
end tell
if goFlag then
tell application "Eudora 5.1"
activate
set msg to make new message at end of mailbox "out"
tell msg
set field "To" to email
display dialog "Enter Subject" default answer "Checking In"
set field "subject" to the text returned of the result
set body to "Dear " & fname & ":" & return & return
end tell
end tell
end if
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.