702 ofﬁce 2004 for macintosh: the missing manual
Installing and Running Ofﬁce Scripts
Whether you choose to write your own scripts or not, you can always run scripts
that others have written. Since Word, Excel, and PowerPoint 2004 scripting is so
new, there are only a few scripts available for them—for now. There are bound to be
a great many scripts written and distributed as time goes on. Entourage already has
hundreds of scripts, almost all of them free, some of which can do amazing things
and make your life easier in the process. If you can drag and drop, you can install
and run an AppleScript.
1. Download the script package from the Web site. Unstuff or unzip it if neces-
You’ll usually end up with a folder containing a script ﬁle, a ReadMe document,
and perhaps one or more supporting ﬁles.
The script ﬁle will look like one of the icons in Figure 21-1.
2. Read the ReadMe—or at least any installation and setup sections it may have—for
any special instructions.
Scripts come in two basic forms—applications, known as applets, or as scripts (script
documents), as shown in Figure 21-1. Developers create their scripts in either of these
two forms when they save them.
Installing Applets (Script Applications) and Droplets
If the icon is an applet (or droplet) as shown in Figure 21-1, you can store it, and its
folder, anywhere at all on your computer. You can move it to your Applications folder
or to a subfolder for scripts within it, or to your Microsoft User Data folder (even
though it’s not data) or to a subfolder for Ofﬁce script applets you can make there.
You can also drag the applet icon to your Dock, as with any application, so you can
launch it from there. If it’s a script you’ll be using often, dock it.
Run the applet by double-clicking it, like any application, or by clicking it in the Dock
if it’s there. Or if it’s a droplet (with the down arrow), drag one or more ﬁles of the
Left: Script applications (applets) bear a hidden .app extension. You run
them by double-clicking them, or you can put them in the Dock and click
them there, like any application. Some applets have a downward arrow
included in the icon indicating that they’re droplets. These scripts run when
you drag and drop ﬁles onto them. Applets and droplets take a few seconds
to start up; you’ll see them bounce in the Dock.
Right: Script ﬁles, or documents, which may bear the .scpt extension, have no
such overhead. They start immediately, but to run them you have to install a
special Script menu (page 703).
chapter 21: applescripting ofﬁce 703
appropriate type—usually a Word, Excel, or PowerPoint document—onto it. You can
even store droplets in the Dock and drop ﬁles onto it there.
If the icon is a script document (see Figure 21-1; it may or may not bear an .scpt ex-
tension), then you have to put it in a speciﬁc place depending on whether it’s a script
for Entourage or for one of the other Ofﬁce applications. Read on.
Installing Entourage Script Menu Scripts
When you’re in Entourage, you’ll notice a dark, scroll-shaped icon just to the right
of the Help menu in the menu bar. That’s Entourage’s exclusive Script menu, and it
comes preloaded with a few scripts that automate multi-step Entourage processes,
like turning the selected email message into an Entourage note. Word, Excel, and
PowerPoint don’t come with their own Script menus, so you have to install Mac
OS X’s Script menu, as described in the next section.
Here’s how to add to this menu any AppleScripts you’ve downloaded from the Web
or written yourself.
1. If the script is a script document for Entourage, drag the icon into your Home→
Documents→Microsoft User Data→Entourage Script Menu Items folder (see
In the Entourage Script menu, You now see a menu item with the name of the
script (see Figure 21-3).
The Entourage Script
Menu Items folder lives
in your Documents→
Microsoft User Data
folder. Any scripts
placed here appear
as if by magic in the
Entourage Script menu.
You can run them
by selecting them, or
even set up Rules and
Schedules to run scripts
Entourage has its own Script
menu, just next to the Help