If you've been cursing the big price tag and lack of VBA support in Microsoft Office 2008 for Mac, OpenOffice.org is coming to your rescue. Last September, the OpenOffice.org dev team announced that they would be porting the suite to run natively on the Mac. Previous versions ran under the X11 environment, which not only hogged resources, but didn't have the Aqua look and feel we all love.

OpenOffice.org 3.0 is still beta, but a quick test-drive of the application showed that it is almost ready for prime time. OOo is a full-featured office suite, complete with word processor (Writer), spreadsheet (Calc), presentation package (Impress), drawing app (Draw), as well as database tools (Base) that are sadly lacking in other office suites.

The feature set of OpenOffice.org 3 is impressive:

• Imports Microsoft Office binary (.doc, .ppt, .xls) and Office 2007/Office 2008 for Mac (.docx, .xlsx, .pptx) files
• A solver component for solving optimization problems, something lacking in Microsoft Office 2008 for Mac
• Spreadsheet workbook sharing
• Display of multiple Writer pages while editing
• MS Office-like comments in Writer
• Limited VBA macro support -- which is still better than no support
• Extensibility with Mozilla Thunderbird and Lightning, Sun Wiki Publisher and Report Builder

The price of OpenOffice.org 3 is, as always, free! If you're up to test-driving beta ware that may not necessarily be as stable or fast as your other office suite(s), click here to be transported to the beta site.

Welcome to the 3rd Microsoft Office 2008 automation post. Previously we covered automating Excel 2008 and Word 2008, now we shine the spotlight on PowerPoint 2008. In this how-to, I will show you how to create an Automator workflow to automate the daunting task of applying animations to the slides and converting a presentation into a QuickTime movie file.

For this workflow, you'll need the following Automator actions (in the same order):

• Apply Animation to PowerPoint Slide Parts
• Convert PowerPoint Presentations to Movies
• Play Movies

Continue reading to learn how to create this workflow.

Mac lovers traveling to the UK may be able to leave their computers at home -- as long as they stay at a City Inn hotel.

Guests will find a shiny iMac in each room, with full access to the internet, iLife and Office apps. Plus, the hotel will let you use the iMac as a TV, internet radio and media player (DVDs and CDs).

"But will the hotel keep a history of what I do with that machine?" you ask. The answer is "No." They use Faronics Deep Freeze software to restore each machine to its factory settings every 24 hours, so you're safe (that also means you shouldn't save the article you're writing on the iMac's hard drive).

This isn't the first time we've seen hotels offer Apple products to guests. In 2004, several W hotels gave away iMacs, iPods and music on "iTunes Days," and just last year Pod Hotels offered an iPod dock in each room.

[Via Macenstein]

Kerio Technologies announced version 6.5 of the Kerio MailServer -- 2 years in the making -- yesterday. We talked about version 6 recently, but this is their largest update yet and clearly shows their readiness to take a bite out of the Microsoft Exchange market. With version 6.5, Kerio is providing the groupware platform and tools needed to completely replace Exchange within a collaboration-centric organization.

The release is compatible with both server and workstation flavors of OS X with full support for Leopard, in addition to being fully Microsoft certified for Vista and Redhat certified for Linux compatibility. 6.5 also includes enhanced support for Entourage 2008, making full use of message flags and "out of office" messages which are synced on both mobile and workstation clients.

The biggest change of interest to Mac users is the addition of CalDAV support. Kerio users can look up information, share and subscribe to calendars and achieve 2-way sync whether they're on a Mac, an iPhone, a Palm or Windows Mobile handheld, a PC ... you get the idea. The server can provide a bridge between open and proprietary standards, making sure that you see the same data everywhere and allowing for smooth cross-platform interoperability.

The other major improvement, definitely of interest to users in multi-platform environments, is an upgrade to the Outlook Connector with a complete rewrite of its underlying database structure. It allows for easy data access, online and offline, with current and older versions of Outlook. And its full-text search capabilities search across messages, contacts and calendar events with support for Google Desktop search.

Not surprisingly, a release this big resulted in a pricing change. The standard package (10 users) now starts at $499 and adding additional users costs $20 per user. A version with integrated McAfee Anti-Virus for bi-directional scanning of all email starts at $599 and additional users are $24 each. Both versions include anti-spam, user management with authentication against Active Directory and Open Directory. Visit Kerio for more information.

Update: The US Apple Store is now carrying a base server (10 user) license and install media for Kerio MailServer with McAfee.

Among the security patches delivered with Microsoft's 11.4.0 update to Office 2004 this week, there was a fix for a subtle and deeply irritating bug that's been nipping at Exchange users for a long time. Under certain rare circumstances, Entourage users could unexpectedly and unexplainedly lose days or weeks worth of email, poof! I've personally seen this happen a handful of times over the past three years, and it's always a challenging conversation when the affected user asks "What the hell happened?" and the official reply is "Um... let me check the backups for you, mmmkay?"

TUAW reader Vermyndax, who worked with Microsoft support to track down the bug, blogged about the cause and resolution of the issue today:

