Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

At the end of the lesson the
students will be able to:
➢ Define what is hyperlink, macro, and mail merge
➢ Create hyperlink to an existing document, web-page, or
e-mail address
➢ Demonstrate how to remove and format the hyperlink
➢ Illustrate and how to record and run a macro
➢ Create a mail merge

What is a Hyperlink?
A hyperlink is a connection between an element
in a hypertext document such as word, phrase,
symbol, or image and a different element in a
document, another hypertext document, a file, or
a script
...


You can create hyperlink to
any of the following:
1
...

2
...
A specific location to another document or web
page
...
A location in the current document
5
...
Click your mouse on the location in the document where you
want to insert the hyperlink
...
On the Insert tab, click the Hyperlink button on the links
group
...
On the Insert Hyperlink dialog box, click Existing File or
Web Page and select the Filename where the source file is
located and then hyperlink will be created on your document
...
Press Ctrl + click on the Hyperlink to open the Linked File
...
Click your mouse on the location in the document
where you want to insert the Hyperlink
...
Type the website address of the website you want to
create the hyperlink
...
Click the Insert tab, go to the Links group and click
the Hyperlink button
...
On the Insert Hyperlink dialog box, click Existing file
or Web page and select the Filename where the source
file is located and then the hyperlink will be created on
your document
...
Press Ctrl + Click on the hyperlink to open the
website
...
Select the text or picture you want to display, click the Insert
tab, go to the Links group and click the Hyperlink button
...
On the Insert Hyperlink dialog box, click E-mail Address
...
Either type the e-mail address you want in the E-mail Address
box, select an e-mail address in the Recently used e-mail
addresses box
...
In the Subject Box, type the subject of the e-mail message
...
Highlight the text hyperlink you want to remove
...
Click the Insert Tab, go to the Links group and
click the Hyperlink button
...
On the Edit Hyperlink dialog box, click Remove
Link button
...

This bookmark and link feature will allow you to go to a specific location
in a long document, to avoid scrolling the many pages of a document
...
Click your mouse pointer in the location where you want to place the
bookmark
...
On the Insert Tab, go to the Links group and click Bookmark
...
On the Bookmark dialog box, type the bookmark name, which should
not have a space and then click the Add button
...
Highlight the text where you want to place the hyperlink
...
On the Ribbon, select Hyperlink
...
On the Edit Hyperlink dialog box, click the Place in This
Document and look for the bookmark you have created
...
Click OK and the text you have selected will turn blue with
underline which is an indication that the text has link
...
Click the text and you will be linked to the page that you
have bookmarked
...
An example is when
you want a product list in your MS Excel worksheet be linked to a
customer letter in MS Word
...

1
...

2
...

3
...

4
...

5
...


What is a Macro?
Macro allows you to record a sequence of
actions so that you will be able to use your
recorded macro on other documents
...
You
do not have to repeat the same process over
and over
...

2
...

4
...

6
...

8
...

Select the Record Macro on the drop-down list
...

On the Store macro in box, click the template or documents in which you want
to store the macro
...

Your mouse pointer will you show a recorder image to indicate that recording
has started and everything that you will be doing will be recorded
...

To stop recording your macro, click the drop-down arrow on Macros button and
select Stop Recording
...
On the View tab, click drop-down arrow of Macro
button
...
Select the View Macro dialog box click Run
...
On the Macro dialog box click Run
...
On the Macros dialog box, youcan also Edit or
Delete macros
...


Creating a Mail Merge
A data source is a file that contains the information to be merged
into your document
...
You must
create a data source first to be able to use mail merge for mass
mailing
...
Open the Word document that you want to mail merge
...
On the Ribbon, click mailings tab, go to the Start Mail Merge
group and click start mail merge and select step by step mail
merge wizard
...
The task pane will show the mail merge step 1 to 6
...
Choose from the options such as letters, E-mail
messages, Envelope, Labels or Directory
...
Click Next
...
Choose from the options such as Use the current
document, Start from a template or Start from existing
document
...
Click Next
...
If you have not created yet a recipient list, choose the Type
a New List and click Create and the New Address List
dialog box will appear where you can type in the names
and data of your recipients
...
Click New Entry to add additional names and after typing
click Cancel to close the dialog box
...
After you have entered your list, the Save Address List
dialog box will open
...
Type your file name and click Save
...
If you have previously created the recipient list
select Use and Existing List and Click Browse or Edit
Recipient List
...
The Mail Merge Recipients dialog box will appear
...
You can still add or remove names on the dialog box
and click OK
...
Click the address Block to specify the Address
Elements
...
Click the Greeting Line to set the greeting line
format
...
Click Next
...
The name, Address and greeting line will appear in the
document
...
You can click the Forward and Back arrows to view
other recipients in the list
...
You can also Edit Recipient List
...
To print directly, select Print
...
If you want to make adjustments on individual recipients, select Edit
Individual Letters

---