On or near 1/5/2001 6:20 AM, Jonathan Bauer at [EMAIL PROTECTED] observed:
> And another issue is getting to-do items out of Entourage. I have a script
> that exports calendar items from Entourage and puts them into Excel (you
> have to manually set the date range),
No reason for that! Change these two lines:
> set startdate to date "Sunday, December 3, 2000 12:00:00 AM"
> set EndDate to date "Friday, December 15, 2000 12:00:00 AM"
To this:
set sdstring to text returned of (display dialog "Enter start date in
mm/dd/yyyy format" default answer "")
set edstring to text returned of (display dialog "Enter end date in
mm/dd/yyyy format" default answer "")
try
set startdate to date sdstring
set EndDate to date edstring
on error theErr
display dialog theErr
return
end try
I won't try to write the whole script for tasks, which would involve setting
different column headings in Excel and so on, but to select tasks by due
date, instead of this:
> tell application "Microsoft Entourage"
> set searchResults to every event whose start time �
> is greater than startdate and �
> start time is less than EndDate
>
You could try this:
tell application "Microsoft Entourage"
set searchResults to every task whose due date�
is greater than startdate and �
due date is less than EndDate
To verify that this works, try this with the Tasks window open:
tell application "Microsoft Entourage" to activate
set searchResults to every task whose due date �
is greater than or equal to startdate and �
due date is less than or equal to EndDate
set the selection to searchResults
end tell
Or, if you have the "Sigma's Additions" scripting addition with the "type
text" command, you could make the last two lines into this:
tell application "Microsoft Entourage" to activate
set searchResults to every task whose due date �
is greater than or equal to startdate and �
due date is less than or equal to EndDate
type text "5" holding down command
set the selection to searchResults
end tell
> I think this is supposed to open Excel, but I have found the script only
> works if Excel is already open with a new document. Maybe that gallery
> screen gets in the way?
>
Yes, it would. Open Excel and click on the box to suppress the gallery, and
it will probably work.
--
Peace,
Allen Watson <[EMAIL PROTECTED]> XNS name: =Allen Watson
A Mac family since 1984 <http://home.earthlink.net/~allenwatson/>
Applescripts for Outlook Express and Entourage:
<http://homepage.mac.com/allenwatson/>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
To search the archives:
<http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
