PST Repair for Outlook 2003/2007

PST repair in Outlook 2003.
The PST repair tool can be found on C:\Program Files\Common Files\system\MSMAPI\1003\
This tool is used if the pst file is corrupted or to fix a pst file size after deleting emails from your outlook. Sometimes even after deleting files/ email from your outlook the size of the pst stay the same. So in that case run the scanpst.exe tool and scan the pst files.

Change the temporary folder for Outlook 2003, which is used to save attachments

Outlook 2003 If you are using Outlook 2003, follow these steps: Create a folder under your profile and name it temp, then change the registry settings for Outlook to point the temp files to this folder Click Start, click Run, type regedit, and then click OK. Locate and then click the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\Security\ In the right pane, double-click OutlookSecureTempFolder. In the Value Data field, type C:\users\username\temp\ and then click OK. Exit Registry Editor, restart the computer. http://support.microsoft.com/kb/305982

How To Empty the Clipboard memory in Windows 7

When ever you copy/ cut a word from a document its stored in the clipboard of the windows xp/7. After some times when the memory is full you cannot copy anymore. You will have to clear the items from the clipboard. To clear use the following command.

Also you can create a shotcut of the command

How to Change the Default fonts on Outlook 2003

Go to Tools->Options on your Outlook 2003/2007. There you will see the Mail Format Tab, under that open Fonts, there you have options to change the fonts. Once you changed the fonts please close and open the outlook.

How to Copy the Autocomplete Information to a New Outlook Profile

In Outlook 2010 the best solution is to keep the same name(profile name) on the new computer. Once you keep the same name the auto complete will transfer by itself if you copy the "username.pst" file from the old computer(located c:\users\name of the user\documents\Outlook files) to the new.
But in older versions of Outlook(2003/ 2007). there is a file named "Outlook.NK2" under the user profile
In windows 7 (C:\Users\username\AppData\Roaming\Microsoft\Outlook\Outlook.NK2 or %APPDATA%\Microsoft\Outlook )
In Windows XP (C:\Documents and Settings\username\Application Data\Microsoft\Outlook\Outlook.NK2) copy this file to the new profile.

 Import the Auto-Complete List

You are now ready to start Outlook and import the file, but you must start Outlook with a special one-time command.

Do one of the following:

• Windows 7    Click Start {picture}. Next to the Shut down button, in the Search programs and files box, type outlook /importnk2 and then press Enter.
• Windows Vista    Click Start {picture}. Next to the Shut Down button, in the Search box, type outlook /importnk2 and then press Enter.
• Windows XP    Click Start {picture}, click Run, type outlook /importnk2 and then press Enter.

If you want to export the .NK2 files into contact use the software from Nirsoft
http://www.nirsoft.net/utils/outlook_nk2_edit.html

RPC over HTTP outlook 2003 to save password

http://support.microsoft.com/default.aspx?scid=kb;en-us;820281

Basic authentication
If you want to use Basic authentication, you must continue to type your user account credentials. There is no way for the client to submit your user name and password automatically. If you want to log on automatically, you must configure your Outlook profile to use NLTM authentication to your proxy server for Exchange.

Before you switch to using NTLM authentication, you must verify with your administrator that NTLM authentication is permitted or even possible in your environment. Many firewalls and proxy servers will prevent successful NLTM authentication, whereas Basic authentication will work successfully. See the More Information section for additional details.

Note The authentication mechanism that you configure in Outlook is used only for the HTTP session to your proxy server for Exchange. The actual authentication between Outlook and your Exchange server always uses NTLM. See the More Information section for additional details.

To change the authentication mechanism on the Outlook client to NTLM, follow these steps:
Start Outlook 2003.
On the Tools menu, click E-mail Accounts.
Click View or change existing e-mail accounts, and then click Next.
Under Outlook processes e-mail for these accounts in the following order, click Microsoft Exchange Server, and then click Change.
On the Exchange Server Settings page, click More Settings.
Click the Connection tab.
Click Exchange Proxy Settings.
Under Proxy authentication settings, click NTLM Authentication in the Use this authentication when connecting to my proxy server for Exchange list.
Click OK two times.
Click OK again in response to the prompt that you must restart Outlook for the changes to take effect.
Click Next, and then click Finish.
Restart Outlook.
NTLM authentication
If your account is configured to use NTLM authentication and you are still prompted for your user name and password when you are logged on as the Windows account that has access to your Exchange mailbox, you must set the LmCompatibilityLevel on your client to a value of 2 or 3. To do this, follow these steps.

Click Start, click Run, type regedit in the Open box, and then press ENTER.
Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\
In the right pane, double-click lmcompatibilitylevel.
In the Value data box, type a value of 2 or 3 that is appropriate for your environment, and then click OK.
Quit Registry Editor.
Restart your computer.

