To application package Microsoft office in addition to Outlook, there are also such common applications as Word text editor, electronic Excel tables, an application for preparing electronic PowerPoint presentations and an application for working with Access databases.

All these applications are independent and self-sufficient, but their joint use opens up truly unlimited possibilities in the organization of office work. Using Outlook along with other applications included with Microsoft Office allows you to:

• create messages using the full power of text word editor. Compared to the relatively poor (albeit sufficient) features provided by the Outlook format bar, Word is able to create full-fledged documents that are distinguished by a variety of styles and design templates, containing embedded objects, etc. The interaction between Outlook and Word will be discussed in the first section of this chapter. Moreover, this section will cover a common tool for all Office applications - distribution along the route;
• create messages using the full power of the Excel spreadsheet editor. The created table can be easily sent not only as an attached file, but also saved as a message. This possibility will be discussed in the second section of this chapter. In addition, in this section we will talk about a common tool for all Microsoft applications - placing documents in a shared folder;
• create meetings to participate in an electronic conference conducted by means of PowerPoint. The creation of an electronic conference is directly related to the use of the above Microsoft NetMeeting application. (See section 11.5 “Net Meeting”). Working PowerPoint with Outlook will be discussed in the third section;
• create messages using Microsoft Access, capable of connecting to a remote database to display information. Sharing Outlook and Access allows you to quickly export and import data from Outlook folders into Access tables. This possibility will be discussed in the fourth and final section of this chapter.

Outlook and Word

The interaction between Outlook and Word is perhaps the most typical example joint work. I already mentioned above that as a message editor, the user can specify Microsoft Word.

Example 18.1. Word as a message editor

(Used in Outlook)

> Tools > Parameters Message

Use Microsoft Word as a Message Editor

Use Microsoft Word to read rich text messages

As an example of how to use Word, consider creating a message containing curly text and a diagram showing the structure of this book.

Create a message using Word

There are two ways to create a message using Word:

• Launch the Word application, create a document and select command > File > Send > Message.
• Directly in the Outlook application by selecting the command > Actions > New message using > Microsoft Word (Fig. 18.1).

As can be seen from the figure, the essence of the message has not changed, the fields for entering recipients and the subject of the message have remained, the signature and the panel have been automatically added Drawing(Drawing), but the toolbar has been noticeably enriched Formatting(formatting).

Rice. 18.1. Outlook message(Microsoft Word editor)

Insert artistic text

So let's first create a nice title for our post using a WordArt object.

Example 18.2. Inserting a WordArt

> Insert > Drawing > WordArt

Select desired style inscriptions OK

Text:= book structure Bold OK

(Formatting panel) Centered

As a result of our actions, a beautifully designed text will appear with a yellow gradient fill in the center (Fig. 18.2).

To change properties this object You can use the buttons on the toolbar of the same name. In our case, let's change the fill color from yellow to blue.

Rice. 18.2. WordArt text in a message

Rice. 18.3. Dialog window Filling methods

Example 18.3. Changing the Properties of a WordArt Object

(On the WordArt toolbar)

WordArt Format Color and Lines

Color Fill Methods…

gradient

Single Color Color1 Blue

Hatch Type From Center

Options (Figure 18.3)

Insert a chart

The next step we are considering is inserting a chart, by the way, which is one of the innovations in Word.

Example 18.4. Insert a chart

> Insert >Organization Chart…

Select the type of chart (Fig. 18.4)

Rice. 18.4. Dialog window Chart Library

A stub will appear in the body of the message, displaying the selected chart. But it consists of one "root" and only three "branches", while this book has four parts. Let's add another branch and change the chart style.

Example 18.5. Adding a branch to a chart

(Highlight the root of the diagram)

(On the Org Chart panel) Add Shape

Auto Format

Choose a Chart Style Relief Gradient

Now it remains to enter the text of the chart. To do this, click once with the left mouse button on one of the chart stubs and enter the appropriate text. The final version of the message, edited and formatted by means of Word, is shown in Fig. 18.5.

Rice. 18.5. The final version of the message

After the message is created, it remains to fill in the fields To whom(That) and Subject(Subject), then press the button Send(Send).

Comment

