How to Manage Email Storage on the Server in Microsoft Outlook 2010

If you use the webmail, or connect to your server via IMAP setting, you are not storing the email in your mail client – you are working with mail directly on the server. So once you delete the email there, it is gone. But if you are using a POP3 setting, your setup is different.

From time to time, my clients ask me why they hit the storage limit for their mail, even if they keep  cleaning out their Outlook mailbox.

The answer is simple – you need to address the mail storage limit on the mail SERVER, not your personal computer, and I bet you have “Leave a copy of messages on the server” enabled.

Imagine that your mail server is the post office, and your mailbox is your Outlook. Now picture this: your email comes to the post office, and is being stored there. A postal worker makes a copy of every piece of mail, leaves a copy at the post office, and delivers the original your mailbox at your home. You may be taking out your bills and junk mail out of your mailbox every day, cleaning it out, to make room for more mail to come in the next day. But if you do not instruct the postal worker to remove the unwanted copies from the post office, they will just keep piling up there, until the post office runs out of room, and is no longer able to receive any new mail. And you will be standing next to your empty mailbox wondering what happened to your mail!

So it’s kind of the same scenario of how your email is being processed between a server and a computer:

  • Mail server receives the email.
  • Your email client (such as Outlook) connects to the server, and if its a POP3 connection, downloads the message to your personal computer.
  • Mail server keeps a copy.
  • YYou maintain your inbox on your personal computer by either keeping, archiving or deleting the message …but what about the server email maintenance?

You may have access to your server mail via webmail, and can decide if you want to delete some of the older and unwanted emails. Sometimes it becomes a tedious task, especially if you receive a large volume of emails.

What you should do is to make a proper setup for your Microsoft Outlook to manage the email storage on the server. When you delete email from the server, it does not remove email messages from your Outlook, if they were already downloaded.

I know some people are worried and feel attached to their email – no pun intended in regards to the “attachments”, and prefer to keep copies “just in case”.

A much better practice would be to compromise on the certain number of days that you may want to keep the email on the server – I have 14 days set for my preferences, but you may want to choose 5, or 30 – just remember to pick a reasonable number that works for the general flow and volume of emails coming your way. In addition, it is wise to Archive your mail  in the outlook to make sure your inbox does not get overstuffed.

4 Steps to Setup Your Email Storage Preferences in Outlook

Here are some screenshots for the Microsoft Outlook (part of Microsoft Office Professional Plus 2010, version 14) mail storage setup.

Step 1: File > Info > Account Settings > Choose Account settings from Additional Drop down

How to Manage Email Storage on the Server in Microsoft Outlook 2010

Step 2. Change Account > More Settings

Change Account  More Settings

Step 3.

 

Step 4. Advanced > Delivery > Check “Leave a copy of messages on the server”> Choose X number of days.

outlook_delete_emails_4.gif

If you choose not to store mail on the server, it will download everything straight to your Outlook inbox, and you can manage them all on your personal computer instead. If this is your preferred option, just un-check the Delivery option altogether.

outlook_delete_emails_4a.gif

 

Activate Microsoft Office 2019 without Product Key for Free

After a series of preview versions, Microsoft finally came out with an official version of Office 2019. It is stable one, this means you can download and use it right now without worrying about fatal errors which you have gotten in beta versions before. However, I regret to inform that according to the disclosures, Microsoft Office 2019 only works on Windows 10. So if you are using Windows 8.1 or older versions, you will not be able to install it. Honestly, I hate what Microsoft have done to force users to use Windows 10. And I think Office 2016 is still a good choice for casual users.

Activate Microsoft Office 2019 without Product Key for Free

How to Activate Microsoft Office 2019 without Product Key for Free

Step 1: You copy the following code into a new text document.

Click here to copy this code

Then you create a new text document.

office-2016-for-free-6

Step 2: Paste the code into the text file. Then save it as a batch file (named “1click.cmd”).

code-to-activate-microsoft-office-2016

save-code

Step 3: Run the batch file as administrator.

office-2016-free

Please wait…

office-2016-for-free-10

Done! You Office has been activated successfully. Please check activation status again.

office-2019-product-activate

Check the activation status again.

How to Activate Microsoft Office 2019 without Product Key for Free

You can watch this video to know How to Activate Microsoft Office 2019 without Product Key for Free

More information:

  • Here is KMS client key of Office 2019: NMMKJ-6RK4F-KMJVX-8D9MJ-6MWKP.

Source : How to Activate Microsoft Office 2019 without Product Key

You can use Microsoft Toolkit to activate MS Office 2019

How to Activate Microsoft Office 2010 without Product Key for Free

Step 1: Copy the code below into a new text document.

Click Here to copy this code

Then you create a new text document.

office-2010-for-free-6

Step 2: Paste the code into the text file. Then save it as a batch file (named “1click.cmd”).

code-to-activate-microsoft-office-2010-1

save-code.jpg

Step 3: Run the batch file as administrator.

Run the batch file as administrator.

Please wait…

office-2010-for-free-13

Done!

