Resend Email in Outlook 2003, 2007, 2010


Ever run into the situation where you had sent an email to someone, but they didn’t get it? Or maybe you sent an email a few weeks back to someone, but they deleted it and now they want you to send it to them again.

Firstly, before you can send the email to someone again, you have to find it in your Sent Items box. Once you have found the email you want to resend, you can always forward the message to the person. I personally don’t like that method because you have to retype the persons email address and the it has the added forwarded section at the top of the email.

Luckily, there are a couple of better ways to resend email in Outlook. Outlook has a feature where you can resend a message in its original format and to the original recipients.

You can do this by find the sent message in the Sent Items folder and opening the email.

In Outlook 2003, click on the Actions menu item and choose Resend This Message.

resend email outlook

That’s it! That will send the original message again to the recipients. If you have Outlook 2007, you have to click on the Other Actions button, which is on the Message tab of the Ribbon. There you will see the Resend This Message option.

resend message outlook

If you are running Outlook 2010, it’s slightly different! When you open the message in Outlook 2010, go ahead and click the round Office button at the top left.

outlook resend messge

Click on the Info tab and you will see a heading called Message Resend and Recall. Click on the button and you will see an option to Recall this message or Resend this message.

So there you have it! Three different ways to resend an email or message in three different versions of Outlook! Gotta love Microsoft! Enjoy!

Posted in office. 2 Comments »

How to Repair Corrupted Excel Files


Excel is probably just as important to most workers as wearing clothes and eating food. I pretty much use Excel on a daily basis to do everything from managing finances to analyzing customer data. It’s so powerful, it’s hard to imagine life without Excel.

And that’s exactly why it can be so terrible when you end up with a damaged or corrupt Excel file! All of that work and it might be lost forever, unless you were smart enough to make a backup.

Luckily, most corrupted Excel files can be recovered, you just have to try out a lot of different ways. If your Excel file is corrupted, below are some ways you can hopefully repair the file or at least get some of the data back.

Method 1 – Run Repair

The first thing to try is to open it with the Repair option in Excel. You can do this by clicking on File and then Open. In the Open dialog box, single click on the Excel file and then click on the small arrow next to the Open button.

repair corrupt excel file

Go ahead and click on Open and Repair and you’ll get a message asking if you want to repair, which will recover as much data as possible or if you simply want to extract data, which will copy out the formulas and values.

excel open and repair

You can try to repair first and see if it can recover the whole file, if not, you can then try to extract the data.

Method 2 – Save File To Different Format

If you are able to open the file in Excel, you can try to save the file out into different formats and then re-open them in Excel and try to save them back as Excel workbooks.

Click on File and then Save As. Choose SYLK (Symbolic Link) from the Save as type list and click Save. Then close the workbook.

excel corrupt file

Next, click File and Open again, but this time choose the SYLK file. You may have to choose All Files from the Files of type list to see the SYLK file.

Once the file is open, click File and then Save As. Now you will choose Microsoft Excel Workbook and click Save. Note that saving using the SYLK format only saves the active worksheet. You will have to save each worksheet individually and repeat this procedure.

Along with the SLYK format, you can also save the file out using the HTML format. Once saved out, re-open it and try to save it as an Excel workbook. With the HTML format, you don’t need to save each worksheet individually.

Method 3 – Change Recalculation Option

If you can’t open the file at all, you can try a couple of more things. Firstly, try setting the recalculation option in Excel to manual. You can do this by going to Tools, Options and clicking on the Calculation tab. In the Calculation section, go ahead and choose Manual.

If you are using Excel 2007 or higher, the procedure is different. You have to click on the Office button at the top left, then choose Excel Options.

recover excel corrupt

Click on Formulas and then click on Manual under the Calculation options section.

excel calculation manual

Now try to open the corrupted Excel file and see if it opens. If not, keep reading!

Method 4 – Open in Word or WordPad

You can also try opening the damaged Excel file in Microsoft Word or WordPad. In order to do so, you first have to make sure you have the Microsoft Excel Converter installed. You can download it from the Microsoft website.

Even though you might be able to open the files, you will lost chart sheets, dialog sheets, macro sheets, and you will lose all cell formulas. However, you should be able to view the data.

