KYSBSUG Meeting August 19, 2009 – Office 2010 First Look

This is a friendly reminder about the August KYSBSUG Meeting tonight:

KYSBSUG logoGroup: Kentucky Small Business Server User Group (KYSBSUG)
Meeting #: 66
Meeting Date: Wednesday August 19, 2009
Time: 6:30 PM Eastern
Location: Money Concepts
Address: 323 Townpark Circle, Suite 100, Louisville, KY 40243
Map: Click here for map on Bing.com

Presenter: Tim Barrett
Topic: Office 2010 – First Look

Description: Tonight we’ll take you on a tour of the new features of the 2010 applications and point you to resources to learn more about the next wave of Microsoft Office.

Registration URL: Registration is not required for this event.

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)

Downloads – Service Pack 2 for Office 2007

image Recently announced: Service Pack 2 for Microsoft Office 2007 is finally available for download.

Download URL: Click here
File name: office2007sp2-kb953195-fullfile-en-us.exe
Date published: 04/24/2009
Size: 290 MB

KEY IMPROVEMENTS:

  • Ability to open, edit and save OpenOffice.org 1.1 documents (*.odt, *.ods, *.odp)
  • SaveAs PDF has been added back in (no need to download separately)
  • Improved graphic presentation and printing
  • OneNote / SharePoint synchronization improved
  • Groove synchronization improved
  • Outlook performance improvements in startup, shutdown & viewing
  • and more
VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)

How to Insert Scanned Images into Word 2007

From the help desk file…

Reported Issue: Scanning pictures into Word 2003 was easy, but how do you do that in Word 2007?

Observation: Thanks to user feedback and the Microsoft Customer Experience Improvement Program, Office 2007 spanks the llama in almost every way.  However, the issue of scanner support is one area where Office 2007, quite frankly, stinks like a sumo wrestler’s thong.

Behold…

word_2003 Word 2003 – Easy, peasy, lemon squeezy:

  1. Open Word 2003
  2. Click Insert
  3. Click Picture
  4. Click From Camera or Scanner
  5. Your scanning software takes over and begins scanning the picture
     

image 

And now the stinky way…

word_2007_iconWord 2007 – Not so easy, un-peasy, and you’re the one getting squeezed:

  1. Open Word 2007
  2. Click the Insert tab
  3. Click Clip Art in the Illustrations pane
  4. When the Clip Art side bar opens on the right, click Organize clips…
  5. Click File in the Favorites – Microsoft Clip Organizer window
  6. Click Add Clip to Organizer
  7. Click From Scanner or Camera…
  8. Your scanning software takes over and begins scanning the picture
     

image

Once you’ve saved the scanned image as a TIFF file, you can insert it into your document.

I’ve presented on Microsoft Office 2007 quite a few times and have parroted the logic that the great thing about “The Ribbon” interface is that ‘everything that you can insert is on the Insert tab’. I stand corrected.

Verdict: Definite pain in the butt = doable though.

Research Info: http://support.microsoft.com/kb/827100

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)

Beta – Xobni – First Impressions

Recently I started using a new Outlook plug-in called Xobni (thanks for the invite Nick!)  Xobni isn’t new. In fact Bill Gates talked about it over a year ago:

What Xobni Does

Basically, Xobni (pronounced ‘zob-nee’) lets you track email relationships, conversations, connections with others, and (my favorite feature) provides a no-search list of files exchanged with others.  It also provides metrics on what time of the day someone emails you.

imageHere’s an example from my personal email account,
and just for fun, we’ll pick on Kevin:

Top Section – Name, Emails Received, Time of Day, Emails In (received) vs. Emails Out (sent) and includes To From CC and BCC, and Rank based on the number of emails to and from this person.

Contact Info – Phone (this is automatically pulled from email body), link to schedule a meeting, link to create an email.

People Connected to… – These are contacts that I’ve CC’ed in an email to Kevin, or contacts he’s CC’ed me on.

