Tips

How to hide date and time when viewing notes in Outlook

October 12, 2014 By Ravi Shankar Leave a Comment

Microsoft Outlook notes displays the date and time at the bottom of the note. And outlook also provides option for displaying as well as hiding the date and time information.

Listed below are the steps to turn of display of date and time when viewing notes in Outlook 2013, Outlook 2010 and Outlook 2007.

Outlook 2013 and Outlook 2010

To turn off the display of date time in Outlook 2013, Outlook 2010 notes, Click on the File menu –> Options. Navigate to Notes and Journal tab and under Notes options

un tick the check box Show date and time that the Note was last modified. Click Ok to save this change. Now the notes will be displayed with out the last modified date and time as shown below.

Disable display of date and time in Outlook 2007 notes

In Outlook 2007, this option is available under Tools –> Options –> Other tab –> Advanced Options.

In Advanced Options window under Appearance options, a check box “When viewing Notes, show time and date” is available. By selecting this checkbox, the time and date will be displayed when viewing notes.

If the checkbox is unselected then time and date information will not be displayed when viewing the notes

Also See: How to change notes colour, size and font in Outlook

How to block emails from specific countries in Outlook 2013

October 12, 2014 By Ravi Shankar Leave a Comment

This tutorial is about the steps required to block emails from specific countries in Outlook 2013. The Junk email filter provides users with the option to add countries to the blocked email list. And any emails with email addresses originating from these countries will be blocked. For example, to block all emails originating from Russia (.ru) use following steps.

Step 1: Click Junk option under Outlook Home menu. Then select Junk E-mail Options from the drop down list.

Step 2: In the Junk Email Options window, navigate to the last tab International.

Step 3: Click the button with caption as “Blocked Top-Level Domain List”

Step 4: In the Blocked Top-Level Domain List, scroll down and select the country of interest i.e RU (Russia). Then click OK button to confirm and close the window.

Now all email messages from email address ending with .ru will be blocked in Outlook 2013.

Also See: Where is Junk Email Settings in Outlook

How to reduce size of document with images in Microsoft Word

October 12, 2014 By Ravi Shankar Leave a Comment

Microsoft Word provides users with the option to reduce the file size of the document with images. In this tutorial, we will see the technique of reducing the file size in Word 2013 and Word 2011 for Mac.

Reduce images size in Word 2013

Word 2013 users can use the Compress Pictures option available as part of Format Picture to compress the images in the document.

Step 1: Click the Format menu in Microsoft Word 2013. Please note the Format menu will be available only after selecting the image on the document.

Step 2: In the Format menu, navigate to Adjust section and click the Compress Pictures option. This should display the following Compress Pictures window.

Now you can choose the desired option under Compression options and Target Output. Let say you want to only share the document with other users using email, then go for “E-mail (96 ppi): minimize document size for sharing”.

Step 3: After selecting the required options, click Ok button to apply the changes to images.

Compress images in Word 2011 for Mac

Step 1: Select the image in the document and click Format Picture menu.

Step 2: Under Format Picture menu, click the Compress Option. This should display the following Reduce File Size screen.

Step 3: Now choose the Picture Quality drop down to apply appropriate picture quality as per your needs. You can apply the changes to all the pictures in the file or just Selected pictures

Step 4: Click OK button to apply the changes to the document.

UserForms in Word Macros and VBA

October 12, 2014 By Ravi Shankar Leave a Comment

We had earlier seen an example Macro for inserting date and time. We will use the same example but replace MsgBox with UserForms. The users will be displayed the following form and based on the user input the date and time will be inserted in the document.

Step 1: Insert a UserForm by right clicking the Project Navigator, Click Insert then UserForm.

The following UserForm along with the controls for designing form will be shown.

Step 2: Now drag and drop the required controls on to the form. This form will be presented to the user asking their choice on the date and time and the alignment.

The form contains two frames for grouping Date and Time and Alignment choices. The corresponding option controls for Date and Time and Alignment. Then OK button to apply the changes and Cancel button to close the form without applying the user choice.

Step 3: Make sure to change the caption for the controls and provide the Value as True for Date and Time and Right. This is to ensure than both the choices have default values. You can set these values using the properties window.

Step 4: Add the code for the action that should occur on clicking the OK and Cancel button. Double click on the Command button to add the code for respective command controls.

Code for OK Button

