ISB 11C, SY 2024-2025 September 2, 2024
Microsoft Word Exercise 2 – Mail Merge Word Exercise 2: _____
Instructions:
1. Reproduce the letter found on page 3.
2. Use normal margins, single spacing, and ”0 pt” spacing before and after paragraphs.
3. Use Font Calibri, size 11 for the entire document, except “(Please Pay on or before Jul 27)”
which is size 7.
4. Skip two lines between the letterhead and “Statement of Account”
5. Center the “Statement of Account”.
6. Allocate 3 lines for Inserting the Merge fields.
7. Skip one line between Merge fields and Bill Number.
8. Use Styles-Intense Emphasis for the letterhead. Styles Normal for rest of the document.
9. Insert Globe logo image. Image size: height is 0.65 and width is 1. Text-wrapping is Square.
10. Insert a table after the “Account Number”. Table width is 6.5 inches. First column is left aligned
and second column is right aligned.
Table cell size: Row height = 0.25
Column width = 3.25
Vertical alignment = center
11. Skip two lines between the table and “Statement Summary”, and one line between “Statement
Summary and “Previous Bill Charges”.
12. Insert line after “Previous Bill Charges” and “Current Bill Charges”. Line width size is 6.5, and
shape style is Colored outline-dark.
13. Insert line after “Less: Payments (Thank You)” and “VAT”. Line width size is 6.5, and shape style
is Dashed outline-dark.
14. Insert a text box four lines after the “TOTAL AMOUNT DUE”. Text box built-in name is Sticky
Quote. Height = 1.42, Width = 7.5.
15. The font of the text inside the textbox is Bradley Hand ITC, size 11, and Centered)
16. Bold the following words and phrases:
Statement of Account
Statement Summary, Amount (same line)
Previous Bill Charges
Current Bill Charges
TOTAL AMOUNT DUE, 984.28 (same line)
What’s New
17. Insert a footer built-in name Sideline, and type your FamilyName, FirstName, Subject and
Section.
18. Create a data source. Click Mailings tab, Start Mail Merge group, Select Recipients, Type New
List; Customize the columns. Delete the following columns:
Company Name
City
State
ZIP code
1
ISB 11C, SY 2024-2025 September 2, 2024
Microsoft Word Exercise 2 – Mail Merge Word Exercise 2: _____
Country or Region
Home Phone
Work Phone
E-mail Address
19. Add new column called “Account Number” and click OK.
20. Encode the list found on page 4, and click OK.
21. In the Write & Insert Fields group, insert the fields in the respective parts of the document.
22. Preview the document if all the recipients have been merged.
23. To print, use Mail Merge. (Please disregard this part)
a. Click Mailings tab, Start Mail Merge, Step by Step Mail Merge Wizard
1. Step 1 of 6: Choose Letters, Next
2. Step 2 of 6: Choose Use current document, Next
3. Step 3 of 6: Choose Use an existing list
4. Step 4 of 6: Position your cursor one line after the letter head and click the
Address Block, OK
Position your cursor on the right most side of the line where you could see
the “Account Number”, and click More items, choose Account number, click
Insert, Next
5. Step 5 of 6: Preview your letter, Next
6. Step 6 or 6: Print your document.
b. Save your work as <FamilyName, FirstName, WordExer3 Bill Statement> and upload in
SOUL.
2
ISB 11C, SY 2024-2025 September 2, 2024
Microsoft Word Exercise 2 – Mail Merge Word Exercise 2: _____
Globe Telecom
Robinson Place
Calindagan, Dumaguete City
Statement of Account
Hon. Felipe Remollo
City Planning and Development Officer
Dumaguete City
Bill Number 14
Bill Period 07 Jun 23 to 06 Jul 23
Account number <<Account Number>>
Previous Balance 0.00
Current Balance 984.28
(Please Pay on or before Jul 27)
Total Amount Due 984.28
Statement Summary Amount
Previous Bill Charges
Amount Due from Previous Bill 984.28
Less: Payments (Thank You) (995.00)
Remaining Balance from Previous Bill (10.72)
Current Bill Charges
Monthly Recurring Fee (MRF) 888.39
VAT 106.61
Total Current Bill 995.00
TOTAL AMOUNT DUE 984.28
What’s New
Ang IDD calls per second na ang charge for all Globe Landline residential subscriber! You can now call USA,
Singapore, Australia, Saudi Arabia, Canada, Hong Kong, Hawaii, China, United Kingdom, South Korea, Malaysia,
Thailand, Taiwan, Kuwait, and Equatorial Guinea for only P0.75 per second. Just dial 12800 + (country code) + (area
code) + (phone number). Call 730 – 1000 for more information.
3
ISB 11C, SY 2024-2025 September 2, 2024
Microsoft Word Exercise 2 – Mail Merge Word Exercise 2: _____
Subscribers List
1. Dr. Ben Malayang III Account Number: 745-783
Hibbard Avenue
Dumaguete City 9. Prof. Mylah Bomediano
Account Number: 876-234 Amlan
Negros Oriental
2. Dr. Betty McCann Account Number: 729-193
Taclobo
Dumaguete City 10. Dr. Ofelia Ragpa
Account Number: 549-285 Bajumpandan
Dumaguete City
3. Prof. Jane Annette Belarmino Account Number: 346-822
Silliman Heights
Dumaguete City
Account Number: 897-601
4. Prof. Lauro Silapan
San Jose Street
Dumaguete City
Account Number: 787-380
5. Atty. Eduisa Diocos
Sibulan
Negros Oriental
Account Number: 653-901
6. Atty. Jennilene Lorico
Banilad
Dumaguete City
Account Number: 498-209
7. Prof. Nasser Acuram
Dipolog
Zamboanga del Norte
Account Number: 371-790
8. Prof. Romyr Dellona
Dauin
Negros Oriental
