The Burton Tech Journal

Microsoft Office

Locate large emails using PowerShell

by on Mar.05, 2014, under Microsoft Exchange, Microsoft Office 365

Run the following command from the Exchange Shell to locate large emails:

Get-MessageTrackingLog -Recipients [email protected] -Resultsize Unlimited | Where {$_.totalbytes -gt 24000000}| Select MessageSubject, TotalBytes | Export-Csv -Path "C:\Temp\LargeMails.csv"

Leave a Comment more...

Microsoft Office 2010 Professional Discount for Students

by on Aug.05, 2010, under Microsoft Office, Microsoft Office 2010

Anyone with a .EDU email address, such as students or alumni can now take advantage of student pricing for Office Professional Academic 2010! If you know anyone that is a student or has a .EDU email address, that can purchase the full Office 2010 suite for next to nothing! This includes Word 2010, Excel 2010, PowerPoint 2010, OneNote 2010, Publisher 2010, Outlook 2010, and Access 2010.

You can use the link below to register for Microsoft’s “Ultimate Steal” promotion or simply Google it to get the details.

Buy  Microsoft® Office Professional Academic 2010!

Leave a Comment more...

Microsoft Office 2010 Medialess License Key (MLK) Media Download

by on Aug.05, 2010, under Microsoft Office, Microsoft Office 2010

In previous versions of Microsoft Office MLK kits, OEM computer builders were able to purchase installation discs. At the time this post was published, Microsoft did not have those discs available for Office 2010 and most computer manufacturers were not distributing computers with Office 2010 pre-installed.

If you are an OEM or an IT professional that routinely uses MLK licenses for your customers, you can use the key from your MLK card and download the software media by using the links on this page:

If you do not have a key card to upgrade to Office 2010 Professional, they can be purchased from vendors like for much cheaper than retail stores:

Leave a Comment more...

Microsoft Software Discounts for Students

by on Dec.07, 2009, under Microsoft Office, Microsoft Operating Systems

Anyone that has an active email address ending in .EDU can purchase Microsoft Office 2007 Ultimate Edition and Windows 7 at dramatically discounted rates (click the link to order):

Microsoft is planning to expire this program soon so I would take advantage of the offer as soon as possible!

Leave a Comment :, , , , , , more...

Workaround for Errors When Opening Microsoft Office Files on WebDAV Drives

by on Dec.18, 2008, under JungleDisk, Microsoft Office 2003, Windows Vista

JungleDisk is a WebDAV file sharing service running on the Amazon Simple Storage Service (Amazon S3).  It appears when users are using Office 2003 SP3 on a Vista Business SP1 based system, they may not be able to open Microsoft Word and Excel files.  The users experience an error similar to:

Could not open ‘http://2667/somebucket/some file.doc’