office-2010-for-free-11-1

Then you check the activation status again.

You can use Microsoft Toolkit to activate MS Office 2010

Read more :

How to Recover an Unsaved Excel File

How to Recover an Unsaved Excel File

We have experienced a situation where we have created a Excel file and then accidentally closed it out without saving it. Is it lost forever? Do I have to recreate the entire file over? Those are just a few of the questions that will be flying around in your head. Take a deep breath, and follow the steps below to recover your excel file.

1.You click the File tab => Info =>  Manage Documents.

How to Recover an Unsaved Excel File

2.You select “Recover Unsaved Workbooks” from the drop-down menu.

How to Recover an Unsaved Excel File

3.Click “Open” when you’ve selected the file you want to recover.

4.Click the Save As button and save your Excel file .

You also recover overwritten Excel files

You click on the FILE tab =>  Info  => Manage Versions button you’ll see all autosaved versions of your file.

recover overwritten Excel files

Excel automatically saves versions of the workbook at specified intervals, but only if you’ve made changes to your spreadsheet between these intervals. The name of each version has a date, time and the “(autosave)” note. When you click any of them, it will open along with the most current version of your workbook so that you can compare them and see all the changes.

If the program closed incorrectly, the last autosaved file is labeled with the words (when I closed without saving).

Read more :

How to Recover an Unsaved Word Document

Applies to : Microsoft Word 2010, Word 2013, and Word 2016

We have experienced a situation where we have created a Word document and then accidentally closed it out without saving it. Is it lost forever? Do I have to recreate the entire document over? Those are just a few of the questions that will be flying around in your head. Take a deep breath, and follow the steps below to recover your document.

How to recover an unsaved Word document

1.You click the File tab => Info =>  Manage Documents.

How to Recover an Unsaved Word Document

2. You select “Recover Unsaved Documents” from the drop-down menu.

Recover Unsaved Documents

3.Click “Open” when you’ve selected the document you want to recover.

document you want to recover

4.Click the Save As button and save your Word document.

You can watch this video to know How to Recover an Unsaved Word Document :

Change the setting AutoRecover Word

If you would like change the frequency with which Microsoft Word automatically saves a recoverable copy of your document, follow the steps below. The default time is set to 10 minutes.

  1. Click the File tab => Options.
  2. In the Options dialog box you click the Save option located on the left side.Change the setting AutoRecover Word
  3. Under Save documents change the minutes to how often you would like Word to save a recoverable version of your document.
  4. When finished click OK

Here’s hoping that you are able to recover all of your work!

Read more :

Tag : How to Recover an Unsaved Word Document

Read more :

How to merge two word documents into one

Applies to: Microsoft Word 2010 , Office Word 2007

If you need to cope with Word documents quite often during work, merger of multiple Word documents into one might be required sometimes. You can copy and paste the content directly when the info quantity is not large. But what if it is not that case?

Insert” tab allows you to subtly merge documents.

Insert tab allows you to subtly merge documents

Locate “Object“, press a small triangle next to it, and click “Text from File” from the dropdown menu.

Text from File

After that, you can select files to be merged into the current document. By pressing and holding Ctrl to select more than one documents.

(Note: Documents placed at the top will be merged in the first place. Therefore, please sort and number each target document in case that you want to keep a certain sequence for your documents. )

How to merge two word documents into one

This method applies both to Word 2010 and Word 2007. Attention required: Formats will not be necessarily remained when you merging the documents. Please be careful of that.

Tag : how to merge two documents in word , how to merge two word documents

Read more :

How to Change Default Font in Outlook

Applies To: Outlook for Office 365 , Outlook 2016 , Outlook 2013 ,

When you set a default font, every new document you open will use the font settings that you selected and set as the default. The default font applies to new documents that are based on the active template, usually Normal.dotm. You can create different templates to use different default font settings.

How to Change Default Font in Outlook

  1. Click File > Options > Mail > Stationery and Fonts…How to Change Default Font in Outlook

  2. Select the font you want to change
    • New mail messages – Sets the default font for original messages you compose.
    • Replying or forwarding messages – You can have a different font on messages you’re forwarding or replying to. This setting is mostly for the two check boxes that let you mark your comments with your name (or other text) or with a different color of text.
    • Composing and reading plain text messages – Plain text messages will be received by the other person with a standard font, but if you want to use a nicer font when you’re writing the message you can. Just understand that font won’t be sent with the message.
  3. Select the options that you want to apply to the default font, such as font style and font size.
  4. Click OK all the way back out to save your changes.Tag : How to Change Default Font in Outlook

Read more :

How to Change Default Font in Word for Mac and Windows

Applies to: Office Word 2007 , Microsoft Word 2010 , Microsoft Word 2013 , Microsoft Word 2016

When you set a default font, every new document you open will use the font settings that you selected and set as the default. The default font applies to new documents that are based on the active template, usually Normal.dotm. You can create different templates to use different default font settings.

How to change default font in Word for windows ?