Private Sub CommandButton1_Click()

'Create a new document

Documents.Add DocumentType:=wdNewBlankDocument

'Insert date or date and time depending upon the user input.

If OptionButton1.Value = True Then

Selection.InsertDateTime DateTimeFormat:="dddd, MMMM d, y", InsertAsField _

:=True

Else

Selection.InsertDateTime DateTimeFormat:="M/d/yy h:mm:ss am/pm", _

InsertAsField:=True

End If

'Align date based on user's choice

If OptionButton3.Value = True Then

Selection.ParagraphFormat.Alignment = wdAlignParagraphLeft

ElseIf OptionButton4.Value = True Then

Selection.ParagraphFormat.Alignment = wdAlignParagraphRight

Else

Selection.ParagraphFormat.Alignment = wdAlignParagraphCenter

End If

'Revert the alignment to left.

Selection.TypeParagraph

Selection.ParagraphFormat.Alignment = wdAlignParagraphLeft

‘Hide the form.

UserForm1.Hide

End Sub

Code for Cancel Button

Private Sub CommandButton2_Click()

UserForm1.Hide

End Sub

Now trying running the form to see the UserForm in action.

Note :- Some improvements can be done to the above example like providing proper name to OptionButtons and CommandButtons.

How to use Goal Seek in Excel

October 12, 2014 By Ravi Shankar Leave a Comment

Microsoft Excel has a Goal Seek feature which can be used to derive value of a cell based on the result set for the cell containing a formula. Let us see this with an example that does a simple addition. In the below screenshot, you should notice that the sum of A3 to E3 is calculated in F3.

Now let us say that you want the final result in F3 as “350000” and this should be achieved by changing the value of C3. For this scenario we can use Goal Seek feature to find out the value to be entered in C3.

In Excel 2011 for Mac, Goal Seek can be accessed from Tools menu.

Enter the Set cell to the cell containing formula i.e F3

Then enter the final result that you need to arrive in “To value” field i.e 350000

Click Ok button after entering the cell that needs to be changed to get final result. The following Goal Seek Status screen will be displayed with “found a solution” message.

Though we have taken a simple problem do explain Goal Seek feature. This feature will be quite handy when you are working with complex formulas and want to try out different values.

Find out character count Microsoft Word document

September 11, 2014 By Ravi Shankar 3 Comments

Microsoft Word users can find out character count of a document using the option available as part of the Review menu.

Find out character and word count in Word 2013, Word 2010 and Word 2007

Click the review menu and navigate to Proofing section then click the Word Count option.

This should display the following Word Count Statistics along with Characters (no spaces) and Character (with spaces) details. If you are interested to find out only the Characters Count of certain paragraph then all you need to do is Select the Paragraph before clicking the Word Count option.

If you only want to see the number of words in the document then the quickest way to do this is by checking the Status bar.

The status bar in Word 2013 would by default display the Word Count and in case if it not displayed then right click on the Status bar and choose the Word Count in Customize Status Bar menu list.

Also See: How to find word count of an email message in Outlook

How to open or close archive file in Outlook

September 9, 2014 By Ravi Shankar Leave a Comment

In this tutorial, we will see the steps to open or close archive file in Outlook 2013 and Outlook 2010.

Open archive file in Outlook 2013 and Outlook 2010

If you have archived your outlook items and you want to open in Outlook then you can use the settings available as apart of Outlook Options.

Click on the File menu –> Open –> Open Outlook Data file option

This would display the following Open Outlook Data File window.

Navigate to the folder where the archive file present and choose the file. Now the archived items would be available as apart of your outlook folder structure.

Close archive folder in Outlook 2013 and Outlook 2010

Outlook users can close open archive folder by following the below mentioned steps.

Launch Outlook and then move to the Navigation pane.
In the Navigation Pane, right click on the Archive folder that needs to be closed.

Select Close “archive” option from the list of available menus. By this way you can close an archive file in Outlook 2013 and Outlook 2010

Also See: How to find mailbox size in Microsoft Outlook

How to make a workbook read only in Excel

September 8, 2014 By Ravi Shankar Leave a Comment

We have already seen how to How to make a presentation read only in Power Point. Similarly an excel workbook can be made read only using Excel Options. Listed below are the steps to make a workbook read only in Excel 2013 and Excel 2010

Click on the File menu –> Info menu