Re: FileMakerPro messages to Entourage calendar
Re: FileMakerPro messages to Entourage calendar
- Subject: Re: FileMakerPro messages to Entourage calendar
- From: email@hidden
- Date: Sun, 29 Dec 2002 13:21:56 +0000
Paul: belated thanks for this response. I am working on the Entourage
part of my new FMP database later this week and your advice should
help a lot.
Many thanks
Oz
At 10:07 -0800 23/12/02, Paul Berkowitz wrote:
Ach, I forgot Entourage 2001 had that idiotic limitation that you couldn't
set the due date of a task. But, as a I recall, you can actually set it as
an initial property, which is all you need.
Since it's Entourage 2001, make a task with a reminder. In FMP you can
include "Perform Applescript" or something like that in an FMP script, and
embed the script there, or you can send an AppleEvent to run an applet. I'm
rusty on that part, but there are 100 other people who can tell you, or read
the Apple Events Reference in FMP.
Using an FMP script to extract the data from some cell, let's say that
you've got the date and time when you want a reminder. Set a variable
'theDate' to it. If it's text, then
set theDate to date theDate
outside any tell block. Let's say you also have a name for whatever it is
that needs reminding from some other cell. Set a variable 'theName' to that.
All you have to do is spend about 1 minute looking at Entourage's dictionary
to come up with:
Then
tell application "Microsoft Entourage"
make new task with properties {name:theName, due date:theDate,
remind date and time:theDate}
end tell
Possibly you need to keep Entourage open. Otherwise, to avoid a "Where is
Microsoft Entourage?" box coming up when it's not open, you may have to do
it this way:
-----------
tell application "Finder"
set MicrosoftEntourage to application file id "OPIM" as string
end tell
using terms from application "Microsoft Entourage"
tell application MicrosoftEntourage
launch -- opens in background if not already open
make new task with properties {name:theName, due date:theDate,
remind date and time:theDate}
end tell
end using terms from
-------------------
Especially since you're calling the Finder, you must make sure that the user
does NOT have AppleScript 1.7, which came with OS 9.2.2, installed. It's
horrible, and everything will hang and go wrong. If they're actually using
OS 9.2.1 with AS 1.6, that's fine. If they have AS 1.7., immediately update
to AppleScript 1.8.3 and Standard Additions 1.8.3 (they come together),
which you can download from Apple's Software webpage.
--
Paul Berkowitz
From: email@hidden
Date: Mon, 23 Dec 2002 08:22:14 +0000
To: Applescript-Users <email@hidden>
Subject: Re: FileMakerPro messages to Entourage calendar
Many thanks for this advice, as I was not aware that Entourage X had
this extra scriptable feature, but do you know of any way I can get
FileMaker Pro to create the reminder in Entourage? This will be used
by someone at work who will for the foreseeable future be using OS9.2.
Many thanks
Oz
At 23:45 -0800 22/12/02, Paul Berkowitz wrote:
On 12/22/02 11:18 PM, "OzSprings" <email@hidden> wrote:
I have been able to send emails from FMP to Entourage, but is there
any way via AppleScript I can send reminders from timetable fields in
FMP to Entourage's calendar/schedule? Or is there any way FMP can
generate reminders (beeps + dialog boxes) itself at specified times
and dates?
You can create a new event or task in Entourage, including the reminder
(which works differently for event - where it's minutes before start time -
and task - where it's a date. If you've got Entourage 2001, you'll have to
make a task since 'remind time' of event wasn't scriptable there, but
'reminder date and time' of task was. In Entourage X, they're both
scriptable. You can even create an event or task with no content except the
reminder, but a subject (title) would be useful. You can make the
start time
of event the same as the reminder time by making the reminder time 0. In
>> fact, if ever you want to create an event _without_ a reminder,
you have to
omit the 'remind time' property since otherwise a remind time of 0 does
bring up a reminder as the event's start time arrives.
--
Paul Berkowitz
_______________________________________________
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.
_______________________________________________
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.