Since our message is saved and sent in HTML format, some of the formatting may be lost or altered. Keep this in mind when creating messages in Word! Sometimes it's better to just attach messages you've created as an attachment.

Again, we recall that we are only considering general principle collaboration between Outlook and other Office applications. In addition to inserting objects (of which there are many more than two), there are also forms, frames, styles, tables, fields ... The list is endless. The world of Microsoft Office applications is wide and truly multifunctional. Learn it in parallel with Outlook and other existing applications. In the end, the road will be mastered by the walking ...

Sending a document along a route

Sending a document along the route(Routing) refers to sending a document by email to colleagues in certain sequence. The distribution sequence is called document path.

Having received the document, the addressee can make his changes and comments and send the document further along the route. At the end of the route, after the document has been viewed by all the recipients specified in the routing list, you can request the return of the document or specify the user for whom it is intended, for example, the project manager.

Example 18.6. Sending a document along a route

> File > Open... (open the required document)

> File > Send > Along the route. . .

Nashatyrev Anton To

Mokhovikov Oleg To

Message text:= Dear colleagues! Read the attached document and express your views and comments on what has been written. Thank you in advance, Egor Usarov.

in turn

Return at the end

Track Status

Send

Comment

During the execution of this program, you may see dialog boxes Outlook security alerts to third-party tampering and access to Outlook data. In this case, always agree to allow access (after all, this request comes from your actions, and you expect it).

The assigned route can be attached to the document in order to send it not immediately, but to do it later. To do this, at the last step of the program, you need to press the button Add(Add Slip).

> File > Send > Next Destination…

Send document Nashatyrev Anton

To refuse to send the document along the route and disconnect the route altogether, you need to click the button Clear(clear).

Let's go back to the example. After the button is pressed Send(Route), a message will be automatically created with the text specified in the field Message text(Message Text), and with an attached document to be sent (Fig. 18.6). Let's assume that the first addressee (in our example, this is Anton Nashatyrev) is configured responsibly, i.e. he will not leave the received message unattended or will not delete it without reading it, but will respond to it properly: he will read not only the mailing message, but also the attached document itself, and not only read it, but also add his wishes and comments to it, and then send it to the next correspondent. Let's try to follow how it happens.

To open the forwarded document itself, the recipient just needs to double-click on the icon of the attached document in the message. Further, in the usual way, the recipient makes his changes to the document. At the end of the work, he must send the document further along the route.

>File>Send > Next Destination…

Send document "Oleg Mokhovikov"

Rice. 18.6. Document distribution message

What will happen after that? First, the message will be sent to the next recipient on the mailing list - Oleg Mokhovikov. He will be able to read the document with changes already made and make his own. Second, the original sender will be notified when the document moves through the mailing list, because the dialog box Route(Routing Slip) was checked Track Status(Track Status).

If everything is in order, the document will be promoted on the mailing list until the entire mailing list of this document is exhausted. The last recipient in the route will be prompted to return the modified document to the initiator of the distribution, and thus the circle will be closed.

To speed up the process, you can send the document not one by one, but all at once. In this case, it is the sender's responsibility to merge the changes.

Outlook and Excel

From the very beginning of the book, when creating a message, we set ourselves the goal of passing not just text, but a table as the body of the message. Using Excel tools makes it easy to solve not only the problem of inserting tables, but also related components (for example, Excel charts).

As an example of how Outlook and Excel work together, consider sending a message containing a table showing the number of pages for each part of a book, and an Excel chart that graphically displays the percentage of each part in the book.

Creating a message using Excel

As with Word, there are two ways to create a message. But if in Word we chose the second option (creating a message from Outlook), now let's look at sending a table directly from the Excel application.

Rice. 18.7. Outlook Message (Editor Microsoft Excel)

Example 18.9. Creating a message using Excel

>File > Send > Message

Include Current Sheet in Message Body

Subject:= Statistics

Introduction:= This post contains...

Comment

In the Introduction field, the user can enter a text message (comment) preceding the table.

As mentioned above, we will consider sending the table shown in Fig. 18.10. On this stage the table contains only text and has no additional formatting.

Working with a table

