Posted on Leave a comment

How to create Out Of Office reply without MS Exchange

If you don’t have an Exchange server you can create an auto-reply template:

  • Create an auto-reply email template and save it as an Outlook template

Save As folder

  • Create a message reply to send an automatic reply to your emails. In Tools | Rules and Alerts create a new rule (Start from a blank rule, click Check messages when they arrive)

Rules and Alerts

Check messages whe they arrive

  • In Which condition(s) do you want to check? window select the Sent Only To Me

sent only to me

  • In What do you want to do with the message? window select the Reply using a specific template check box. In the Select A Reply Template dialog box, click the email template that you created as auto-reply template.

Reply using a specific template

  • Click on the a specific template link to browse for the auto-reply email template. The template should be in the User Templates in File System from the Look In drop down box

Select a Reply Template

  • Name your rule and click the Finish button.

Turn on this rule

Please note that this rule will send the reply only one time to each sender (Outlook will save a list of email addresses it has responded to prevent sending repetitive replies, but if the Outlook is closed the list is deleted)

Posted on 1 Comment

Have replies sent to different email address

If you want to receive replies to your emails on a different email address then that from which you originally sent the email you can use the Direct Replies To option.

Create a new message and click the Options tab and then click the Direct Replies To option in the More Options section.


Under Delivery Options make sure that he Have Replies sent to check box is checked (it automatically checks when you type an email address) and specify the email address where to sent the replies to this email message.

Now the replies to this email messages will go to the specified email address.


Posted on 2 Comments

How to fix corrupted styles in Microsoft Word

Styles get corrupted when a document that was created in a newer version of Microsoft Word is edited in a older version. Basically the newer version brings in the style definitions (embedded in the file) that the old version doesn’t “understand” and cannot interpret.
To fix this problem go to Styles and Formatting pane and select Show: Custom; find all instances of the char style and delete them (one at a time)
Sometimes the files cannot be deleted and you can run a macro to remove them:

Sub DeleteChar()
    Dim style As, doc As Word.Document
    Set doc = ActiveDocument
    Set style = doc.Styles.Add(Name:=”replaced”)
    On Error Resume Next
    doc.Styles(“Name_of_the_Style”).LinkStyle = style
End Sub

Posted on 2 Comments

How to use Quick Parts in Microsoft Outlook

Outlook quick parts

Use Quick Parts to insert reusable piece of content or any preformatted snippets you create.
Simply highlight the entire block of text and images you want to add as Quick Parts. Now select the Insert tab and click on the Quick Parts button (which by default the list is empty). Click on the Save Selection to Quick Part Gallery…

In the Create New Building Block window type a name for this quick part, select the Gallery where to save it (you can add several galleries for different categories), and a description.

Click on the OK  button to add it to the gallery. If you click again on the Quick Parts button you will see it in the list.

Next time you need to use that block of text and image just select it from the Quick Parts list and it will be added in the email body.

Quick Parts is also available in Word

Posted on 1 Comment

How to change the default hyperlink font face/size in Excel

Microsoft Excel

I was having a problem with the cells containing hyperlinks –  the font was changing automatically into the default one (even though I have selected all cells and applied a different font).
In order to configure Excel to use the same font face/size as the one you selected for the entire sheet (or group of cells) you need to create a new default template that will load at startup. They didn’t make it easy to do in Office 2007! But here’s how:

  1. Open a new blank worksheet.
  2. Insert > Hyperlink > Paste in any link
  3. Home > Styles > Right click on the ‘Hyperlink style’ > Modify > Set your font options
  4. You probably will want to do the same for the ‘Followed Hyperlink’ style
  5. Delete the hyperlink.
  6. File > Save As > Other formats
  7. Browse to “%APPDATA%MicrosoftExcelXLSTART” (Copy/Paste that into the File name field and press Enter to get there easily)
  8. Save as type: Excel Template (.xltx)
  9. File name: Book.xltx

change hyperlink font in Excel


Now whenever you start Excel or create a new workbook, the hyperlink font should be the one you choose.
This Microsoft support article helped me: look here for where to save templates for Office 2003, or to see other ways of loading your template.


Posted on Leave a comment

How To View Two Parts of the Same Word Document in the Same Time

To view two parts of the same document, click on the View tab on the Word Ribbon and locate the section named Window and the click on the Split button.


Word will immediately place a grey line on the screen that you can move up and down with your mouse. This line is simply where you want the split to be on the screen. Just click the left mouse button where you want the initial split. You can move it anywhere to make one or the other split screens the size you want.

Windows Split

Notice that you now have two views of the same document. You can scroll each one independently of the other and see two places in your word document at the same time.


Each view of the document is treated like two separate documents even though you are viewing the same one. You can zoom, scroll, and even change the type of view (print, draft, outline, etc.) for each view individually. Any changes you make into one view will be made to the other view as well. You can edit the text in either view by simply clicking on it and typing.

Posted on Leave a comment

How to remove hidden metadata & elements from Word

Almost every Word document includes information such as hidden text, Object info, Personal Information, and other invisible info stored as metadata.

To remove this information, Word 2007 has a feature called  Inspect Document which lets user inspect for these hidden elements and to remove them. To do so, open the document which you want to thoroughly inspect for hidden elements. Click the Office Button and go to Prepare and select Inspect Document.



This will bring up Document Inspector dialog, listing all options for inspecting: Comments, Revisions, Version, Document Properties, Personal Info, XML Data, Headers, Footers, Watermarks, Invisible Content, and Hidden Text, etc.

Enable desired options available in the list and click Inspect.


It will start inspecting for specified elements. Once inspection is completed , you can remove the inspected elements from the document by clicking Remove All with each option you’ve selected.


If you click on Remove All, it will instantly remove all the specified elements from the document.

Now your document is safe, and you can start preparing it for generic distribution.


Posted on 1 Comment

How to change the default paragraph indentation in Word 2007

Someone asked on how to change the default paragraph indent:
The default amount of “increase indentation” whenever I highlight a few lines to indent is too big for me. I would like to halve that amount.
How do you set this? I don’t want to set this every time I indent.
Here is how you can do it, by changing the default template – Normal.dotm
1. Create a new document and open the Paragraph
2. In the Indentation section change the Left value to whatever value you like
3. Now save the document as Word Template
Save as Word Template
4. In the opened Save As window browse to %APPDATA%MicrosoftTemplates (or C:UsersNicuAppDataRoamingMicrosoftTemplates) and name your document Normal_New.dotm and click on the Save button.
5. Close Word and go to C:UsersNicuAppDataRoamingMicrosoftTemplates and rename existing Normal.dotm to Normal_Old.dotm (this is to keep a copy of your original template file). Select your newly created file (Normal_New.dotm) and rename it into Normal.dotm
Now the default paragraph indent will be used.