Start with a blank document, or if your document already contains text that is formatted with the properties that you want to use, select that text.

  1. On the Home tab, you click the Font Dialog Box Launcher, and then click the Font tab.How to Change Default Font in Word For Windows
  2. Select the font, point size, and any attributes that you want.How to Change Default Font in Word For Windows 2
  3. Click Set As Default, and set the scope of your changes:
    • Select This document only? if you want your changes to apply to only the current document.
    • Select All documents based on Normal .dotm template? if you want your changes to apply to any document based on the Normal template.Click OK to apply your changes
  4. Click OK to apply your changes.

You can watch this video to know “How to change default font in Word for windows”

How to Change Default Font in Word for Mac

Changing the default font in any template means that the font is used in every new document that is based on that template. For example, the default font for new blank documents is based on the Normal template.

  1. Open the template or a document based on the template whose default settings you want to change.

  2. Under Font, click the font you want to use, and then under Size, click the size you want to use for the body text.How to Change Default Font in Word for Mac

Click Default in the bottom left corner, and then click Yes to apply the change to all new documents based on the template. Click OK when finished.

You can watch this video to know “How to Change Default Font in Word for Mac”

Read more :

Tag : How to Change Default Font in Word for Windows , How to Change Default Font in Word for Mac

What is Office Configuration Analyzer Tool ( OffCAT ) ?

Information

What is Office Configuration Analyzer Tool ( OffCAT )


The Microsoft Office Configuration Analyzer Tool (OffCAT) was removed from the Microsoft Download Center on June 11, 2018.

The Outlook scanning functionality of OffCAT is available in the Microsoft Support and Recovery Assistant for Office 365 (SaRA) tool. SaRA offers several improvements, including the ability to identify and fix specific issues in Office Setup , Outlook, OneDrive for Business, and several other Office programs. You can use the SaRA tool is used to scan for issues in Outlook.

Tag : OffCAT

How to use the Histogram in Excel

Applies to: Excel 2013Excel 2010Microsoft Office Excel 2007

How to use the Histogram in Excel

Summary

You can analyze your data and display it in a histogram (a column chart that displays frequency data) by using the Histogram tool of the Analysis ToolPak in Microsoft Office Excel. To create a histogram, you must organize the data in two columns on the worksheet. These columns must contain input data and bin numbers. Input data is the data that you want to analyze by using the Histogram tool. Bin numbers are the numbers that represent the intervals that you want the Histogram tool to use for measuring the input data in the data analysis.

How to use the Histogram in Excel

When you use the Histogram tool, Excel counts the number of data points in each data bin. A data point is included in a particular data bin if the number is greater than the lowest bound and equal to or less than the largest bound for the data bin. If you omit the bin range, Excel creates a set of evenly distributed bins between the minimum and maximum values of the input data.

The output of the histogram analysis is displayed on a new worksheet (or in a new workbook) and shows a histogram table and a column chart that reflects the data in the histogram table.

Before you can use the Histogram tool, you have to make sure that the Analysis ToolPak Add-in is installed.

Make sure that the Analysis ToolPak Add-in is installed

To make sure that the Analysis ToolPak Add-in is installed, follow these steps:

1.On the File menu, click Options.
Options excel 2010
2.Click Add-Ins in the navigation pane.
Add-Ins excel 2010

3.In the Manage list, select Excel Add-ins, and then click Go.

4.In the Add-Ins dialog box, make sure that the Analysis ToolPak check box under Add-Ins available is selected, and then click OK.

Analysis ToolPak check box

Note For the Analysis ToolPak Add-in to be displayed in the Add-Ins dialog box, it must be installed on your computer. If you do not see Analysis ToolPak in the Add-Ins dialog box, run Microsoft Excel Setup and add this component to the list of installed items.

Create a histogram table

To create a histogram table, follow these steps:

  1. Copy and paste the following data into a new worksheet.
    87 20
    27 40
    45 60
    62 80
    3
    52
    20
    43
    74
    61

    2.Do one of the following:

    • In Excel 2013, Excel 2010 and Excel 2007, on the Data tab, click Data Analysis in the Analysis group.

    Data Analysis in the Analysis group

    • For Excel 2003 and earlier versions of Excel, click Data Analysis on the Tools menu.

    3.In the Data Analysis dialog box, click Histogram, and then click OK.

    the Data Analysis dialog box

    4.In the Input Range box, type A1:A10.

    the Input Range box

5.In the Bin Range box, type B1:B4.

6.Under Output Options, click New Workbook, select the Chart Output check box, and then click OK.

Excel generates a new workbook with a histogram table and an embedded chart.

Based on the sample data from step 1, the histogram table will resemble the following table:

   A1: Bin     B1: Frequency
   A2:  20     B2:        2
   A3:  40     B3:        1
   A4:  60     B4:        3
   A5:  80     B5:        3
   A6: More    B6:        1

Your chart will be a column chart that reflects the data in this histogram table. In this example, the bin that corresponds to data values from 0 to 20 contains two data points: 3 and 20.

Tag : how to make a histogram in excel , how to create a histogram in excel

Read more :