If you have macros, try opening the file in WordPad as the Visual Basic code in your modules might show up. You will have to perform a search for “Function” or “Sub”.

Method 5 – Link to Corrupted File

In Excel, you can link to other Excel workbooks from within a worksheet. You can try to use this method to extract data from a corrupted Excel workbook.

Click File then Open and navigate to the folder that contains the corrupted file. Then click Cancel. Now go ahead and click File and then New and click OK.

In cell A1, type =FileName!A1 and press Enter.

corrupt excel file

If everything goes well, you should see the data from cell A1 of the corrupt worksheet appear in cell A1 of your new workbook.

excel corrupt data

If so, now you can simply drag the corner of the box and expand the selection out to however many rows and columns existed in the corrupt workbook.

recover excel data

Method 6 – Use Excel Viewer

You can also try to download Microsoft Excel Viewer, which may be able to open the file for you. All it lets you do is copy the cells and paste them into a new workbook, but it’s better than nothing.

Method 7 – Use Later Excel Versions

If the corrupted Excel file was created in Excel XP, Excel 2003, etc, try opening it in a later version like Excel 2007 or Excel 2010.

As the versions increase, the ability for the program to recover a file increases also, so you might get lucky and be able to recover your file.

Method 8 – Delete Temp Folder

At this point we’re hoping and praying, but it’s worth a shot. You can delete the contents of the C:\Windows\Temp directory and then restart your computer. Try opening the file again.

If you still can’t open your Excel file, post a comment here and I’ll try to help!

Use Command Line Switches in Outlook 2010


By default, running Outlook.exe will launch the program and start it normally in Windows. This is what occurs when you click on the Outlook desktop icon. However, there are many times where it would be useful to alter the startup of Outlook 2010 by adding a command line switch.

Instead of running outlook.exe, you can add a switch such as shown below:

outlook.exe /safe

This will launch Outlook without the Reading Pane or any toolbar customizations and will turn off any COM add-ins. A helpful command if Outlook is crashing because of a recently installed add-in.

You can run Outlook 2010 with a command line switch in one of two ways: using the Run command and creating a shortcut.

Run Command

In Windows Vista and Windows 7, click on Start, and then type Run into the Search box. Press Enter and the Run dialog box will appear.

Enter the full path to the Outlook.exe file and include the path in quotes. After the quotes, you can type in the command line switch as shown below:

“c:\program files\microsoft office\office14\outlook.exe” /safe

outlook 2010 command line switch

Windows Shortcut

If you want a more permanent solution, you could create a shortcut to the modified Outlook startup. Simply follow the first few steps of this previous article and type in the above mentioned path (including the quotes)where it says “Type the location of the item”.

http://helpdeskgeek.com/windows-7/command-prompt-admin-rights-windows-7/

Basically, you right-click on the Desktop and choose Create Shortcut Wizard. After that, you just give it a path and a name and you’re done.

Outlook 2010 Command Line Switches

Below are some of my favorite command line switches that I have used in an IT environment.

/a – Create a message with a specified file as an attachment, i.e. “c:\program files\microsoft office\office14\outlook.exe” /a “c:\my documents\test.doc”

/c messageclass – Creates a new item with a specific type of message class. Examples include:

  • /c ipm.appointment creates an appointment
  • /c ipm.contact creates a contact
  • /c ipm.note creates an e-mail message
  • /c ipm.task creates a task

/cleanautocompletecache – Removes everything, including names and email addresses, from the auto-complete list.

/cleanrules – Deletes all client and server based rules on Outlook startup.

/cleansharing– Useful if you cannot delete a RSS subscription from Outlook 2010. This will remove all RSS, Sharepoint, and Internet Calendar subscriptions from your account settings.

/nopreview – Starts Outlook 2010 with the Reading Pane turned off.

/safe – Starts Outlook without Reading Pane, Toolbar Customizations, and COM add-ins.

There are many more command line switches and you can read about the rest on the Office website:

http://office.microsoft.com/en-us/outlook-help/command-line-switches-for-outlook-2010-HP010354956.aspx

If you need some help in using one of the switches, post a comment here and I will try to help! Enjoy!

Converting Outlook Express .DBX files for use with Outlook 2007