To Add new folder/unread mail folder to the Favorite Folders list In MS Outlook 2007

Right click on the Search folders, New Search Folder..

Select Unread Mail from the list, click OK.

Move the Unread Mail to the favorite folder list.

Excel: Unable to open files by double-clicking

Cannot open excel file directly
Suddenly can't open Excel files from "My Computer/My Docum.
Excel: Unable to open files by double-clicking

Open the excel application go to

Tools|Options|General|Ignore other applications (uncheck it)

How to encrypt, password protect and lock files in Excel 2007?

You can easily encrypt, password protect files and thereby lock files created using Microsoft office Excel 2007.

How to password protect files in Excel 2007?

Open the excel 2007 file to encrypt, password protect and lock
Click on the office Orb on the top left
Select Prepare >> Encrypt document

An Encrypt document dialog box pops up with an option for you to set password
Enter a strong password and click Ok
A confirm password dialog box pops up with an option for you to re-enter password and confirm it
If you are done with your work on the excel 2007 file, save your excel file.

Scroll Bar Missing in MS Word

In Office 2003
Go to Tools>Options>View

Under Show Check the vertical and Horizontal bars

How to password protect or encrypt Excel spreadsheets

How to set spreadsheet security in Excel 2002/2003

There is not something like an "encryption button" in Excel. On the other hand, encrypting Excel spreadsheets is just a few clicks away.
route 1: Tools | Options | Tab Security

route 2: File | Save As | Tools | General Options | Tab Security

File encryption options in Excel via the 'Save As' Menu

Security settings in Excel 2002/2003

The Security tab shows different security settings:
Open password
This password is used for spreadsheet encryption. This security feature is discussed in the next paragraph.
Modify password
This password is used for convenience when sharing spreadsheets. This password does *not* encrypt the spreadsheet and therefore does not add security. This modify password opens the Excel spreadsheet in an editable modus but prevents the original file from being overwritten. The modify password is stored within the Excel spreadsheet. There are tools available that can extract and remove this modify password.
Read-only recommended
This is a recommendation to the person opening the spreadsheet. On opening, Excel asks the user to choose read-only unless the user thinks that changes to the spreadsheet are necessary. It's just a recommendation, no security.

Outlook 2010 Read Receipt Email Tracking

After sending the email, sometime it becomes a frantic need to know when the recipient will start reading it, Outlook has an intrinsic feature which lets you know immediately when the person starts reading your message. By using Tracking, you can track down the email. This post elaborates how you can enable this feature.

Launch Outlook 2010, and from Home tab, click New E-mail

Navigate to Options tab, and From Tracking pane enable Request a Read Receipt option, now click Send to send it to recipient.

RPC over HTTP settings on Outlook 2007

Go to Control Panel. Open the “Mail” in control panel.

Click on “E-mail Accounts…”

Click on “New..”

Select “Microsoft Exchange”

On Microsoft Exchange Server enter "your mail server name"
And on User Name enter “your username”., then click the “More Settings…”

Go to the “connection” tab on more settings. Check the “Connect to Microsoft exchange using HTTP” under “Outlook Anywhere”. Then click the “Exchange Proxy Settings..”

Enter “mail.domain.com” in the box https:// and change the “Proxy Authentication settings” to Basic Authentication. Click OK, Apply, and OK

Click OK, Next, Close and Open Outlook 2007 to synchronize with exchange

Load the Analysis Toolpak in Office 2003 Excel

Link: http://office.microsoft.com/en-us/excel/HP011277241033.aspx

The Analysis Toolpak is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first.

On the Tools menu, click Add-Ins.
In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.
Tip If Analysis Toolpak is not listed, click Browse to locate it.

If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it.
Click Tools on the menu bar. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu.
Note To include Visual Basis for Application (VBA) functions for the Analysis Toolpak, you can load the Analysis Toolpak - VBA Add-in the same way you load the Analysis Toolpak. In the Add-ins available box, select the check box next to Analysis Toolpak - VBA.

Print an e-mail message and attachment

Link: http://office.microsoft.com/en-ca/outlook/HP052431731033.aspx

Load the Analysis Toolpak in Office 2003 Excel

Link: http://office.microsoft.com/en-us/excel/HP011277241033.aspx

The Analysis Toolpak is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first.

On the Tools menu, click Add-Ins.
In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.
Tip If Analysis Toolpak is not listed, click Browse to locate it.

If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it.
Click Tools on the menu bar. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu.
Note To include Visual Basis for Application (VBA) functions for the Analysis Toolpak, you can load the Analysis Toolpak - VBA Add-in the same way you load the Analysis Toolpak. In the Add-ins available box, select the check box next to Analysis Toolpak - VBA.