When you create an “Out of Office Reply” in Outlook (Exchange Server), Outlook ONLY sends one notification to each sender that you receive a message from during the time the reply is turned on. If you would like a notification sent EVERY time you receive an e-mail (regardless of the sender), you must create a “Rule”.
Using “Paste Special” with ‘Add’, will allow you to take two sets of data and add them together without having to create an extra column and a formula. In this example one company purchased another company with the same product line. We need to combine the sales figures for the year of the two identical products.
Using “Paste Special” with ‘Subtract’, will allow you to subtract a set of data from another set of data, without having to create an extra column and a formula. In this example we are going to back out the defective returns from the sales figures for each month.
Using “Paste Special” with “Divide” will allow you to take selected data and divide it by a number in just a few quick steps. In this example we will take sales figure totals for a product and divide it by the price of the product to determine the quantity of items sold. This process is shown in Excel 2010, but will also work in Excel 2007 and Excel 2003.
If you use Exchange you have at least two address books, the “Global Address List” and a “Contacts” list. You can also create more than one address book in Outlook. You can change what address book Outlook accesses by default.