Before sending a message containing a table, it is desirable to format it: highlight the heading, underline borders, etc. But the Outlook features allow you not only to format the table, but also work on its logic. In Example 18-10, we added another row, "Total", containing the sum of all the pages in the book, and then styled the table accordingly.

If the text of the message does not fit in the cell, its borders can be moved apart. To do this, move the mouse pointer to the junction with the name or numbering of the cells (the pointer will take the form of a double-headed arrow) and, holding down the left mouse button, move the boundaries of the column or row to the required distance.

Example 18.10. Working with an Excel spreadsheet

(Editing)

A6:= Total

Wb AutoSum (Formatting)

А1:Вб (Select by holding down the left mouse button)

> Format > Auto Format...

Rice. 18.8. Formatted message with Excel spreadsheet

Comment

In addition to using automatic style, you can apply additional formatting using the buttons on the toolbar of the same name.

Insert an Excel chart

The next step, which demonstrates the power of Excel and the use of this application with Outlook, is to create a chart that represents the data in the worksheet in a visual graphical form.

Example 18.11. Insert Excel charts

> Insert > Chart… Standard

Type Circular

Chart Title:= Outlook in original

Share Data Signatures

Rice. 18.9. Constructed diagram

Comment

If we had not selected the range A2:B6 before starting the chart, we could have set it later, at the second step of the Chart Wizard. In this case, it is not necessary to manually enter complex formula in the Data Range field. It is enough to select the desired range on the worksheet with the mouse, while the wizard's dialog box will collapse so as not to interfere with the selection, and the formula will appear automatically.

After inserting a chart, it may overlap the table being used. In order to transfer a diagram, it is enough to select it and, holding down the left mouse button, drag it to the required place.

Now let's turn directly to the diagram itself. All elements are displayed clearly and beautifully, with the exception of the data circle itself, which turned out to be very small. To increase the plotting area of ​​the chart, you need to click on the invisible square in which the circle and text explanations are inscribed (Fig. 18.9). A square box will appear with selection handles at the corners. Hook on these handles and drag, stretching the selection box until the circle is the size you need.

So, the message is completely ready for sending, it remains to enter the address of the recipient of the message and press the button Submit sheet(Send this Sheet).

Of particular interest is how our message will be displayed to the user, because, firstly, it is converted to HTML format, and secondly, not every recipient may have Excel installed. After sending and receiving messages, go to V folder inbox(Inbox) and open the created message (Fig. 18.10).

Rice. 18.10. Received message with table and chart

First, as you can see, the text entered in the field Introduction(Introduction) precedes the table and is separated from it by a bar. Secondly, the table format is preserved. And finally, our pride - the diagram completely matches the created one (format, data, etc.). The only thing missing is no signature since we created our message from Excel and not from Outlook. This shortcoming could be corrected by running the command before sending > .Insert > Signature > Regards.

Example 18.12. Insert signature

> Insert > Signature > Regards

Comment

Generally speaking, additional editing and formatting of messages is sometimes necessary, if not required. After creating a table (using Excel), the user can always open the message and edit it: insert a signature or a number of additional comments, as well as add a background, add a picture, etc.

Exchange folder

Working with Exchange folders is as common to all Office applications as is routed distribution. The essence of this feature is to place the active document in the public folders of the Microsoft Exchange server. Thus, the user, as it were, opens access to this document all participants working group.

Example 18.13. Send to Exchange folder

> File > Send > Exchange Folder…

Choose a folder < Общая папка>

After the document is placed in the shared folder, each of the users can open it by clicking on the appropriate link in the information viewing window (Fig. 18.11).

Outlook and PowerPoint

Microsoft PowerPoint is a versatile presentation preparation tool. After creating a presentation, the user can show it as local computer, and make a presentation online for the entire working group. The PowerPoint presentation is in HTML format and therefore only a browser is required for participants to view it Internet Explorer 4.0. Thus, the presentation can be carried out both within the company and between members of a small group located in different places. The number of participants is not limited, but if more than 16 listeners participate in the presentation, a special server room must be used to conduct it. Microsoft application netshow server.