The bug occurs due to a bad logic assumption. Entourage 2004 treats its local database as authoritative to the mail stored in your mailbox. As such, if the Exchange server happens to be virus-scanning your mailbox when you synchronize your mail, Exchange will refuse to allow Entourage access to the items being scanned. Since Entourage receives no information on the existence of those items, it will mark them for deletion in its local database.

On the next sync, you lose all of those items in the mailbox too. In cases we noted, users were losing large swaths of email at once (on the order of 2-3 weeks' worth all at once).

Yech. While you could recover the mail from Outlook/OWA "Deleted Items," it was a pain -- and worse if you didn't notice the problem until after your retention deadline had passed. Upgrading to 11.4.0, assuming you aren't quite ready to make the leap to Office 2008, is sounding better all the time.

Thanks Vermyndax!

Microsoft releases patches for most of their products on a monthly schedule, on the second Tuesday of the month specifically. I'm telling you this because today is the second Tuesday of February and Microsoft has a gift for all you Office 2004 for the Mac users: a patch for a critical vulnerability (insert obligatory Microsoft joke here).

Microsoft Office 2004 for Mac 11.4.0 Update addresses, 'a vulnerability that an attacker can use to overwrite the contents of your computer's memory with malicious code.' Nobody wants malicious code on their computer, so if you're running Office 2004 for Mac on your Mac, apply this update as soon as possible. Office 2008 for Mac does not have this vulnerability.

And they found ... not that much. There's something not-quite-right about these snapshots purportedly from inside Apple's Cupertino campus. They look like they come from almost anywhere -- despite the plentiful Apple products (and one notable Microsoft natural keyboard), there's no major signs of genius -- no "the crazy ones" posters, iTablet prototypes lying around, or "how to act around His Steveness" employee pamphlets. Could it be that the people who work at Apple are, strangely enough, just like us?

No, surely not. These pictures are also a bit out of date, we're told, as rumor has it that the front lobby always shows off the new products, not the old iMacs. So clearly these snaps are from the late '90s, when the rest of us were using beige boxes and OS 9 to compute, and only Apple employees had the luxury of using thin keyboards and horizontal LCDs gone vertical (madness!) in their super-futuristic office space. There: our worldview is back to normal. As normal as it gets, anyway.

Thanks, Steve!

When I posted about the Zimbra collaboration suite a little while ago, it was noted in the comments that, while the Zimbra client is now working in Safari 3, the server isn't yet Leopard-compatible. Kerio MailServer offers a Safari 3 and Leopard-compatible alternative with a lot of groupware functionality.

Kerio's Safari 3 compatibility stems mostly from the fact that it doesn't have a rich text editor in the client, but it works flawlessly for plain text email and the interface is as smooth and AJAXy as Zimbra's. Kerio has had a Mac version of the server since 2003, with drop-in Exchange replacement capability and the ability to sync contacts, calendars and email without the need for an external client. Kerio has even had iPhone sync since last Fall.

Kerio's pricing structure is slightly different from Zimbra's, but competitive; there's no open source Kerio version, as there is with Zimbra. But if you're in the market for a Leopard-based mail server and collaboration solution, Kerio seems to be a pretty good choice.

No, this won't be another post where I explain my reasons for loving and ordering the MacBook Air. That will come later when I actually have the MBA in my hands. Until then, I want to pass along a little bit of knowledge I learned while doing Mac consulting many moons ago: many files and folders on your Mac should be left alone and not moved or thrown away.

One particular incident that illustrates this point happened to a user who called me one day saying his entire Microsoft Entourage store of emails, contacts, etc. had just "disappeared" and Entourage had "reset to when it was new." Well, naturally that sounded a bit odd to me so I went over to see what I could do to resolve this little problem.

After a bit of searching around I discovered the user had "accidentally" moved a very important folder out of a folder called "Documents" (which is located in his individual "Users" folder) to the Trash. For the win, can you guess which folder he threw in the trash? iI you guessed it was his "Microsoft User Data" folder, you would be correct.

Fortunately for this particular user, after moving the folder back where it belonged all was well with Entourage and his data was restored. Let's go over that again, just to be clear. This particular folder, the "Microsoft User Data" folder, is located in your particular "Documents" folder on the hard drive of your computer.

If you do any work in Office you've probably been waiting for the latest update for a couple of years now. Especially if you're on an Intel machine or have struggled with Entourage's funky interface (or is that just me?). Last week Microsoft released Office 2008 for the Mac, and it's a doozy of an update. Being a universal binary is really the least of the changes. This is a complete overhaul, with a ton of UI changes and workflow improvements. Amanda Lefebvre takes us on a whirlwind tour of some new features, and explains the difference between the three different editions of Office.

I'm not ashamed to admit that I love Safari. Unfortunately, not all web developers are hip to it, especially when it comes to Ajax-based web apps. In fact, I'd have trouble naming very many web-based, "WYSIWYG" editors, let alone full collaboration suites, that work well with Safari. That's why I was pleased to hear that the Leopard-loving folks at Zimbra, the open source messaging and collaboration suite, have announced expanded support for Mac users, including Safari compatibility. To the best of my knowledge (and according to their press release), this makes them the first major collaboration suite to support Safari.

And the support, especially in the document editor, is good. It uses valid XHTML tags and CSS to create cross-browser compatibility. I think the feature I love the most right now is the full support for rich text pasting (and no font tags). If you're using Firefox, you get page previews, monetary conversions and more when hovering over different bits of information. These seem to be missing on Safari, but that could be on account of an odd setting in my configuration.

In addition to Safari support, Zimbra has also added support for CalDav, allowing iCal 3 to sync and share calendars through its server. And for the mobile set, they've added a mobile HTML client that makes the suite iPhone compatible. With the preexisting Zimbra Connector for iSync, Zimbra users can sync their email, address books and calendars to their iPhone.

You can catch Zimbra at Macworld in booth W-4348. Zimbra is available for free as the ZCS 5.0 Open Source Edition. They also offer a Network Edition with commercial support, educational discounts available. And for the curious, you can demo the suite online at their website.

Many of you have already gotten the email inviting you to dig deep into your pockets, so let me relay the news to them that hasn't: you can now pre-order Microsoft Office 2008 from Apple and Amazon, with delivery scheduled on January 15th.

If you were hoping to install Office 2008 in the first few moments after its official release... well, my suggestion is to wait a few days for the issues to shake out. Otherwise, better have a second machine around to get work done.

Thanks to everyone who sent this in.

I'm becoming the Microsoft Office Maven here at TUAW it would seem (which isn't as cool as being TUAW's iPhone hacker, Erica, but I'll take what I can get). The latest news from our friends at Redmond concerns editions and price (Oh! Pricing!).