Conversations with… – Threaded conversations with this contact.

Files Exchanged with… – My favorite feature! Whether I sent the file to Kevin, or he sent it to me, it shows up here. VERY nice.

LIKES:

  • The ‘Files Exchanged’ folder (obviously)
  • The time chart at the top. This has actually been pretty helpful in identifying when someone is typically in front of their computer
  • The ‘Stay In Touch’ feature – This shows who you haven’t emailed in a month, 2 months, 3 months or longer.

DISLIKES:

  • The contact card in Xobni is limited and doesn’t pull a photo from the Outlook contact card (you have to add it manually)
  • No mobile version
  • Can’t see a list ranking with all the people (who’s #1, who’s #500) as far as I can tell. If you want to know where someone is, you have to hunt them down first.
  • I’m not clear if the metrics go away when you delete items (I think it tracks the archive though).
  • No way to change the time zones for senders

Regarding the time zone issue, I could go either way on this one.

Take Susan for example, she’s in California (GMT -8) and I’m Kentucky (GMT-5). So, while it’s true that sometimes she sends email when it’s 3AM for me, it’s only midnight for her, so it’s a bit confusing at first glance because it looks like she’s still up at 3AM (maybe she is 😉 :

Susan in GMT -8 needs more sleep ;-)

With Wayne in Sydney, Australia (GMT +10), it’s even more noticeable with the time difference:

Wayne GMT +10 doesn't get enough sleep either

So, if I look at the chart, before I even try to send Wayne an email, I know that if it’s before lunch time for me, he’s probably asleep down under.

And resource-wise, I’ve been pretty happy w/ Xobni:
image

Right now Xobni is a closed-beta, but I’ve got some invites left. If you’re interested, log a reply to this post.

And if you’d like a bit deeper look at Xobni, here’s a link to a video tour:
http://www.xobni.com/learnmore/

UPDATE – I found out Wayne already blogged about this, but my post is prettier and I’ve already typed it all, so I’m posting it anyway 😉

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)

Office 2007 SP1 Hits the Web Next Tuesday

microsoft-office-logo Less than a year after the official launch of the 2007 Office System, Microsoft announced on a TechNet blog that Service Pack 1 for Office 2007 will hit the web on 12/11/2007 (Patch Tuesday for December 2007).

“Will it come down the pipe automatically”, you ask?

“The 2007 Office System SP1 will be critical service pack for a variety of reasons.  It will eliminate many deployment barriers to deployment you may have in your environment, it will provide support for Windows Server 2008, and will provide critical fixes to products such as Project and Project Server.

The use of Automatic Update (AU) Deployment has been a concern we have heard from many customers in recent months.  Because of this, the 2007 Office System SP1 will not be released to AU immediately.   Instead, the Microsoft Office System team will provide guidance as to a date at which we will begin throttling up so that you have time to educate yourself on what is in SP1 and determine the best method for you to deploy it in your environment. ”

That is all.

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)

Download – Office Mobile 6.1 Misadventures

Chris, scooped me on this today, but my post has became a tragedy involving crushed hopes and dreams for mo-bettah Office 2007 love on my WM5 PPC. I hope you fare better and have a smooth upgrade.  Me? Notsomuch.

Title: Microsoft Office Mobile 6.1
Subtitle: Upgrade for Microsoft Office 2007 file formats
File Name: OfficeMobile_Licensed_0409_US.msi
Version: 6.1
Date Published: 11/28/2007
Language: English
Download Size: 12.7 MB
Download URL: Click here or here

Description:
Office Mobile 6.1 is an upgrade to Office Mobile applications on Windows Mobile. The new upgrade supports the new Office 2007 file formats. It’s a free download, but see * note below.