The JungleDisk Support site (KBID#: 300065) indicates installing the Windows Software Update for Web Folders (KB907306) and rebooting will fix the problem.  Unfortunately the reported fix does not appear to work for numerous users.  Additionally, connecting to the JungleDisk “bucket” using the naive Windows WebDAV client does not allow saving due to the “read-only” bug.

We discovered the easiest way to work around the Vista/Office 2003 WebDAV limitations was to use a substitute drive.  Once the JungleDisk client loads and you can access the JungleDisk network drives, the following command can be use to connect:

subst NewDriveLetter: JungleDiskDriveLetter:\

For example, if the JungleDisk drive letter is “J:\”, you will run the following command to access the share:

subst k: j:\

You should then be able to open files from and save files to the “k:” drive directly.

When your system reboots, you will need to run the subst command again. For our users, we have created a batch file that deletes the virtual drive (subst k: /d) then re-creates it (subst k: j:\). After the user’s system has completely loaded, they double-click on the batch files to create accessible virtual drives.

Incidentally, upgrading to Office 2007 on Vista or running Office 2003 from Windows XP does not appear to have any issues.

Leave a Comment :, , , , , , , , , , , , , , , more...

Scan and Repair Outlook 2007 PST files

by on Dec.03, 2008, under Microsoft Outlook 2007

Inbox Repair tool

If you can’t open your Personal Folders file (.pst) or your Offline Folder file (.ost), or you suspect that your .pst or .ost data file is corrupted, you can use the Inbox Repair tool (Scanpst.exe) to diagnose and repair errors in the file. The Inbox Repair tool scans only the .pst or .ost file, not your mailbox on the server running Microsoft Exchange. The tool determines whether the file structure is intact. If it is not intact, the Inbox Repair tool resets your file structure and rebuilds the headers.

The Inbox Repair tool works on both the Microsoft Outlook 97-2002 Personal Folders File (.pst) and the Office Outlook Personal Folders File (.pst) data files in Microsoft Office Outlook 2003 and Microsoft Office Outlook 2007.

Scanpst.exe is installed when you install Outlook. It is located at:

drive:\Program Files\Microsoft Office\OFFICE12.

Repair errors by using Scanpst.exe

  1. Exit Outlook if it is running.
  2. Double-click Scanpst.exe, located at drive:\Program Files\Microsoft Office\OFFICE12.
  3. In the Enter the name of the file you want to scan box, enter the name of the .pst or .ost file that you want to check, or click Browse to search for the file.
  4. To specify the scan log options, click Options, and then click the option that you want.
  5. Click Start.
  6. If errors are found after the scan is complete, you will be prompted to start the repair process to fix the errors.A backup file is created during the repair process. To change the default name or location of this backup file, in the Enter name of backup file box, enter a new name, or click Browse to look for the file that you want to use.
  7. Click Repair.
  8. Start Outlook by using the profile that contains the .pst file that you tried to repair.
  9. On the Go menu, click Folder List.In the Folder List, you may see a folder named Recovered Personal Folders that contains your default Outlook folders or a Lost and Found folder. The recovered folders are usually empty, because this is a rebuilt .pst file. The Lost and Found folder contains the folders and items recovered by the Inbox Repair tool. Items that are missing from the Lost and Found folder cannot be repaired.
  10. If you see a Recovered Personal Folders folder, you can create a new .pst file, and drag the items in the Lost and Found folder into the new .pst file. When you have finished moving all the items, you can remove the Recovered Personal Folders (.pst) file, including the Lost and Found folder, from your profile.

OST files can be scanned using drive:\Program Files\Microsoft Office\OFFICE12\Scanost.exe.

For additional 3rd party repair tools, check out Slipstick System’s fantastic Outlook/Exchange website:


Leave a Comment :, , , , , , , more...

View Mail Headers in Outlook 2007

by on Nov.25, 2008, under Email, Microsoft Office, Microsoft Outlook 2007, Spam

Extracting an email header can be useful in tracking email issues, locating spammers, and reporting spam.

To view your header, do the following:

  1. Locate the message in your inbox and right-click on it.
  2. Select Message Options from the menu
  3. Copy the text in the Internet Headers window.  This will not include the email message, just the header.
  4. Paste the information into an email or document for analysis.  If you wish to paste the information into an email, you will need to close the options dialogue first.
Leave a Comment :, , , , , , , , more...

View Mail Headers in Outlook 97, Outlook 98, Outlook 2000, Outlook 2003

by on Nov.23, 2008, under Email, Microsoft Office, Microsoft Outlook 2003, Spam

Extracting an email header can be useful in tracking email issues, locating spammers, and reporting spam.  To find your email header, in Outlook versions 97 to 2003, you can use the following steps.  Please note, Microsoft Outlook 97 may require the Internet Mail Enhancement Patch to view any mail headers.

To view your header, do the following:

  1. Start Outlook
  2. Open the email message in a separate window by double clicking on the email in your Inbox
  3. In the new email window, click on the View menu and select Options
  4. Copy the text in the Internet Headers window.  This will not include the email message, just the header.
  5. Paste the information into an email or document for analysis.  If you wish to paste the information into an email, you may need to close the options dialogue first.
Leave a Comment :, , , , , , , , , , , more...

Duplicate Items in Exchange with at least one Entourage Client

by on Sep.15, 2008, under Microsoft Entourage 2008, Microsoft Exchange, Microsoft Office

A client of mine recently contacted me with a number of Exchange related problems.  Various company Executives were seeing duplicate and vanishing appointments in their Entourage Calendar.  Most of the company Execs were on Macs using Entourage 2008, while their assistants were using Outlook 2003/2007 on Windows based PC’s will full delegation rights.

After examining the Exchange entries, it appears the duplicates were being created solely by the Entourage clients.  Further examination of the Mac clients revealed that they also had the Sync Services Enabled for Entourage.

Entourage Preferences - Sync Services

By disabling the Sync Services for Entourage, it eliminated duplications from the corrupted truth database.  Unfortunately, some of the Execs wanted Entourage data to continue to sync with their .Mac accounts, despite the same information being available from any web browser via OWA.   This required fixing the somewhat buggy Sync Service.

The Sync Service works as an intermediate between your various applications/devices and the data they contain.  When an application like Entourage syncs with the Sync Service, the data is copied from Entourage to the truth database.  At that point, other applications like iCal further synchronize the data with the truth database.

iCal <–> Truth DB <–> Entourage <–> Exchange

For an excellent article on sync’ing, check out the Entourage Help Blog and “Why does syncing play Gossip with my contacts?“.

To fix the issues my clients were experiencing, I had to purge the corrupt truth database and re-sync using Entourage as the master database.  If you want to do something similar, follow these steps:

  1. Back up all iCal, Address Book, and Entourage Data.  If you fail to do this and make a mistake, you will lose data.
  2. Turn OFF the Sync Services for Entourage in the Entourage Preferences on ALL clients that connect to the Exchange server.
  3. Remove the duplicate items in Entourage using these tools.
  4. Delete duplicate iCal appointments using John Maisey’s iCal Dupe Deleter.
  5. WARNING: The remaining steps will delete data – Make sure you have a valid BACK UP before proceeding.
  6. Quit all Microsoft Office applications except Entourage
  7. In the Entourage menu select “Turn Off Office Reminders”
  8. Quit Entourage
  9. Start the “Activity Monitor”, select “database daemon”, and choose “Quit Process” from the Processes Menu (perform a Normal Quit, not a Force Quit)
  10. Quit iCal, Address Book, Safari, and any other applications that sync with a .Mac account
  11. Use Activity Monitor to quit the Sync Services
  12. Delete the contents of ~/Library/Application Support/SyncServices/
  13. Since Entourage is going to be the primary source of data, delete the iCal and Address Book data files:
    • Delete  ~/Application Support/iCal/*~/Application Support/AddressBook/*
    • Delete  ~/Library/Caches/*
    • Delete  ~/Library/Caches/*
  14. Open the .Mac applet via the System Preferences and Verify .Mac syncing is enabled
  15. Restart all applications that sync with .Mac (ie, iCal, Address Book, Safari, etc)
  16. Turn on the Sync Services in the Entourage Preferences
  17. When prompted with the “Replace, Replace, Merge” dialogue, since we select Entourage to be the primary source of data, make sure to choose “Replace Sync Services items with Entourage items”.

From what I have experienced, synchronizing an Exchange linked Entourage client with a .Mac is frequently problematic and I do not recommend it at the time this article was written.  If you must use this functionality, make sure to always make additions/changes/deletions from one machine and with a single application.  You should then give some time for synchronization to occur before using another machine/app.  As you can imagine, this can be an issue for users with delegates constantly changing Exchange data from another machine!

Leave a Comment :, , , , , , , , more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!


A few highly recommended websites...