Strikethrough Shortcut keys for MS Word, Excel, Outlook. Insert an object into Word or Outlook Word excel microsoft outlook mail
Microsoft Office is a great package office programs from Microsoft Corporation. Microsoft Office includes popular programs such as Word, Excel, Access, Powerpoint, Outlook, as well as OneNote, Publisher, Groove, InfoPath and others. Each program from the package can be installed separately, or all at once. Word is the world's most popular text editor. Excel - good program to create and work with spreadsheets. Access is a powerful database application. Outlook - famous mail client... PowerPoint is an application for creating presentations. In this article, I will explain in detail how to install Microsoft Office 2007 on a computer. Installing Microsoft Office later or early versions is similar.
Let's start the installation. Run Setup.exe from the disk or folder where you have the Microsoft Office installer. Enter your 25-character product key in the window that appears. The key is indicated on the box with the disc, if you have a licensed Microsoft Office. If you downloaded pirated version from the Internet, the key can be found on the source website. Click Continue.
In the next window you will be asked to familiarize yourself with license agreement to use software Microsoft Corporation. Check the box next to "I accept the terms of this agreement" and click the "Continue" button.
Click the "Settings" button in the window with the choice of the installation type.
In the installation parameters, you can select which applications from the package should be installed on your computer. Click on each component and select from the "Component not available" list to unnecessary applications, or "Run everything from my computer" for the ones you want. See the picture below for more details. When you decide on the components, click "Install".
Wait for Microsoft Office to install. The installation process can take up to 20 minutes, depending on the selected components and the speed of your computer.
Click the Close button in the last window.
That's all, microsoft installation Office on your computer completed successfully. You can start Office applications from the Start menu - All Programs - Microsoft Office.
The interaction between Outlook and Word is perhaps the most prominent example working together... I have already mentioned above that as a post editor, the user can specify Microsoft Word.
Example 18.1. Word as a message editor
(In Outlook app)
\u003e Tools\u003e Options Message
Use Microsoft Word as a message editor
Use Microsoft Word to read RTF messages
As an example of using Word, consider creating a message that contains curly text and a diagram that illustrates the structure of this book.
Create a message using Word
There are two ways to create a message using Word:
- Launch Word, create a document, and choose\u003e File\u003e Send\u003e Message.
- Directly in the Outlook app by selecting the command > Actions\u003e New message with\u003e Microsoft Word (Fig. 18.1).
As you can see from the figure, the essence of the message has not changed, there are fields for entering recipients and the subject of the message, a signature and a panel Painting (Drawing), however, the toolbar has been significantly enriched Formatting (Formatting).
Figure: 18.1. Outlook message ( microsoft editor Word)
Insert curly text
So let's create first nice headline for our message using a WordArt object.
Example 18.2. Insert WordArt
\u003e Insert\u003e Picture\u003e WordArt
Select the desired label style OK
Text: \u003d Book structure Bold OK
(Formatting Panel) Center
As a result of our actions, a beautifully designed text with a yellow gradient fill to the center (fig.18.2).
To change the properties of this object, you can use the buttons of the toolbar of the same name. In our case, let's change the fill color from yellow to blue.
Figure: 18.2. WordArt text in message
Figure: 18.3. Dialog window Fill methods
Example 18.3. Change the properties of WordArt
(On the WordArt toolbar)
WordArt Format Color and Lines
Color Fill Methods ...
Gradient
One color Color1 Blue
Hatch type Center
Variants (Fig.18.3)
Insert a chart
The next step we are considering is inserting a diagram, by the way, which is one of the innovations in Word.
Example 18.4. Insert a chart
\u003e Insert\u003e Organization Chart ...
Select the type of chart (fig. 18.4)
Figure: 18.4. Dialog window Chart library
A placeholder appears in the message body to show 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 diagram
(Highlight the root of the diagram)
(In Organization Chart pane) Add Shape
AutoFormat
Select the Bump Gradient chart style
Now it remains to enter the text of the diagram. To do this, click once with the left mouse button on one of the plugs of the diagram and enter the appropriate text. The final version of the message, edited and formatted using Word, is shown in Fig. 18.5.
Figure: 18.5. Final message
After the message is created, it remains to fill in the fields To whom (That) and Theme (Subject), then press the button Send message (Send).
Comment
Since our message is being saved and sent in HTML format, some formatting elements may be lost or altered. Keep this in mind when creating messages in Word! Sometimes it is better to just attach created messages as an attachment.
Let us remind you once again that we are only considering here general principle collaboration between Outlook and other Office applications. In addition to inserting objects (there are many more than two), there are also forms, frames, styles, tables, fields ... The list goes on and on. The world of Microsoft Office applications is wide and truly multifunctional. Study it in parallel with Outlook and other existing applications. In the end, the road will be mastered by the walking ...
Sending a document along the route
By sending a document along the route (Routing) is called sending a document by e-mail colleagues in sequence. The sending sequence is called route of the document.
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 indicate the user for whom it is intended, for example, the project manager.
Example 18.6. Sending a document along a route
\u003e File\u003e Open ... (open the required document)
\u003e File\u003e Send\u003e Along Route. ... ...
Nashatyrev Anton To
Mokhovikov Oleg To
Message text: \u003d Dear colleagues! Read the attached document and give your thoughts and comments on what was written. Thank you in advance, Yegor Usarov.
in turn
Return at the end
Track status
Send message
Comment
During the execution of this program, dialog boxes Outlook security alerts about third-party intrusion 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, press the button Add to (Add Slip).
\u003e File\u003e Send\u003e Next Destination ...
Send document Anton Nashatyrev
To refuse to send a document along the route and generally disconnect the route, you need to click Clear (Clear).
Let's go back to the example. After the button is pressed Send message (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). Suppose that the first addressee (in our example, this is Anton Nashatyrev) is configured responsibly, i.e. and the attached document itself, and not only read it, but also enter its wishes and comments into it, and then send it to the next correspondent. Let's try to follow how this happens.
To open the forwarded document itself, the recipient only needs to double-click on the attached document icon in the message. Next, the recipient makes their changes to the document in the usual way. At the end of the work, he must send the document further along the route.
\u003e File\u003e Send\u003e Next Destination ...
Send document "Oleg Mokhovikov"
Figure: 18.6. Document mailing message
What happens after that? First, the message will be sent to the next addressee on the mailing list - Oleg Mokhovikov. He will be able to read the document with the changes already made and make his own. Second, the original sender will be notified of the movement of the document through the mailing list, because the dialog box Route (Routing Slip) checkbox was checked Track status (Track Status).
If all goes well, the document will move up the mailing list until the entire mailing list for that document is exhausted. The last addressee in the route will be asked to return the changed document to the initiator of the distribution, and thus the circle will close.
To speed up the process, you can send the document not one by one, but all at once. In this case, the merger of the changes falls on the shoulders of the sender.
Excel for Office 365 Word for Office 365 Outlook for Office 365 PowerPoint for Office 365 Publisher for Office 365 Access for Office 365 Visio Plan 2 Visio Professional 2019 Visio Standard 2019 Visio Professional 2016 Visio Standard 2016 Visio Professional 2013 Visio 2013 Visio Premium 2010 Visio 2010 Visio Standard 2010 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 OneNote 2016 Publisher 2019 Access 2019 OneNote 2013 OneNote 2010 Project Professional 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Publisher 2016 Access 2016 Language Options 2013 Project Professional 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Publisher 2013 Access 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Access 2010 Publisher 2010 Project 2010 Language Options 2010 Excel Starter 2010 Language options Language Options 2016 Office 2010 Project Online Desktop Client Project Professional 2013 Project Standard 2010 Project Standard 2013 Project Standard 2016 Project Standard 2019 Less
You can use the Office Language Options to add a language, select a display language for the user interface, and set a Build and Review language.
Language options are found in the Office Options dialog box under a section that you can open by clicking File> Options> Language... Display and creation languages \u200b\u200bcan be set independently. For example, you can have anything that matches the language of your operating system, or you can use a combination of languages \u200b\u200bfor your operating system, design, and Office UI display.
Adding a language
You can add display language or author language. The display language determines the language that Office uses in user interface - ribbon, buttons, dialog boxes, etc. The design language affects text direction and layout for vertical, right-to-left, and mixed text. The author's languages \u200b\u200balso include spelling checkers such as spelling and grammar dictionaries. (Your preferred design language is displayed in bold at the top of the list. You can change this by selecting desired language and choosing.)
To add a display language:
Please select File > Options > Language.
In chapter Office display language in section select Install additional languages display from Office.com.
Set display language and then select Install.
The added language appears in the list of Office display languages.
Open an Office app such as Word.
Please select File >Options >Language.
In section in section Office development and validation languages select Add language ....
Select your preferred language in the dialog box Add display language and then select Add to.
The added language appears in the list of Office development languages.
If appears next to the language name Available check , you can get language pack with validation tools for your language. If a Check not available next to a language name, validators are not available for that language. If appears next to the language name check installed, everything is ready.
Affordable testing.
Set your preferred display or author language
The preferred language is shown in bold at the top of each language list. The order of languages \u200b\u200bin the list is the order in which the languages \u200b\u200bare used by Office. For example, if you are using the display order in Spanish<предпочитаемый>, German and Japanese, and the Spanish language resources have been removed from your computer, the preferred display language is German.
To set your preferred language:
In chapter Office display language select the language you want from the list and then select Set as preferred.
Open an Office app such as Word.
Please select File > Options > Language.
In chapter Configuring Office Language Settings do one or both of the steps below.
By configuring the Office language settings, you can add a new language or choose the language to display Help and ToolTips.
The language options are in the dialog box Configuring Office Language Settingswhich can be opened by selecting File> Options> Language... The interface and help languages \u200b\u200bcan be installed independently of each other. For example, you can set up everywhere the same language as the operating system, or use different languages \u200b\u200bfor the operating system, editing, interface, and help.
Available languages Depends on the language version of Office and the optional language pack, LIP, and ToolTip languages \u200b\u200binstalled on the computer.
Adding a language
To add a language to Office programs, you must add an editing language. An editing language consists of type direction and spelling checkers for that language. Checkers include language-specific features such as dictionaries to check spelling and grammar. (The default editing language is displayed in bold at the top of the list. You can change this by selecting your preferred language and selecting Set as default.)
Open an Office app such as Word.
Please select File > Options > Language.
In the dialog box Configuring Office Language Preferences In chapter Selecting Editing Languages select the editing language you want to add from the list Add additional editing languages and press Add to.
The added language will appear in the list of editing languages.
If the column Keyboard layout indicated Not included, do this:
Windows Settings will open to the Language page. In the dialog box Adding languages dialog box windows settings select item Adding a language, select the required language from the list and click Add to.
Close the dialog Add languages in windows settings... In the Office dialog box, your language should appear as Switched on In chapter Keyboard layout In chapter Selecting Editing Languages.
If the column Spelling indicated Not installed, you may need to obtain a language pack or a user interface pack to install the spelling checker tools for your language.
To go online and get the required language pack, select the link Not installed.
Setting the default interface language and help
Interface and Help languages \u200b\u200bare used by Office to display interface elements such as menu items, commands, and tabs, in addition to the language in which the Help file is displayed.
The default language appears at the top of the list and is shown in bold. Office uses interface and Help languages \u200b\u200bin the order in which they appear in the interface and Help language lists. For example, if the list of interface languages \u200b\u200bcontains Spanish<по умолчанию>, German, and Japanese, and the Spanish language tools have been removed from the computer, the default interface language will be German.
Setting the default language
Open an Office app such as Word.
Please select File, Options, and then - Language.
In the dialog box Configuring Office Language Preferences In chapter Selecting Display and Help Languages select the language you want to use and then select Set as default.
Determine the interface language used by each Office application
If you are using multiple languages \u200b\u200band Office is customized to suit your needs, you can poll all Office applications to see which language is used as the default interface language in each.
In the dialog box Setting Office Language Options In chapter Selecting interface languages \u200b\u200band helpselect View interface languages \u200b\u200bfor each microsoft programs Office.
Setting the language for tooltips
Note: This feature is only available for the following Office applications: Excel, OneNote, Outlook, PowerPoint, Publisher, Visio, and Word. It is not supported for Office 2016 programs.
Tooltips are small pop-up windows that provide quick, context-sensitive help when you hover over an on-screen element, such as a button, tab, dialog box control, or menu. When you set the ToolTip language in one Office program, the selected language is preserved across all installed programs Office.
This feature is not available in Office 2016.
If the language you want is not listed, you may need to add additional language services. Please select How to get additional OSD languages \u200b\u200bfrom Office.com and follow the instructions to download and install.
Once the new tooltip language is installed, it becomes the default tooltip language.
Open an Office app such as Word.
Please select File > Options > Language.
In the dialog box Setting Office Language Preferences In chapter Choosing a language for tooltips select a language for the tooltips.
Notes:
For more information on tooltips, see the article
In addition to Outlook, the Microsoft Office suite of applications also includes such common applications as the Word text editor, electronic excel spreadsheets, a PowerPoint e-presentation application, and an Access database application.
All of these applications are independent and self-contained, but their joint use opens up truly unlimited possibilities in organizing office work. Using Outlook along with the 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) capabilities provided by the Outlook formatting bar, Word is capable of creating rich documents with a variety of styles and templates, containing embedded objects, etc. The interaction of Outlook and Word will be discussed in the first section of this chapter. ... Moreover, this section will cover a tool common to all Office applications - mailing 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 feature will be discussed in the second section of this chapter. Also, in this section, we will talk about a tool common to all Microsoft applications - placing documents in a shared folder;
- create meetings to participate in a PowerPoint electronic conference. The creation of an electronic conference is directly related to the use of the above Microsoft NetMeeting application (see section 11.5 "Net Meeting"). How PowerPoint works with Outlook will be covered 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
Interaction between Outlook and Word is perhaps the most common example of collaboration. I have already mentioned above that the user can specify Microsoft Word as the message editor.
Example 18.1. Word as a message editor
(In Outlook app)
\u003e Tools\u003e Options Message
Use Microsoft Word as a message editor
Use Microsoft Word to read RTF messages
As an example of using Word, consider creating a message that contains curly text and a diagram that illustrates the structure of this book.
Create a message using Word
There are two ways to create a message using Word:
- Launch Word, create a document, and choose\u003e File\u003e Send\u003e Message.
- Directly in the Outlook app by selecting the command > Actions\u003e New message with\u003e Microsoft Word (Fig. 18.1).
As you can see from the figure, the essence of the message has not changed, there are fields for entering recipients and the subject of the message, a signature and a panel Painting (Drawing), however, the toolbar has been significantly enriched Formatting (Formatting).
Figure: 18.1. Outlook Message (Microsoft Word Editor)
Insert curly text
So, let's first create a nice headline for our message using WordArt.
Example 18.2. Insert WordArt
\u003e Insert\u003e Picture\u003e WordArt
Select the desired label style OK
Text: \u003d Book structure Bold OK
(Formatting Panel) Center
As a result of our actions, a beautifully designed text with a yellow gradient fill in the center will appear (Fig. 18.2).
To change the properties of this object, you can use the buttons of the toolbar of the same name. In our case, let's change the fill color from yellow to blue.
Figure: 18.2. WordArt text in message
Figure: 18.3. Dialog window Fill methods
Example 18.3. Change the properties of WordArt
(On the WordArt toolbar)
WordArt Format Color and Lines
Color Fill Methods ...
Gradient
One color Color1 Blue
Hatch type Center
Variants (Fig.18.3)
Insert a chart
The next step we are considering is inserting a diagram, by the way, which is one of the innovations in Word.
Example 18.4. Insert a chart
\u003e Insert\u003e Organization Chart ...
Select the type of chart (fig. 18.4)
Figure: 18.4. Dialog window Chart library
A placeholder appears in the message body to show 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 diagram
(Highlight the root of the diagram)
(In Organization Chart pane) Add Shape
AutoFormat
Select the Bump Gradient chart style
Now it remains to enter the text of the diagram. To do this, click once with the left mouse button on one of the plugs of the diagram and enter the appropriate text. The final version of the message, edited and formatted using Word, is shown in Fig. 18.5.
Figure: 18.5. Final message
After the message is created, it remains to fill in the fields To whom (That) and Theme (Subject), then press the button Send message (Send).
Comment
Since our message is being saved and sent in HTML format, some formatting elements may be lost or altered. Keep this in mind when creating messages in Word! Sometimes it is better to just attach created messages as an attachment.
As a reminder, this is just a general idea of \u200b\u200bhow Outlook and other Office applications work together. In addition to inserting objects (there are many more than two), there are also forms, frames, styles, tables, fields ... The list goes on and on. The world of Microsoft Office applications is wide and truly multifunctional. Study it in parallel with Outlook and other existing applications. In the end, the road will be mastered by the walking ...
Sending a document along the route
By sending a document along the route (Routing) is sending a document by email to colleagues in a specific sequence. The sending sequence is called route of the document.
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 indicate the user for whom it is intended, for example, the project manager.
Example 18.6. Sending a document along a route
\u003e File\u003e Open ... (open the required document)
\u003e File\u003e Send\u003e Along Route. ... ...
Nashatyrev Anton To
Mokhovikov Oleg To
Message text: \u003d Dear colleagues! Read the attached document and give your thoughts and comments on what was written. Thank you in advance, Yegor Usarov.
in turn
Return at the end
Track status
Send message
Comment
While running this program, Outlook security dialog boxes may appear warning of 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, press the button Add to (Add Slip).
\u003e File\u003e Send\u003e Next Destination ...
Send document Anton Nashatyrev
To refuse to send a document along the route and generally disconnect the route, you need to click Clear (Clear).
Let's go back to the example. After the button is pressed Send message (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). Suppose that the first addressee (in our example, this is Anton Nashatyrev) is configured responsibly, i.e. and the attached document itself, and not only read it, but also enter its wishes and comments into it, and then send it to the next correspondent. Let's try to follow how this happens.
To open the forwarded document itself, the recipient only needs to double-click on the attached document icon in the message. Next, the recipient makes their changes to the document in the usual way. At the end of the work, he must send the document further along the route.
\u003e File\u003e Send\u003e Next Destination ...
Send document "Oleg Mokhovikov"
Figure: 18.6. Document mailing message
What happens after that? First, the message will be sent to the next addressee on the mailing list - Oleg Mokhovikov. He will be able to read the document with the changes already made and make his own. Second, the original sender will be notified of the movement of the document through the mailing list, because the dialog box Route (Routing Slip) checkbox was checked Track status (Track Status).
If all goes well, the document will move up the mailing list until the entire mailing list for that document is exhausted. The last addressee in the route will be asked to return the changed document to the initiator of the distribution, and thus the circle will close.
To speed up the process, you can send the document not one by one, but all at once. In this case, the merger of the changes falls on the shoulders of the sender.
Outlook and Excel
From the very beginning of the book, when creating a message, we set ourselves the goal of transferring not just text, but a table as the message body. Using Excel tools allows you to easily solve not only the problem of inserting tables, but also related components (for example, Excel charts).
As an example of how Outlook and Excel can work together, consider sending a message that contains a table showing the number of pages for each part of a workbook, and an Excel chart that graphically displays the percentage of each part in the workbook.
Create a message using Excel
As with Word, there are two ways to create a message. But if in Word we chose the second option (composing a message from Outlook), now let's look at sending the spreadsheet directly from Excel.
Figure: 18.7. Outlook Message (editor Microsoft Excel)
Example 18.9. Create a message using Excel
\u003e File\u003e Send\u003e Message
Include current sheet in message body
Subject: \u003d Statistics
Introduction: \u003d This message 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. At this stage, the table contains only text and no additional formatting.
Working with a table
Before sending a message containing a table, it is advisable to format it: highlight the header, underline borders, etc. But outlook features allow not only formatting the table, but also working on its logic. In Example 18-10, we added another row, “Total,” containing the sum of all pages in the book, and then styled the table accordingly.
If the text of the message does not fit in the cell, you can expand its borders. To do this, move the mouse pointer to the junction with the name or numbering of cells (the pointer will take the form of a double-headed arrow) and, while holding down left button mouse, move the boundaries of the column or row to the required distance.
Example 18.10. Working with an Excel spreadsheet
(Editing)
A6: \u003d Total
Wb Autosum
A1: Wb (Select while holding down the left mouse button)
\u003e Format > Autoformat ...
Figure: 18.8. Formatted message with Excel spreadsheet
Comment
In addition to using the automatic style, you can apply additional formatting using the buttons of the toolbar of the same name.
Insert an Excel chart
The next step to demonstrate the capabilities of Excel and how to use it with Outlook is to create a chart that graphically represents the data on the worksheet.
Example 18.11. Insert excel charts
\u003e Insert\u003e Chart ... Standard
Type Circular
Chart title: \u003d Outlook in original
Data Signature Shares
Figure: 18.9. The plotted diagram
Comment
If we had not selected the A2: B6 range before starting to draw the chart, we could have set it later, at the second step of the Chart Wizard. In this case, it is not at all 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, and the wizard dialog box will collapse so as not to interfere with the selection, and the formula will appear automatically.
Once inserted, the chart may overlap the table in use. In order to move the diagram, it is enough to select it and, while holding 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, except for the data circle itself, which turned out to be very small. To increase the plotting area of \u200b\u200bthe diagram, you must click on the invisible square, in which a circle and text explanations are inscribed (Fig. 18.9). A square box appears with selection handles in the corners. Hook these handles and drag, stretching the selection box until the circle is the size you want.
So, the message is completely ready for sending, it remains to enter the address of the message recipient and click the button Send 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 can have Excel installed. After sending and receiving messages, go to in folder Inbox (Inbox) and open the created message (Fig. 18.10).
Figure: 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 is that the diagram is exactly the same as the one created (format, data, etc.). The only thing missing is there is no signature, since we created our message from Excel, not from Outlook. This flaw could be corrected by executing the command\u003e Insert\u003e Signature\u003e Regards before sending.
Example 18.12. Insert signature
> Insert\u003e Signature\u003e 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: insert a signature or a number of additional notes, as well as add a background, add a picture, etc.
Exchange folder
Working with Exchange folders is as common to all Office applications as route mailing. The essence of this feature is in placing the active document in shared folders Microsoft Exchange server. Thus, the user, as it were, opens access to this document to all members of the working group.
Example 18.13. Send to Exchange folder
\u003e File\u003e Send\u003e Exchange Folder ...
Select a folder < Общая папка>
After the document is placed in the shared folder, each of the users can open it by clicking on the corresponding 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 demonstrate it both on a local computer and make a presentation on the network for the entire working group. The PowerPoint presentation is in HTML format and therefore requires only a browser for attendees to view Internet Explorer 4.0. Thus, the presentation can be carried out both company-wide 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, you must use a special server microsoft application NetShow Server.
The problem with any meeting is planning. Of course, for the conference, in addition to the speaker's desire, 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 presentation presenter can schedule a PowerPoint e-meeting like any other meeting using Outlook.
Figure: 18.12. Presentation and dialog Scheduling a broadcast presentation
Example 18.14. Broadcast scheduling powerPoint presentations
\u003e Slide Show\u003e Live Broadcasting\u003e Set Up & Schedule ...
Description: \u003d "Microsoft Outlook 2002 in original" (fig. 18.12)
Parameters ... Broadcast settings (Fig. 18.13)
Display mode Resizable
Assign ...
Enter or select a name:< participants in the presentation
Mandatory
Send message
(A dialog box appears notifying that the broadcast is scheduled)
Figure: 18.13. Dialog window Broadcast parameters
Comment
Switches Sound only (Audio only) and Video and sound It makes sense to install (Video and Audio) if the presenter's computer is equipped with a microphone and a video camera, and the participants' computers are equipped with equipment for playing audio and video. In our example, we do not assume this, so the checkbox is checked No (None).
The automatically filled in meeting form (Fig. 18.14) is identical to those discussed earlier, For more information, see Chapter 2, Calendar, and Chapter 10, Teamwork in Outlook.
Comment
The only prerequisite for direct broadcasting of the presentation to a wide audience is the presence of a computer connection to the network (global or local). Additional features can be omitted if technical conditions do not allow it.
After agreeing on the timing and composition of participants, you can proceed directly to the demonstration itself.
Figure: 18.14. Assembly form
Example 18.15. Live broadcast of the presentation
\u003e Slide show\u003e Live broadcast\u003e Start broadcast ...
When holding a scheduled conference, the presenter plans to broadcast it using the meeting scheduling interface in Outlook 2002. At the specified time, a meeting reminder window will appear on the participants' computers, where the participant will see a button, after clicking on which the introduction page of the presentation will be loaded (Fig. 18.15 ). The presenter controls the slide change. Participants' computer screens display the slides in the same way as a normal slide show.
Figure: 18.15. Main page of live presentation
During the presentation, attendees can have private discussions, pose questions to the moderator, 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 certain means for exchanging information among themselves. But besides the exchange of information, Outlook, like Word or Excel, is capable of creating 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 and publishing.
In this section, we will walk through an example of importing information from an Outlook address book into an Access database, and also creating a message containing the information you just imported.
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
\u003e File\u003e External Data\u003e Import ...
A type outlook files (The Import from Exchange / Outlook Wizard will start automatically)
\u003e Address Books\u003e Outlook Contacts Address Book
In the new table
(At this step, it is proposed to determine the parameters of the imported data and find out whether it is necessary to import them at all)
He import
Import to table: \u003d Contacts
Figure: 18.16. Microsoft Access table with imported data
After import, as expected, Access will show new table Contacts, containing information from the Outlook address book. The import result is shown in Fig. 18.16.
Working with Access Data Page
Consider the following example. Let's say that one of the project participants has created a database, the information of which is interesting, and maybe needed by other team members. There are several solutions for this problem, but we will focus on the option of sending a message containing an Access Data Page. In fact, the message contains just an HTML page with an ActiveX object that connects to the database and displays data.
Example 18.17. Create message with Access Data Page
\u003e Actions\u003e New Message Using…\u003e Microsoft Office\u003e Microsoft Access Data Page
(Access will open with a wizard New page data access)
Constructor
Data source selection: \u003d< Database\u003e
After the performed procedures, a page with a data grid will open. So, first of all, you need to place the 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, Contacts. Then enter the name of the message recipients 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 the command\u003e File\u003e Web Page Preview. A web browser opens with a loaded page, which will be displayed in the same way to the recipient of the message.
Figure: 18.23. Web page with data from Access
Using the buttons Back and Next, you can navigate the table data Contacts. Also, if you specify the appropriate access parameters, you can edit the table (add or delete records), organize data filtering, etc. But this is beyond the scope of this book.
Summary
So, in this chapter, we looked at how Office and Outlook can work together. Truly, when Outlook works together with the tools provided by Word, Excel, PowerPoint, and Access, you can create rich messages and organize more comfortable sharing and access to information.
- Word. Formatting the message. Using Word as your default editor. Sending a document along the route.
- Excel. Create message with table and diagram. Placing documents in public folders on the Exchange server.
- PowerPoint. Organize an online meeting to showcase your presentation.
- Access. Import data from Outlook into Access. Create a message containing the Access Data Page.
