Update for Outlook 2003 Junk Email Filter

Yesterday was Patch Tuesday, and of course you have Automatic Updates set to download Critical Updates for you. Right?

But if you use Outlook 2003 you might have missed this one, which isn’t delivered via Windows Update:

Update for Outlook 2003 Junk Email Filter (KB890854)

It’s a shame that Microsoft doesn’t provide any documentation of how these filters work. They do, however, seem to be updating more frequently now. Earlier updates were irregular (December 2003, March 2004). But the most recent two have appeared on Patch Tuesday: September 14, 2004, and November 9, 2004. This update is cumulative. If you skipped the previous updates, this one gets you completely up to date.

From PowerPoint to your TV screen

My sister-in-law Teri asked last week if I knew how to get a PowerPoint presentation onto DVD. She had a 180–slide PowerPoint presentation (made by someone else for a friend’s 50th wedding anniversary party), and they wanted to be able to pop a DVD into a player and watch the show on a big-screen TV.

I’ve written a few chapters on PowerPoint for various revisions of Special Edition Using Microsoft Office, but I’m far from an expert. I know that PowerPoint doesn’t natively support any video formats, and I found an interesting discussion of the topic here. But aside from those leads, I was stumped. So I was glad to get the follow-up today:

Got the 50th Anniversary project done via…

  1. PowerPoint PPT to PPS (less memory use during screen capture)
  2. Screen capture w/ CapturePad shareware 14-day non-crippled tryout (600×800 at 30 fps)
  3. NeroVision Express to burn DVD Video w/Menu (It failed twice trying to burn directly from NeroVision Express, so had to burn to the hard drive first then copy via Nero Recode to DVD)
  4. GoVideo VCR/DVD Player to copy from DVD to VHS tape

This would have been much easier if the author had created the original slide show in MS Movie Maker! PowerPoint is a bitch to match audio to video timing. I had a lot of cleaning up to do to get rid of awkward transitions and I had to shorten one of the WAV files with Creative Wave Studio–which is kinda like cutting sushi with a hatchet.

There were no fancy slide transitions or sound effects used in this 20-minute presentation–just an approximate 6-sec transition between still photo slides and background WAV music files. I don’t know how (or if) a fancy transition or effect would capture (or convert) to AVI–and I don’t have time to test it right now.

I screen-captured presentation with CapturePad to AVI with both video and audio UNCOMPRESSED. (The WAV files were already compressed.) I also noticed that there is a HUGE color loss going from the computer screen to NTSC. I think attention should be paid to colors used (as we do with web page art) and saturation of photos should be pumped up. I also set NeroVision to the highest quality video configuration and configured audio to Dolby 2.0. Make sure that any MICROPHONES (like soundcard headset or other inputs) are turned off (both in soundcard and CapturePad), or CapturePad will over-dubb the audio track with background noise (like me kindly yelling at the dog to get out of the office). The 22-minute, 186-slide presentation w/6 audio files ended up as only 858Mb on DVD.

I’m a happy camper.

I’ll have to try this one of these days!

Office 12 in 2006?

Mary Jo Foley has some very (very!) early Office 12 details:

According to partner sources who requested anonymity, Microsoft has established an internal Office 12 ship calendar that pegs Office Beta 1 availability for August 29, 2005. Beta 2 is slated for December 5, 2005. The internal release-to-manufacturing target is May 22, 2006. And the target for “street” availability for the Office 12 System is July 17, 2006, the sources said.

Hmmm. It might be a while before my next Office book.

Shoebox or file cabinet?

Old joke: The world is divided into two kinds of people, those who divide the world into two groups and those who don’t.

Heh. Actually, I think the world is divided into people who file stuff neatly and those who throw everything into a shoebox. I’ve historically fallen into the latter category, but I’ve always felt a little guilty about it. Which is why I was eager to try a new program called ClearContext Inbox Manager. It’s an add-in for Microsoft Outlook that is supposed to automate the process of sorting and filing e-mail.

How does it work? Well, let’s just say that yesterday, my inbox was overflowing with 4500 messages. Today, it contains 29 messages, all of them related to a project I’m working on now.

ClearContext is easy to set up. Deceptively easy, in fact. I was convinced I had missed something, because installation and configuration were so simple. The program works by examining your Contacts folder and prioritizing your contacts. You answer a few questions to improve the automated process. Incoming messages get assigned a priority based on the sender, the recipient (messages addressed directly to you are more important than those where you’re a bcc), and your level of involvement in the thread. Based on the priority level, each message gets a color code.

Messages get assigned to topics, which map to folders in your mail folder. In about 15 minutes, I set up Auto-Assign rules to automatically categorize messages from mailing lists and frequent correspondents and then move them into folders.

