Re: FileMakerPro messages to Entourage calendar
Re: FileMakerPro messages to Entourage calendar
- Subject: Re: FileMakerPro messages to Entourage calendar
- From: Paul Berkowitz <email@hidden>
- Date: Mon, 23 Dec 2002 10:07:47 -0800
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.