Wednesday, July 30, 2008

Microsoft Outlook 2000 Web Feature

Managing Communications on Your Intranet
Microsoft Outlook 2000 provides the following ways to manage information from the Internet or your intranet. It provides best Outlook Support to Handle Email services on outlook. Users can use the Contacts folder to do the following:
• Keep track of contacts’ Web sites.
• Open the Web history folder from within Outlook 2000.
• Share a catalog of Web sites in a public folder.
Browse Web pages in Outlook
In Outlook 2000, you can select a Web page from the Favorites menu or use the Web toolbar to enter a URL and display a Web page in Outlook. Or you can send the Web page that you are currently viewing in Outlook as the body of an e-mail message by clicking Send Web Page by E-Mail on the Actions menu
System Policy Tip If you do not want your users browsing the Web from Outlook 2000, you can disable commands on the Web toolbar by using a system policy. In the System Policy Editor, disable the commands in the Microsoft Outlook 2000\ Disable items in user interface\Predefined category that you do not want available to your users. For more information, see Using the System Policy Editor.

Tuesday, July 29, 2008

How AutoRecover and AutoSave work

The AutoRecover option (in these Microsoft Office programs: Word, Excel, PowerPoint, Publisher, and Visio) and AutoSave option (in Microsoft Office Outlook) can help you avoid losing work in two ways:
• Your data is automatically saved If you enable Auto Recover or AutoSave, your file (such as a Microsoft Office Word document) or item (such as an Outlook Support and Outlook e-mail message) is automatically saved as often as you want. Therefore, if you have been working for a long time but forget to save a file or if your power goes out, the file you have been working on contains all or at least some of the work you have done since you last saved it.
• Your program state is automatically saved In Microsoft Office Excel, Microsoft Office Outlook, Microsoft Office PowerPoint, and Microsoft Office Word, there is an additional benefit to enabling AutoRecover or AutoSave. In these programs, if you enable this option, some aspects of the state of the program are recovered when the program is restarted after it closed abnormally.
For example, you are working on several Excel workbooks at the same time. Each file is open in a different window, with specific data visible in each window. In one of the workbooks, a cell is selected to help you keep track of which rows you already reviewed, and then Excel crashes. When you restart Excel, it opens the workbooks again and restores the windows to the way they were before Excel crashed.
Although not every aspect of your program's state can be recovered, in many cases, the Recovery feature can help you recover more quickly.

Thursday, July 24, 2008

How to Repair a corrupted workbook

I am continuing with Computer Help for Excel Application. It post help to repair corrupted file in Excel. When you open a workbook that has been corrupted, Microsoft Office Excel automatically starts File Recovery mode and attempts to reopen and simultaneously repair the workbook.

Excel cannot always start File Recovery mode automatically. If you cannot open a workbook because it has been corrupted, you can try to repair the workbook manually.

You can also try other methods to recover workbook data when repairing a workbook is not successful. As a preventive measure, you may want to save your workbook often and create a backup copy every time that you save it. Or you can specify that Excel automatically creates a recovery file at specific intervals. This way, you will have access to a good copy of the workbook, if the original is deleted accidentally or if it becomes corrupted.

Repair a corrupted workbook manually

  1. Click the Microsoft Office Button , and then click Open.
  2. In the Open dialog box, select the corrupted workbook that you want to open.
  3. Click the arrow next to the Open button, and then click Open and Repair.
  4. Do one of the following:
    • To recover as much of the workbook data as possible, click Repair.
    • To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

Wednesday, July 9, 2008

Add In Excel data on the Web

Some folks at Microsoft Research have developed an add in that makes it easy to use a Web page as a data source in Excel. Here is a brief description:

The Excel 2007 Web Data Add-In provides an intuitive user interface for importing textual data from any given webpage via a user’s selections of interest, such as stock quotes, weather temperature, ect, into a spreadsheet and keeping that data “up-to-date”. That is, if the webpage data changes, the spreadsheet can be updated by a click of the data “Refresh” button. Also note that the add-in can automatically learn from a user’s selection and optionally select similar items to help save time. You can put Excel sheet data over the Network. Microsoft Office 2007 apply this facility through Outlook Support and using Outlook it will done.

Would you like your employees to be able to access, from a Web page, sales data for their territories compared to sales data for other employees? Or how about a spreadsheet for standard cost calculation? Or maybe you want to use a Web page to show the profits in different areas of your company in a chart.

