Microsoft Office 2010 KMS Licensing

Taken from Microsoft Site:


Brief Description
Volume licensing editions of Microsoft Office 2010 suites and applications, Microsoft Project 2010 and Microsoft Visio 2010 require activation. Key Management Service (KMS) is a local volume activation method. To activate your Office 2010 client installations with KMS, you will need to set up a KMS host. KMS Licensing is recommended if you have 50 or more workstations.


Overview
An Office 2010 KMS host is required if you want to use KMS activation for your volume license editions of Office 2010 suites or applications, Microsoft Project 2010 or Microsoft Visio 2010. When Office 2010 volume edition client products are installed, they will automatically search for a KMS host on your organization’s DNS server for activation. All volume editions of Office 2010 client products are pre-installed with a KMS client key, so you will not need to install a product key.

The download contains an executable file that will extract and install KMS host license files. Run the file on either 32-bit or 64-bit supported Windows operating systems (Windows 7, Windows Server 2003 Service Pack 2, Windows Server 2008 R2). These license files are required for the KMS host service to recognize Office 2010 KMS host keys. It will also prompt you to enter your Office 2010 KMS host key and activate that key. After this is done, you may need to use the slmgr.vbs script to further configure your KMS host.

Microsoft Office KMS clients are only activated when five or more than five computers with MS Office installed attempt to get activated using the KMS host. In case of operating systems (e.g. Windows Vista and Windows 7), activation starts after 25 or more than 25 computers with Windows client request for activation.


Instructions
Follow these steps to set up a KMS host:

1. If you are running Windows Server 2003, you will need to perform this extra step. You will need to download and run the files below:
   Windows Server 2003 32-bit 
   Windows Server 2003 64-bit
2. Download and run the KeyManagementServiceHost.exe file on this page on a supported operating system.
3. Enter your Office 2010 KMS host key when prompted. 
4. Click OK to continue with activation. 
5. Open port 1688 and allow the KMS host service through the firewall.
   Windows 7 volume editions or Windows Server 2008 R2.
   Open Control Panel and click on the Windows Firewall icon.
   Click on the “Allow a program through Windows Firewall” link.
   Click on the Change Settings button.
   Check the box for Key Management Service. 
6. Read the documentation to learn more about configuring your KMS host (including activation by telephone) with slmgr.vbs at TechNet.

Associated link: Office 2010 Administrative Template files (ADM, ADMX/ADML) and Office Customization Tool 

Address Labels in Microsoft Office

For address labels you want to use Microsoft Word:

Starting labels depends on your version of Microsoft Word. (Word 2007/2010 is the one with the very different ribbon tool bar running across the top.)

If you have Word 2003:

1. Click on Tools, and if Letters and Mailings is not on the list click on the double down arrows at the bottom of the list to shop hidden options.
2. Select Letters and Mailings, then select Envelopes and Labels.. from the pop out list.
3. Select the tab – Labels
4. In the bottom right of the Labels dialog box – click on the picture of the label, this will allow you to select the label the most likely meets your needs.
5. If you need to change a setting of the label click on the Details button, when changes have been made click Ok.
6. When you are happy with the label click Ok.
7. Type the address is the address box.
8. Then click Print.

If you have Word 2007:

1. Above the Ribbon tool bar at the top, click on Mailings.
2. The second option in is Labels
3. In the bottom right of the Labels dialog box – click on the picture of the label, this will allow you to select the label the most likely meets your needs.
4. If you need to change a setting of the label click on the Details button, when changes have been made click Ok.
5. When you are happy with the label click Ok.
6. Type the address is the address box.
7. Then click Print.

How do I turn off the autocomplete function in Word 2007

Start Microsoft Word

Press Alt+F11 to show the Visual Basic Editor. Press Ctrl+G to activate the
Immediate window. Type

Application.DisplayAutoCompleteTips = False

and press Enter.

Close Visual Basic editor.

OneNote Web Exporter

Plug-in to export your OneNote 2007 notebooks as an interactive web site.

http://www.codeplex.com/ONWebber

How to configure Internet Explorer to open Office documents in the appropriate Office program instead of in Internet Explorer

In Windows XP

To configure Internet Explorer to open Office files in the appropriate Office program by using the Folder Options tool:

1. Open My Computer.
2. On the Tools menu, click Folder Options.
3. Click the File Types tab.
4. In the Registered file types list, click the specific Office document type (for example, Microsoft Excel Worksheet), and then click Advanced (or Restore).
5. In the Edit File Type dialog box, click to clear the Browse in same window check box.
6. Click OK.

Additional information: http://support.microsoft.com/kb/162059

MS Excel - deleting blank rows

This technique will allow you to delete all rows that have blank cells in a particular column.

1. First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data .
2. Now, select the cells in one column from the top of your list to the bottom.
3. Make sure that all the blank cells in this selected range are the rows you want to delete.
4. Select Edit, Goto (or press F5).
5. Click the Special button.
6. Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
7. Now choose Edit, Delete, select the Entire Row option and click OK.

If you work with large lists of data in Excel, this tip will save you a lot of time.

Link: http://www.theexceladdict.com/tutorials.htm

Changing the Attached Word Template

Problems with Microsoft Word templates.

If you move the document to a different computer that doesn't have the template, the attachment will be broken. If you move the template into a different directory on your computer, the attachment will probably be broken. If your template is on your server and you give the server a different name, the attachment will be broken. You can change the template attached to a document using:

In Microsoft Word 2003

• Tools => Templates and Add-Ins...
• Click Attach, then browse to the correct location i.e. file://Servername/Templates and then select the appropriate template.
• Tick automatically update document styles
• Click Ok
• Save the document.

In Microsoft Word 2007

• Click the Microsoft Office Button , and then click Word Options.
• Click Add-Ins.
• In the Manage list, select Templates, and then click Go.
• Click the Templates tab.
• Click the Attach button then browse to the correct location i.e. file://servername/Templates and then select the appropriate template.
• Tick automatically update document styles
• Click Ok
• Save the document.

Links:

Template basics
Word 2007 beta help