When all was said and done, my inbox was slimmer, all remaining messages were sorted so that the most important ones were at the top of the list, and I was able to quickly delete almost a thousand unnecessary messages.

Thanks to a new toolbar in the Outlook window, I can assign a topic to a message with one click and file it in its folder with another click.

I had done some of this stuff with Outlook message rules, but the ClearContext Auto-Assign rules are much easier to create. Likewise, it’s possible to file messages into Outlook folders, but this add-in makes it much easier.

I’ve tried other add-ins that promise to do similar things, most notably Getting Things Done, which Marc Orchant raves about. But that program tried to force me into a new system, and I wasn’t comfortable with the adjustment.

ClearContext Inbox Manager doesn’t insist that I learn its way of working. Instead, it makes it easier for me to use Outlook the way I always have. You can try it out for 30 days, and if you like it, pay $29.95 to keep using it.

Now, if someone can just come up with a program to file this four-foot-high stack of paper on my desk…

Metadata myths

Stephanie Krieger has an excellent debunking of some myths about the “hidden” parts of files created by Microsoft Office applications: The Whole Truth About Metadata in Office Documents:

Some producers of add-in applications referred to as metadata scrubbers would have you believe that there is a grand conspiracy brewing within your very own documents that only they can solve for you. Even some articles from highly respected publications contain misinformation — the whole topic seems to have turned into an out-of-control, global game of telephone!

The whole article is worth reading. Also, if you use Office, be sure to check out Stephanie’s new blog, Arouet dot net.

Office 2003 for under $125!

[Updated April 23, 2006.]

Have I got a deal for you!

One of the greatest secrets in Microsoft’s catalog is the Student and Teacher Edition of Office 2003. You qualify for this software if you or any member of your household is a full-time or part-time teacher (K-12 or any accredited educational institution), a full- or part-time K-12 student, or a full- or part-time college student taking at least six credit hours. That’s a pretty broad standard of eligibility, and you don’t have to fill out any forms, show any ID, or jump through any hoops to qualify. Anyone can buy it, and anyone can install it.

The Student and Teacher Edition includes Word, Excel, Outlook, and PowerPoint. It can be legally installed on up to three PCs. And best of all, it’s dirt-cheap.

Amazon sells this software for $125 with free shipping. That’s a smokin’ deal. For anyone currently using an older version of Office, this is a good excuse to upgrade. If you want to buy it from Amazon.com, use this link:

I make a few bucks that help offset the cost of keeping this Web site running.

Oh, and feel free to pick up a copy of Special Edition Using Microsoft Office 2003 Student-Teacher Edition, too. It’s new for 2006. Woody Leonhard and I provide a good overview for all four of the programs in this Office version. This ain’t no Dummies book!

Office Tips

In his Office Weblog, Marc Orchant links to a PC Magazine collection of 106 Tips & Tricks for Office. Scoble links to Marc’s entry.

But neither one of them mentions what John Walkenbach and I pointed out several weeks ago: PC Mag’s layout is downright user-hostile. Each tip is on its own page and is surrounded by so many ads it’s almost impossible to find. To get through the 106 Office tips and the 68 Windows tips in that issue, you would have to wear out your index finger clicking the mouse.

I understand the need to support a site with ads. Hey, I’ve got some on this site too. But you also need to show a basic respect for your customers. PC Mag doesn’t do that, which is why I can’t recommend this collection of tips.

Check AOL mail with Outlook

I don’t use AOL myself, but I know some of you do. This week, the authoritative Exchange Messaging Outlook (from Slipstick Systems) explains How to Download AOL E-mail with Outlook. I haven’t tried it myself, obviously, but the folks at Slipstick are as reliable as it gets:

Since the release of Outlook 97, many AOL users wanted to know how to configure Outlook to read AOL e-mail. The answer was always “You can’t, AOL uses a proprietary e-mail system”. Now they can do it–using an IMAP account to access AOL’s mail server. All versions of Outlook can be used, except Outlook 98 or 2000 in Corporate/workgroup mode, since they don’t support IMAP accounts.

AOL requires SMTP authentication, using the same username and password used for collecting incoming e-mail, and uses port 587 for their SMTP server. While the immediate reaction from many people was “leave it to AOL to use non-standard ports”, it’s a smart move in my opinion and I hope other service providers start doing it. AOL users will be able to send e-mail using the AOL SMTP server regardless of how they connect to the SMTP server, as many ISPs now require anyone connected to their network to send email through the ISPs SMTP.

For more information, the server names to use when configuring an AOL account in Outlook, and a link to AOL’s online Open Mail Access Help topic, see Online Services – AOL.

Update: Simpler instructions are available in this article at Microsoft’s Web site.