Back in October 2007 I struggled with converting a user’s email from Outlook Express (OE) to Outlook. My problem was I neglected to export her OE email prior to joining her computer to the new Windows domain. I figured out a solution in the end, after hours of work.

Life would have been so much simpler if I had know about the DBXconv program, which I found via Claus’s Grand Stream Dreams. DBXconv is freeware that extracts messages from OE5 and OE6 mailboxes into various formats.

As a test I downloaded DBXconv and saved it into a directory with a copy of my OE mailbox files. I ran the following command to extract the messages into .eml format.

dbxconv -eml *.dbx

The utility quickly created a folder for each of my .dbx files and created an .eml file for each of my messages. I was then able to import the files into Outlook 2007 by:

1) Dragging the .eml files into Windows Mail

2) Exporting the messages from Windows Mail

3) In Outlook 2007, Selecting File – Import and Export – Import Internet Mail and Addresses

4) Select Outlook Express 4.x, 5.x, 6.x or Windows Mail

5) Check the Import Mail and Import Address book boxes and press Next

6) In the Import Addresses window you can set how you want duplicates to be handled – Select the option and click Finish

Howto: Fix the Outlook 2007 Double Spacing Problem


I use Outlook 2007 and have experienced crazy formatting problems under certain circumstances that are not always reproducible. Here’s what I did to fix the problem:

  1. Close both Outlook and Word if they are running
  2. Browse to my C:\Documents and Settings\User\Application Data\Microsoft\Templates directory and rename the normal.dotm and normalemail.dotm files. These files will be automatically recreated the next time you launch Outlook. Note that renaming these files may cause you to lose signatures and other custom settings.
  3. Launch Outlook, then close Outlook. This will cause your normalemail.dotm file to be recreated.
  4. Launch Word, then close Word. This will cause your normal.dotm file to be recreated.
  5. Recreate your signatures if needed.
  6. Repeat this process for any other user profiles you may have.

I’m sure there is a more elegant way to fix this problem, but I’ve tried modifying everything I could think of inside both Outlook and Word – styles, formatting, stationary, Outlook templates, etc.

Posted in howto, office. Tags: , . 23 Comments »

Problems opening Outlook attachments with Google Desktop Search installed


I haven’t run across this particular problem personally, but I thought I’d post it since I wasn’t able to find it documented anywhere else except on MSOutlook.info and in a few newsgroups.

It appears that the problem with opening Outlook attachments is due to a bug in Google Desktop Search (GDS) version 5.5.0709.30344 released on October 2, 2007. It was fixed in version 5.6.0711.24354 released on December 6, 2007.

Uninstalling the old GDS and installing the updated version fixes the problem. You can also try the following, which I found in a newsgroup:

“After performing the following steps, I was able to open attachments
in Outlook without completely uninstalling Google Desktop:

– In Outlook 2007, go to “Tools” > “Trust Center”
– Click “Add-ins” on the left-hand side of the resulting window
– In the lower part of the window, change “Manage: COM Add-ins” to
“Manage: Exchange Client Extensions”
– Click “Go…”
– Uncheck the “Google Desktop Search Outlook Add-in” then click “OK”

This leaves the Google Search Outlook toolbar available, so you can
continue to use it to search for messages. The only downside is new
messages won’t be indexed until you turn this add-in back on. So I
just temporarily disable it on the rare occasions when I have to open
a forwarded message.”

64-bit Windows isn’t displaying files saved in the Office 2007 format when searching for Documents


Brandon has posted the answer to a question that has been driving me mad… why my Office 2007 files, saved in their native formats (.docx, .xlsx, etc) are not displayed when I search for files of type “Document” from my Windows Vista machine.

It appears that the issue is with where 64-bit versions of Windows (XP/2003/Vista) look for information. Brandon goes on to explain:

“This is a known issue with the 64-bit property system, and happens because the 64-bit shell only looks in the 64-bit section of the registry for a set of keys that map file extensions to various “kinds” for filetypes that don’t emit their own “kind” information. Because Office 2007 is a 32-bit application, it registers its kinds in the 32-bit section of the registry, where the shell never sees it.”

Brandon has been kind enough to post a .reg file that will import the Office 2007 file formats into the 64-bit section of the registry, thus allowing these documents to be found.