Re: Filemaker Pro Script Needed
Re: Filemaker Pro Script Needed
- Subject: Re: Filemaker Pro Script Needed
- From: Malcolm Fitzgerald <email@hidden>
- Date: Fri, 19 Jul 2002 15:22:21 +1000
FMP's "Send Mail" script step is all you need. The dialog box for "To"
and "Cc" allows you to select a field and choose whether the field will
be populated by the current record or current found set of records.
Select "current found set" and you'll have a comma separated list of
email addresses appear in which ever email client you have specified in
your internet control panel
On Friday, July 19, 2002, at 09:55 AM, Howard Sambol wrote:
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.
_______________________________________________
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.