Requirements:

  • WM Operating Systems: Windows Mobile 5.0, Windows Mobile 6
  • ActiveSync 4.5 (on Windows 2000/XP/2003); Windows Mobile Device Center (on Windows Vista)
  • At least 6 MB of Available Storage on your device or storage card
  • *Note: This free upgrade works only for WM5 and WM6 devices that have an earlier version of Office Mobile. If your PocketPC, Smartphone or Windows Mobile powered device does not have Office Mobile applications, this upgrade will not work for you.

    That said, you can purchase the full version of Office Mobile 6.1 online for $49.95 at Handango.

Installation Instructions:
(Your mileage may vary – if you’re thinking about upgrading a device that isn’t new, read on.)

  1. Download the file and save it to your computer.
     
  2. Connect your device to your computer and make sure ActiveSync 4.5 or Windows Mobile Device Center is running.
     
    image
  3. Double-click the OfficeMobile_Licensed_0409_US.msi, choose Run, then click Next.
     
    image
     
  4. Accept the license agreement, click Next.
     
  5. Then watch the installation puke out if your device is too old (like mine).
     
    image
     

Error message: Office Mobile 6.1 is not compatible with Windows Mobile 5.0 powered devices running builds earlier than 14847.

To check the build number of your Windows Mobile powered device, go to Settings, click System, and then click About.

MISSION STATUS

you_fail

hx2795_large DENIAL
OK, so I didn’t think this device was that old. I got it last year. It’s an iPAQ hx2795, it’s got a fingerprint reader, bluetooth, wifi, rubberized kung foo grip on the sides, 4GB SD card in the slot and 2 more in holster loaded w/ multimedia goodies. It’s plenty fast enough. And it’s been great for lots of stuff, like:

  • Watching ‘Tommy Boy’ on a plane while the 3 year old in 16F kicks the back of my seat from Detroit to Seattle. 
  • It kept me sane through a 2-hour queue (thank you United Airlines Customer Disservice counter) and a 12-hour flight delay (thank you O’Hare) which turned into a canceled ticket & a 3-hour bus ride.
    Benchwarmers, Monty Python’s Holy Grail & Chicken Little saw me through.
  • A 6-hour flight delay (thank you Cleveland). Oh, and will somebody please buy CLE a mop?! I’ve seen cleaner busses (see above).
    Fantastic 4, Hitchhiker’s Guide to Galaxy & Ice Age, I owe you.
  • Louisville (SDF), you have your very own SD card, so I won’t even go there.
  • In short, I LOVE my Pocket PC. For work, for movies, for MP3, for Tetris, for Daily Text & BubbleBreaker. 

BARGAINING
Please don’t be too old!  You’re not even 2 yet!  I’ll buy you an 8 GB SD card, OK??  I check System / Settings / About / and sure enough, Build 14366.1.0.1.  Gaaa! 

ANGER
Weezer sang it best: “Say It Ain’t So” (musical interlude while I chill)

 

ACCEPTANCE
Calmer now, I’m digging into this.  Found the update page for the hx2000 series on HP’s site. Downloaded the BIOS update, tried to flash the BIOS…

….and I bricked it.  Sour times.

MIXED PANIC & BLINDING ANGER
Vista WMDC tanked in the middle of the BIOS flash.  I jumped back over to Chris on IM (he’s been providing moral support throughout this ‘upgrade’).
HFB asked if I followed the Robot Horde’s Best Practice to Applying ROM Updates to Windows Mobile Devices. I didn’t do the 3rd party backup, but did everything else right. Per Chris:

USE WINDOWS XP/ACTIVESYNC TO LOAD ANY AND ALL ROM UPDATES, AS VISTS/WMDC SUCKS

Duly noted. My gift to you, gentle reader.

HOPE
An internet search brought up the following method to un-brick an iPAQ:
http://mobilitytoday.com/forum/showthread.php?t=7567

If a user is attempting to update the BIOS or FIRMWARE of their iPAQ and the power goes out, or they accidentally turn-off their iPAQ, when then attempt to restart the iPAQ, it will only get to a white-screen, where it then sits forever.
Both soft and hard-resets do not appear to clear the trouble in most cases.