The problem with any meeting is planning it. Of course, in order to hold a conference, in addition to the desire of the speaker, the consent of the participants is also required. In the case of a regular conference, the participation of all the actors is confirmed by the fact that they all gather together and at approximately the same time in the room designated for the conference. The presenter can schedule a PowerPoint e-conference like any other meeting using Outlook.

Rice. 18.12. Presentation and Dialog Box Schedule a broadcast presentation

Example 18.14. Broadcast planning PowerPoint presentations

> Slideshow > Live broadcast > Set up and schedule…

Description:= "Microsoft Outlook 2002 Genuine"(Fig. 18.12)

Parameters… Broadcasting settings (Fig. 18.13)

Display Mode Resizable

Assign...

Enter or select a name:< participants of the presentation

Required

Send

(A dialog box will appear notifying you that the broadcast is scheduled)

Rice. 18.13. Dialog window Broadcast options

Comment

Switches Only sound(Audio only) and Video and sound(Video and Audio) it makes sense to install if the computer of the presenter is equipped with a microphone and a video camera, and the computers of the participants are equipped with equipment for reproducing audio and video sequences. In our example, we do not assume this, so the checkbox is checked No(None).

The automatically filled meeting form (Fig. 18.14) is identical to those discussed earlier, See Chapter 2, Calendar, and Chapter 10, Teamwork in Outlook.

Comment

The only prerequisite for a live broadcast of a presentation to a wide audience is that the computer is connected to a network (global or local). Additional features can not be used if the technical conditions do not allow it.

After agreeing on the time and composition of the participants, you can proceed directly to the demonstration itself.

Rice. 18.14. Meeting form

Example 18.15. Live broadcast presentation

> Slideshow > Live Broadcasting > Start Broadcasting…

When holding a scheduled conference, the host of the presentation plans to broadcast it using the meeting scheduling interface in Outlook 2002. At the specified time, a meeting reminder window will appear on the computer screens of the participants, on which the participant will see a button, after clicking on which the introduction page of the presentation will be loaded (Fig. 18.15). Manages the transition of slides presenter presentation. On the participants' computer screens, the slides are shown in the same way as in a normal slide show.

Rice. 18.15. Main page of the live broadcast of the presentation

During a presentation, attendees can have private discussions, ask questions to the presenter, and receive responses via email via Outlook.

Outlook and Access

Microsoft Access is a Universal Database Management System and Outlook is a Universal Information Management System. Based on these definitions, it is natural to assume that these applications have some means of exchanging information among themselves. But in addition to exchanging information, Outlook, like Word or Excel, is able to create messages using Microsoft tools access. Only in this case, these tools are not in the field of formatting or editing, but in the field of providing data for sending-publishing.

In this section, we'll look at an example of importing information from an Outlook address book into an Access database, as well as creating a message containing the newly imported information.

Information exchange

First of all, open Access and create a database. After that, our goal will be to create a table containing data from the Outlook address book.

Example 18.16. Import data from Outlook to Access

> File > External Data > Import…

Outlook file type (The Exchange/Outlook Import Wizard will start automatically)

> Address Books > Outlook Contacts Address Book

In the new table

(At this step, it is proposed to determine the parameters of the imported data to find out if it is necessary to import them at all)

He import

Import to table:= Contacts

Rice. 18.16. Microsoft Access table with imported data

After importing, as expected, Access will display new table Contacts, containing information from the Outlook address book. The result of import is shown in fig. 18.16.

Working with the Access Data Page

Consider the following example. Let's say that one of the project participants has created a database whose information is interesting, and perhaps necessary, for other team members. There are several solutions for this task, but we will focus on the option of sending a message containing an Access Data Page. In fact, the message simply contains an HTML page with an ActiveX object that connects to the database and displays the data.

Example 18.17. Create a message with Access Data Page

> Actions > New Message Using... > Microsoft Office >Microsoft Access Data Page

(Opens Access with a wizard New page data access)

Constructor

Data source selection:=< Database>

After the done procedures, a page with a data grid will open. So, first of all, you need to place information fields that will be on the page. To do this, drag the required fields onto the table grid and replace its name, for example with Contacts. Then enter the name of the recipients of the message and click the button Send a copy.

