Thanks very much! What a big help. Below is an Apple Script that will place all events within a given date range into an open Excel worksheet. I now can use Entourage to keep track of client billing. I already have a system that filters such a list from the exported calendar items for Palm desktop (which I’m now enthusiastically discarding) in to individual billing records. It’s a simple matter from here to maintain an Excel list of all pertinent categories, and then simply fire this script from Excel and then filter the list from Entourage to generate the invoices. One button push in Excel will get the whole job done.
Here’s the script for anyone who is interested. Many thanks again to Paul Berkowitz who got me over an incredible impasse.
Glad to help, Bob. It’s a rather good thing that I picked “, “ to be the delimiter since Excel understands comma-delimited text by default. I’m glad you found the one little tweak in the part of the script I contributed that makes it “better code”, though I don’t think you’ll notice any difference. Maybe if you have 500 events, you’ll save 1 second! I was going to tell you about it, so it’s good you found it for yourself. (You only need to set the delimiters once, before the repeat loop, not on every iteration.)
--
Paul Berkowitz