Hopefully you will never need to use this step-by-step process.
I have confirmed with Nathan at HP Technical Support that this is their approved recovery process:

1.) Go to the Master Index of BIOS, FIRMWARE, & DRIVER Updates,
2.) Select the appropriate hyperlink for your model.
3.) Download the most recent BIOS version SoftPAQ (SP) for your Model of iPAQ.
4.) Press the POWER + iTASK + CONTACTS + RESET buttons at the same time so as to enter the FLASH Mode
5.) Make sure your USB connection to the Cradle is hooked-up.
6.) Place your iPAQ in the USB Cradle.
7.) Stop the MS ActiveSync session on your HOST PC: CTRL-ALT-DELETE > TASK MANAGER > PROCESSES.
8.) Hilight WESCOMM.EXE and select “End Process” button.
9.) Run the file you downloaded from HP in step 3.
10.) The iPAQ should now begin Flashing the iPAQ’s ROM BIOS.

This should work for most every iPAQ model, however, we cannot guarantee this will succeed at restoring your iPAQ to a usable state.

PROGRESS
After the near-impossible iPAQ 4-finger salute & some fiddling… cowbell!

image

…and there was much rejoicing!  🙂

To repeat a quote I heard at SMB Nation two years ago, “All I know about the bleeding edge is – that’s where people bleed.”  It might have been Erik Simpson, can’t remember really. But it hits home tonight.

STUPIDITY
And because I never learn my lesson, I’m going to try again this weekend (only from an XP machine this time).  Because I’m nothing if not persistent. Woo-hoo!!

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)

Error – This File Must Be Converted with BinHex 4.0

From the Help Desk file…

Reported issue: Client can’t open an email attachment.
Attachment name: MessedUp.xls (file name changed for jocularity)
Details: When you try to open the attachment, Excel pops up the error message:

“The file you are trying to open, ‘MessedUp.xls’, is in a different format than specified by the extension.  Verify that the file is not corrupted and is from a trusted source before opening the file.  Do you want to open the file now?”

image

If you click “Yes” the file opens in Microsoft Excel (or Word, depending on the file extension).

The results of blindly clicking “Yes” and just plowing forward are so confusing that even Beck couldn’t make sense out of these lyrics.

In Excel, cell A1 says:

“(This file must be converted with BinHex 4.0)”

Microsoft Excel (That ain’t no spreadsheet, bro)

(This file must be converted with BinHex 4.0)

Microsoft Word (similar dreck)

image

Notepad (slight exaggeration)

matrix

What are we looking at? This is a compressed document, but in a format most folks (especially PC users) aren’t familiar with. If you Google BinHex or the error message “This file must be converted with BinHex 4.0” you’ll find everything from sites talking about TRS-80 computers to Macs.  Most of the links are dead-ends and offer no satisfaction regarding how to turn this file from garbage back into usable data. Hope, that you can easily cope with a conversion like word 2 pdf yourself.

Solution: You need StuffIt Expander to expand the file.

  1. Download & install StuffIt Expander (16.7 MB)
    http://www.stuffit.com/win/expander/index.html
  2. Save your attached ‘MessedUp.xls’ document to your hard drive
  3. Rename it ‘MessedUp.bin’, and choose ‘Yes’ when asked if you’re sure you want to rename the file extension.
  4. Double-click your ‘MessedUp.bin’ file, it should now open in StuffIt.
  5. Click the “Expand” button (shown in the picture).image
  6. Select where you’d like your expanded file to be saved, and click OK.
  7. You should now have a sufficiently un-rubbled .XLS spreadsheet or .DOC document.  You can delete the original ‘MessedUp.bin’ file.  Grab that cup of Joe and take a victory-sip!

image