Before sending a message, the user can see how it will be displayed to the recipient. To do this, select command > File > preview web pages. A Web browser will open with the loaded page, which will be displayed in the same way to the recipient of the message.

Rice. 18.23. Web page with data from Access

Using the buttons Back and Next, you can navigate through the table data Contacts. Also, when specifying the appropriate access parameters, you can edit the table (add or delete records), organize data filtering, etc. But this is already beyond the scope of this book.

Summary

So, in this chapter, we looked at how Office and Outlook can work together. Truly, working with Outlook, along with the tools provided by Word, Excel, PowerPoint, and Access, allows you to create rich messages and organize a more comfortable exchange of information and access to it.

• word. Message formatting. Using Word as the default editor. Distribution of the document along the route.
• Excel. Create a post with a table and a chart. Placement of documents in the public folders of the Exchange server.
• PowerPoint. Organize an online meeting to show a presentation.
• access. Import data from Outlook to Access. Create a message containing an Access Data Page.

Depending on the version of Word or Outlook you're using, you can insert and add various objects (such as PDFs, charts, or Excel worksheets) or an email message to a Word document using linking or embedding. To insert an object, on the tab Insert press the button An object.

Inserting a new object

To create new file To paste into a Word document or email message:

Adviсe:

Information in the section Result determined by the selected object type and checkbox state as an icon(installed or not). This information will help you decide what exactly you need to insert and in what form.

To change the data in an inserted object, double-click it.

Link or embed an existing file

To link or embed an already created object:

Embedded objects and related objects

Embedded objects become part of the Word file or mail message and, once pasted, are no longer linked to the original file.

Related objects can be updated when changing source file. Linked data is stored in the source file. IN Word file or mail message (target file), only the location of the source file is stored and a view of the associated data is displayed. If file size matters, use linked objects.

MS Word provides a number of keyboard shortcuts to make your office work faster. If you need to use MS Word a lot, then it is highly recommended that you learn some useful keyboard shortcuts -It will help you work quickly. you can click ctrl+b to make text bold, Ctrl+U to make text underlined. These keyboard shortcuts work in all parts of Microsoft Office like MS Excel, MS Outlook, MS PowerPoint etc.

However, by default, MS Word does not provide a shortcut to strikethrough a command. Even if strikethrough is a frequently used command, it's surprising that Microsoft didn't create keyboard shortcuts for strikethrough. But the good thing is that we can customize MS Word to create such a shortcut key combination. Today I will teach you how to install fast way to make the text strikethrough.

What is strikethrough?

Sometimes in a document, you don't need certain text, but you don't want to delete it. In such cases, you can strikethrough the text. A piece of text will remain in the document for later use (and even for later inclusion) but at the same time, the strikethrough will show the reader that the text is no longer relevant. It looks something like this: strikethrough

How to set the Strikethrough shortcut in MS Word

You will need to do the following process only once and after that, you will be able to strike out the text by pressing the selected key combination.

Open any MS Word document. You can even open blank document, and.

Press Ctrl+D to open the Font dialog box. This window shows font formatting options.

Now press Ctrl+Alt and holding both of these keys down press the plus key on the numeric keypad (Numpad).

The cursor will change to a carnation in the shape of one. Release the Ctrl + Alt keys and click on the Strikethrough option in the Font dialog box (shown as a red circle in the image above).

The Customize Keyboard dialog box will open. Place the cursor in the field Key new label printing and press the shortcut key combination you would like to set to strikethrough the option. I put it on Ctrl+Shift+S... You can also install it like this. Place the cursor in press - new key shortcut and press Ctrl+Shift+S.

MS Word will automatically capture the keys you press. You can use any combination of Shift, Alt, Ctrl and key With letter. If you press a key combination that is already assigned to some other command, MS Word will show you this information. Better not to overwrite the existing shortcut. Ctrl + Shift + is a good combo.

Click on the button Appoint to set the strikethrough shortcut.

Now, to check whether it works or not, type something into your MS Word document. Select the text and press Ctrl + Shift + S (or whatever combination you choose). Selected text will immediately be strikethrough.

I hope you found this little setup tip strikethrough label in MS Word useful. If you have any questions about this topic, please feel free to ask me through the comments section of this page. I will try my best to be helpful to you. Thank you for using TechWelkin!