You can save a Microsoft Excel workbook or part of the workbook, such as a single item on the worksheet, as a Web page and make it available on an HTTP (HTTP: Internet protocol that delivers information on the World Wide Web. Makes it possible for a user with a client program to enter a URL (or click a hyperlink) and retrieve text, graphics, sound, and other digital information from a Web server.) site, an FTP (FTP: A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands, such as listing files and folders, to work with files on a remote location.) site, a Web server (Web server: A computer that hosts Web pages and responds to requests from browsers. Also known as an HTTP server, a Web server stores files whose URLs begin with http://.), or a network server for users to view or interact with. For example, if you have sales figures set up on an Excel worksheet, you can publish the figures along with a chart to compare figures on a Web page, so that users can view or even work with the numbers in their browsers without having to open Excel.

Monday, July 7, 2008

Add a command to the Quick Access Toolbar

I am continuing with the Microsoft Office 2007 with Outlook Support .Today I am discussing about Microsoft Excel 2007.The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab that is currently displayed. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar.
You can add a command to the Quick Access Toolbar directly from commands that are displayed on the Office Fluent Ribbon.
1. On the Ribbon, click the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar.
2. Right-click the command, and then click Add to Quick Access Toolbar on the shortcut menu.
Notes
• You cannot increase the size of the buttons representing the commands by an option in Microsoft Office. The only way to increase the size of the buttons is to lower the screen resolution you use.
• You cannot display the Quick Access Toolbar on multiple lines.
• Only commands can be added to the Quick Access Toolbar. The contents of most lists, such as indent and spacing values and individual styles, which also appear on the Ribbon, cannot be added to the Quick Access Toolbar.

Thursday, July 3, 2008

How Excel Services supports connections to external data sources

PivotTable reports are designed to aggregate a lot of numerical data into sums and totals, and to work with multidimensional data that is organized into a hierarchy. On the other hand, external data ranges are two-dimensional tables structured as rows and columns, that display nonaggregated records of source data.

When you use the Data Connection Wizard or Microsoft Query to connect to external data, you usually create an external data range. The only exception to this is when you create a PivotTable report that is connected to external data. A PivotTable report does not create an external data range. This difference in the way that connections are created is important to understand when you publish a workbook to Excel Services, because Excel Services only supports external data connections based on PivotTable reports and does not support external data ranges.

I want to sahre my experience with Microsoft Office Outlook Support and also discussed about Email Support

Tuesday, July 1, 2008

Composing different types of documents

You can use templates to quickly create all kinds of documents. Word 2007 comes with numerous templates, and you can download many more. When you start a new document based on a template, the document contains its own design elements, and the template's predefined styles ensure that all your paragraphs work harmoniously together.

Start the document

  1. Choose New from the Office menu to display the New Document dialog box.
  2. With Blank And Recent selected in the left pane, review any templates you've used recently, and double-click the one you want.
  3. If you don't see the one you want, click Installed Templates to see the Microsoft templates that were either installed on your computer or downloaded, and double-click the one you want.
  4. If you still don't see the one you want, click My Templates, and, in the New dialog box that appears, double-click one of the custom templates.
  5. If you want to download a template from Office Online, click a topic to see templates of that type that are available for download, and double-click the one you want.
  6. If you want to use an existing document as the basis for a new document, click New From Existing, and locate and double-click the document in the New From Existing window that appears.

    Templates are completely customizable and can come from a variety of sources, so you're likely to encounter substantial differences both in design and in ways you can complete a document based on a template. Try to choose a template that's easy to use and whose design is correct for your purposes.

Complete the document

  1. If you aren't already in Print Layout view, click the Print Layout View button.
  2. Save the document with the file name you want, in the location you want.
  3. If the Show/Hide ¶ button on the Home tab isn't already turned on, click it so that you can see all the elements in the template.
  4. If information such as the date is inserted automatically, don't modify the information—it was inserted using a Word field that's automatically updated and formatted.
  5. Click a content control—in this case, an Address content control—and replace any placeholder text with your own text.
  6. Don't delete any of the special design elements—doing so could ruin the layout of the document.
  7. Complete the document, and then save, print, and distribute it.

A paragraph mark contains the paragraph's formatting, so don't delete a paragraph mark unless you want to remove that paragraph's elements from your document. When you delete a paragraph mark, any special formatting that was designed for that paragraph will be lost.

I want to share my experience with Microsoft Outlook Support and Computer Help