Postmortem: Why does this happen? In this particular instance, the file attachment was sent by a Mac user to a Windows PC user.  It’s not entirely clear if the renaming of the file extension was intentional or an accident, but the end result is similar to the AOL MIME email attachments back before Y2K (those were heady days 😉

Best Practice: If you’re sending an email attachment to someone on a different platform, you may avoid some headaches by just zipping the attachment instead of dragging it in the native format into your email client.

VN:F [1.9.20_1166]
Rating: 5.5/10 (4 votes cast)

Live Event – IW Services Opportunities in 2007

It’s almost time to get your ‘Information Worker’ learn on.  If you live in the ‘Heartland District‘ this Microsoft Partner-Only event is headed your way from March 26 – April 19, 2007.  

The content is broken into two sessions: Sales & Technical (dates & registration links are below.)

Sales Session Overview (2 hours):
Lunch and Learn presentation to partner sales reps on how to sell Information Worker (IW) solutions and services. Session will include resources, demos and sales tools.

Sales Session Agenda:

  • 11:00 am – Welcome and Sales Strategy Overview
  • 11:15 am – Overview of 2007 edition of Office System
  • 11:45 am – Luncheon Presentation
  • Selling Workflow & Forms Solutions
  • Selling Document Security
  • Selling Content and Document Management
  • Selling Real Time Communication
  • 12:45 pm – Tools and Resources to Help You Sell
  • 12:55 pm – Evaluations & Prize Giveaways
  • 1:00 pm – Sales Session Concludes


Technical Session Overview (3 hours):

Deep technical presentation to partner technical leads and personnel on how to position and implement Information Worker solutions in your customers accounts. Session will include resources, demos and additional training tools.

Technical Session Agenda:

  • 2:00 pm – Welcome and Overview of 2007 edition of Office System
  • 2:30 pm – Building Custom Workflow Solutions
  • Document Workflow
  • Integrating into LOB Apps and Scripts
  • 3:30 pm – Implementing Robust Content and Document Management Solutions
  • Migrating and Replacing File Folders
  • Implementing Company Wide Search
  • Setting Content Management Policies
  • 4:30 pm – Tools and Resources to Help You Deliver
  • 4:45 pm – Evaluations & Prize Giveaways
  • 5:00 pm – Technical Session Concludes


Locations & Registration Links:

· Southfield 3/26 – http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032332362&Culture=en-US

· Grand Rapids – 3/28 – http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032332351&Culture=en-US

· Nashville – 4/3 – http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032332403&Culture=en-US

· Mason (Cincinnati) 4/11 – http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032332366&Culture=en-US

· Cleveland 4/16 – http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032332364&Culture=en-US

· Columbus 4/17 – http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032332367&Culture=en-US

· Louisville 4/19 – http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032332365&Culture=en-US

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)

January 2007 Action Pack Update

Update kits for the January 2007 Microsoft Action Pack Subscription (MAPS) are scheduled to start shipping today (01/19/2007).  You should see yours before Jan 30.

Here’s what’s NEW in the Action Pack* this month:

(10 Licenses of each above, except for Sharepoint Server Enterprise)

And of course, we all know what’s MISSING IN ACTION:

  • Microsoft Office 2003 (all flavors) – shot down
  • Microsoft Windows XP Pro (full & upgrade) – shot down
  • Microsoft Exchange Server 2007 – MIA

I’ll spare everyone a rehash of the Windows XP & Office 2003 Action Pack removal flame war – Eric Ligman’s blog has the official word on that.  But, this interesting little tidbit may have slipped under your radar:

“The Original Equipment Manufacturer (OEM) Version Software Software Offer in the Action Pack has Expired. The Microsoft OEM version software for internal use offer in the Microsoft Action Pack Subscription expired on December 31, 2006. Software for internal use is still available via the volume licensing offering included with your Action Pack Subscription. “

(Insert blank stare here…)

Source:   Microsoft Partner Website

*North American version of the Microsoft Action Pack Subscription

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)