Word, Outlook and Internet Explorer are probably the most commonly used programs on personal computer. Almost all PC owners know how to work with these applications, but most of them are familiar with only a small part of their capabilities. Consequently, the losses from the inefficient use of these programs are very high. We hope that the tips below will help you work faster and save valuable time.

Word

Compare documents side by side

You have probably encountered the problem of the difficulty of comparing two versions of the same document. Word 2003 introduced the ability to compare documents in side by side mode, which allows you to call two documents at once and scroll them simultaneously and separately, comparing certain sections of two documents.

Open two documents and select command Window => Compare Side By Side With... If you have only two documents open, they will be compared otherwise the program will ask you to clarify which documents need to be compared.

A floating panel appears to manage documents (Fig. 1). Pressing the left button changes the scrolling mode (turns on/off the simultaneous scrolling mode), and the right button allows you to return the window position to the position from which you started comparing documents.

Web pages with a minimum of redundant tags

When you save Web pages or send electronic messages in HTML format with help from Microsoft Word, additional tags are added to the document, which will allow you to use all the functionality of Word for further work with document.

In order to reduce the size of a Web page and e-mail message in HTML format, you can save data in a special filtered format (filtered HTML) in this case, unnecessary tags will be removed.

If you open a Web page saved in filtered HTML mode in Word, some of the functionality for further editing that document may be lost. For example, bulleted lists and numbered lists will be displayed, but the ability to modify them using Word will be lost.

Therefore, you should use the filtered HTML mode only at the final stage before directly translating into HTML.

All website elements in one file

Word 2003 introduced the ability to save all elements of a Web site, including text and graphics, in a single file. In order to use this opportunity, just run the command Save As and select item single file Web page. In this mode, encapsulation is performed, which allows, for example, to send the entire Web site as an e-mail message or an attachment to email. This format supported in Internet Explorer 4.0 and later.

How to add a title (title) to a Web page

The title appears in the title bar at the top of the window and also, for example, in the browsing history of the Web browser. If someone saves a link to your Web page, the title title appears in the personal list of person "s favorites list. In order to set the title, it is necessary by executing the command File => Save as Web Page, click on the inscription Change Title(Fig. 2) and type in the desired name.

How to optimize web pages for a specific browser

By saving a Word document as a Web page, you can optimize it for a particular browser.

Execute the command Tools => Options and in the panel of the same name, select the tab General, and in it the panel Web Option s. In the tab Browsers in field People who view this Web page will be using select desired version browser (Fig. 3). Listed Options enable (or disable) the listed features.

Reusing the Format Painter Feature

When you click on the icon Format Painter(copy format), the text formatting of the area where the cursor is located is copied. Now, if you select any area of ​​text, Format Painter applies the above formatting to it.

Many users are familiar with this feature, but what most don't know is that if you double-click the Format Painter icon, you can reapply the copied format as many times as needed, and this feature will be active until the Esc key is pressed.

Save All/Close All

If you hold shift key when choosing an item File menu V Word program, the menu composition changes. Instead of close function appears Close All, but instead Save — Save All(Fig. 4).

Line without bullet

While creating bulleted list in Word, a situation often arises when it is necessary to leave the next paragraph without a bullet. To do this, press the key combination Shift+Enter. On the next line when you click Enter, the new line will again be with a bullet.

For example:

How to use the right formatting when pasting

In the case of copying text from a document into Word, the latter automatically transfers the text with the formatting that took place in the document from which the copy is made. In order for the inserted text to have the same formatting as the Word document, use the command Edit => Paste Special => Unformatted Text(Fig. 5).

Formatting with a smart tag

After pasting text into any Office application, clicking on the smart tag opens a menu with a choice of formatting types, including the following options:

• Keep Source Formatting this will preserve the format that the text had in the source document;
• Match Destination Formatting the inserted data will be formatted according to the design of the document into which the insertion is made (Fig. 6).

How to add a description to your Word document

Document Properties is the information that Microsoft Word allows you to add to each document. This useful feature few people use it, but meanwhile, with its help, you can add a whole range of descriptions and instructions, which will be especially valuable if you work in a team. To add a description of a Word document, you need to call the Document Properties panel using the command File => Properties(Fig. 7).