There will be three different flavors of Office 2008 for the Mac, and they are as follows:

• Microsoft Office 2008 for the Mac: This is the core version of the productivity suite which includes Word, Excel, Powerpoint, and Entourage. This version includes some Automator workflows, as well as Exchange support in Entourage (you'll see why I mention this in a moment). You can pick this version up for $399.95 (US) for the full retail version and $239.95 for an upgrade.
• Microsoft Office for the Mac Home and Student Edition: This is aimed at the segment of the market that needs to edit documents and such, but isn't in an Exchange environment. As such the version of Entourage included in Home and Student Edition does not support Exchange, nor do you get Automator workflows with this edition. This edition only comes in the full retail flavor for $149.95 (which isn't a bad price at all, though this one is a no go for me).
• Microsoft Office for Mac Special Media Edition: This one is interesting. It includes everything in the core suite (including Exchange support) as well as a full version of Microsoft Expression Media for Mac for $499.95 or $299.95 for the upgrade.

It is worth noting, for our international readers, that Office 2008 for Mac will be available in Dutch, English, French, German, Italian, Japanese, Spanish, Swedish, and, new in this version Danish, Finnish and Norwegian.

Our Weblogs, Inc. buddies at Download Squad bring us this news: OpenOffice is going to be able to run natively on the Mac in 2008.

The OpenOffice suite is getting pretty impressive-- while Writer, Impress, and Calc might not be necessary when you have Pages, Keynote, and Numbers around, OpenOffice's Math, Draw, and Base will probably be welcome additions to a few Macs out there. And don't underestimate compatibility-- back when I had to use a PC at work, OpenOffice was a constant tool, and using the same program at work and home has its advantages for people who are forced to co-OS.

If you can't wait another year, there is still an alpha version available of the native port, and you might be waiting even longer than 2008 anyway-- we were promised a native port a year ago that apparently never showed up in full form. And don't forget about NeoOffice, either-- it's a very nice branch of the OpenOffice code that already natively runs on the Mac. Why wait for OpenOffice to get in gear when those folks have been punching out a native app for a long time now?

Microsoft Office: no matter what your feelings are about Microsoft as an entity there is no denying that their eponymous office suite is an important application for the Mac. Sadly, the newest version, Office 2008 for the Mac, has hit some bumps along the development path and has been delayed until January 2008 (one assumes Macworld 2008 will be its coming out party). There is a limited beta going on, but few have been invited to participate and the only glimpse into the next version of Office that most Mac users have had has been right here on TUAW with our gallery of screenshots from Macworld 2007 (which, I should point out, Microsoft was nice enough to provide to us).

Now comes word that the Mac BU (that's the Microsoft Mac Business Unit, which is responsible for most Mac software that comes from Microsoft) has started to post some new tidbits about Office 2008 for the Mac on the Mac Mojo Blog. They'll be sharing more and more info as the ship date gets closer and closer.

During Macworld I was able to sit down with some Microsoft folks and get a brief look at where Office 2008 for the Mac stood at the time. I was very interested in seeing the next version of Entourage, since that is the one Office app I use everyday. Sadly, at that time Entourage 2008 was so unstable they weren't comfortable showing it to me. Luckily, for me, the first new feature highlighted by the Mac BU is one that is new to Entourage 2008: Out of Office replies. That's right, in order to set Out of Office replies in an Exchange envirnonment Mac users are forced to turn to the Exchange web interface (which offers few options for Out of Office replies). Entourage 2008, paired with Exchange 2007, allows Macs users to set Out of Office messages, as well as configure different messages to be sent depending on who is emailing you, and have the message automatically turn itself off after a certain time (which is killer).