Quick access to selected documents

Do you want to have fast access to a row Word documents? There is nothing easier! Execute the command View => Toolbars => Customize, select the tab Commands, chapter Built-in Menus and drag the icon work on the panel as shown in Fig. 8.

Now to add current document in the Work menu, just open it and click on the item Add to work menu(fig. 9) the current document will be added to the menu. You can remove it using the keyboard shortcut Ctrl+Alt+ Minus.

Insert line into document

Do you want to separate a paragraph with a line? Press the hyphen key three times and press the Enter and you will get a thin line. Press the underscore key three times and press the Enter get a bold line. And when you press the equal sign key three times and the Enter you will get a double line.

Calculator in Word

Did you know that a calculator can be added to the Word panel?

Execute the command View => Toolbars => Customize => Commands tab and place the Tools Calculate icon on the toolbar (fig. 10). Now, by typing some expression, selecting it and pressing the Tools Calculate button, you can get the result (Fig. 11).

To replace an expression with the result of a count, press the keyboard shortcut ctrl+v.

Continuous Zoom

To change the scale of the document, press the key ctrl and use the mouse wheel to zoom in until you get required permission. This is much more convenient than accessing the menu.

Outlook

Control spam filter in Outlook 2003

IN mail client Microsoft Outlook 2003 has a built-in spam filter that is designed to screen out unwanted messages and place them in a separate folder.

However, this folder needs to be checked and monitored from time to time so that a useful email is not recognized as spam.

The filter in Microsoft Outlook 2003 parses the formal attributes of a message and its body. When analyzing the formal attributes of a message, the filter uses black and white lists.

If you receive an unsolicited e-mail, click on it right click mouse and in the drop-down menu (Fig. 12) execute the command Junk Email => Add sender to the Blocked Senders List. E-mail messages from subscribers that are placed in Blocked Senders list, will be blocked and sent to the folder Junk E-Mail folder.

If, on the contrary, the program mistakenly places the letter you need in the folder Junk E-Mail folder, add this user to White list on command Add sender to the Safe Senders List henceforth it will not be blocked.

Threaded messages in Outlook 2003

The ability of Outlook 2003 to sort mail by discussion ( View => Arrange By => Conversation) allows you to quickly view messages and quickly delete junk mail. Organize the review of mail in the above way (Fig. 13), and you will see that there is a chain of earlier letters for many topics. This method display of correspondence makes it easier to find and delete outdated letters.

Save documents where you want

When you receive a message with an attachment and want to save it to disk, by default Outlook prompts you to save the attachment in a folder My Documents. If you save attachment files in a different location, you will need to change the destination each time. Adding a shortcut to the folder will help speed up the process. My Documents, sending to the desired folder.

Internet Explorer

How to restrict children's access to unwanted Internet resources

If you are faced with the task of restricting children's access to unwanted Web resources, then using Internet Explorer 6 you can set a password for access to such resources, as well as write a list of allowed and prohibited sites. In order to put a ban on uncontrolled access to Internet resources in

Internet Explorer, run the command Tools => Internet Options and select the tab Content(Fig. 14).

Activate button Turn on and in the panel that appears, select the tab Are common. In this tab, use the function Create a password. From now on, access to prohibited resources will require a password.

Change font size in IE

Simple but very helpful advice. Not all Web pages offer optimal font sizes, and fiddling with font settings every time is tedious. Press key ctrl, and by moving the mouse wheel you can increase or decrease the font size of the displayed text.

Open link in new window

What to do if you do not want to leave the current page, but at the same time want to see the link on it? When clicking on URL hold the key Shift in this case, the page will open in a new window.

How to change home page

Some programs set their page as the home page. To change the page from which the review should start, you must run the command Tools => Internet Options and in the section Homepage(Fig. 15) indicate the desired address or select an item With an empty.

URL Speed ​​Dial

If the URL you need to enter in the address bar is www.name.com, then you just need to type this name and press the key combination Ctrl+Enter.

Fast navigation between web pages

Fast moving between multiple Web pages is conveniently done by holding down a key Shift and mouse wheel.