際際滷

際際滷Share a Scribd company logo

mail merge

Download as PPTX, PDF
R
Rowena Marquez

The document provides instructions for a mail merge activity where students will create an orientation letter for progressive limited face-to-face classes at Malaga National High School. It includes a recipients table with sample contact information and a draft letter text to be used. Students are asked to follow steps to create a main document and data source file, set up the mail merge, and print the merged letters. The goal is for students to practice applying what they've learned about the elements and process of mail merge.

1 of 42
Download to read offline
May 24, 2022
mail merge
Malaga National High School School ID: 303645 REVIEW Identify the different parts of the Microsoft Word window. 1. 2. 3. 4. 5. 4. 6. 9. 8. 7. 10. 11. 12. Quick Access Toolbar Title Bar Minimize button Restore/Maximize button Close button Tab/s Ribbon Status bar Scroll bars Insertion point View button Zoom button
Malaga National High School School ID: 303645 LESSON OBJECTIVES Explain the elements of mail merge: main document and data source Exercise mail merge techniques to improve productivity Appreciate the advantage of using mail merge
Malaga National High School School ID: 303645 PICTURE ANALYSIS Photo source: http://www.clipartpanda.com/clipart_images/letter-carrier-clipart-1-65452131 https://www.baamboozle.com/index.php/study/571590
Malaga National High School School ID: 303645 Guide questions: Compare picture #1 with picture #2, what did you observe in the two pictures? Describe what else you see? What people and objects are shown? How do they relate to each other? What did you learn from examining this picture?
Malaga National High School School ID: 303645
Malaga National High School School ID: 303645
Malaga National High School School ID: 303645 Process Questions: 1.What was the video all about? 2.What is mail merge? 3.What are the elements of mail merge? Can you give examples where you can apply mail merge?
ROWENA Q. MARQUEZ
Malaga National High School School ID: 303645 Definition of Terms: 1. Productivity Tools -also known as productivity software are software that people use to create and produce professional quality documents, presentations, databases, charts, graphs, and more. 2. Mail Merge - is a word processing feature that allows you to easily create multiple letters, labels, envelopes, nametags, or catalogue documents to group of people as stored in a list in a database or spreadsheet. 3. Main document the letter which contain the email information for each of the merged document that can be letter, stationary or template. It also contains the field names which contains the instructions for carrying out the merge. 4. Data source it is also called data file which comprises the information to be merged into a document such as the list of names and addresses to be used in a mail merge. This must be connected to the data source before it can use the information in it. 5. Merge document this is also a word processing document that is the generated output after executing the merge process.
mail merge
mail merge
mail merge
ELEMENTS OF MAIL MERGE
mail merge
Fields Records
Main Document
Main Document Main document the letter which contain the email information for each of the merged document that can be letter, stationary or template. It also contains the field names which contains the instructions for carrying out the merge.
STEPS IN CREATING MAIL MERGE
Reminders
mail merge
mail merge
Letters 1
Select Use the current document 2
3 Select Type a new list Select Create
mail merge
mail merge
mail merge
EXAMPLE
4 Write your letter
Arrange your labels
5 letter 27
EXAMPLE
6 28
Activity: Hats Off to You! Directions: Step 1: Check under your chair. Those who have the hat under their chair, get the meta strip found inside the hat. Step 2: Identify the steps in the process or event. Step 3: Using a sequence chart, arrange these steps in sequential order. Steps in creating Mail Merge
Lets Practice! Problem: Mrs. Adnha P. Timagos, the school principal of MNHS, has asked you to send an orientation letter announcement for the progressive limited face-to-face classes. Create a folder in your desktop called MNHS Mail Merge. Save all files created in this activity into this folder. Start with a blank file and save it with the filename MNHS Letter. When you are working always Save your work as often as you can. Before doing anything, use A4 paper size. Select 1.15 Line and Paragraph Spacing. Font style should be Arial size 12. Margins should be at 1-inch all sides. Create the data file or the recipients from the table below. Save the data file with the name MNHS stakeholders. Save the file into the folder in Step 1.
Recipients Table Title First Name Last Name Position Address Hon. Merlyn Pore Brgy. Captain Brgy. Malaga, Calbayog City Hon. Harry Cabrigas Brgy. Captain Brgy. Tinaplacan, Calbayog City Hon. Renante Dura Brgy. Captain Brgy. Cagmanipis Sur, Calbayog City 5. Use the text below as the body of your letter. Follow the steps you have previously learned. 6. When you are done, save your work in the folder in step 1. 7. Print the merged document.
mail merge
When would you use Mail Merge? Fundraising letters Event Flyers Workgroup Notifications
mail merge
mail merge

More Related Content

mail merge

  • 3. Malaga National High School School ID: 303645 REVIEW Identify the different parts of the Microsoft Word window. 1. 2. 3. 4. 5. 4. 6. 9. 8. 7. 10. 11. 12. Quick Access Toolbar Title Bar Minimize button Restore/Maximize button Close button Tab/s Ribbon Status bar Scroll bars Insertion point View button Zoom button
  • 4. Malaga National High School School ID: 303645 LESSON OBJECTIVES Explain the elements of mail merge: main document and data source Exercise mail merge techniques to improve productivity Appreciate the advantage of using mail merge
  • 5. Malaga National High School School ID: 303645 PICTURE ANALYSIS Photo source: http://www.clipartpanda.com/clipart_images/letter-carrier-clipart-1-65452131 https://www.baamboozle.com/index.php/study/571590
  • 6. Malaga National High School School ID: 303645 Guide questions: Compare picture #1 with picture #2, what did you observe in the two pictures? Describe what else you see? What people and objects are shown? How do they relate to each other? What did you learn from examining this picture?
  • 7. Malaga National High School School ID: 303645
  • 8. Malaga National High School School ID: 303645
  • 9. Malaga National High School School ID: 303645 Process Questions: 1.What was the video all about? 2.What is mail merge? 3.What are the elements of mail merge? Can you give examples where you can apply mail merge?
  • 11. Malaga National High School School ID: 303645 Definition of Terms: 1. Productivity Tools -also known as productivity software are software that people use to create and produce professional quality documents, presentations, databases, charts, graphs, and more. 2. Mail Merge - is a word processing feature that allows you to easily create multiple letters, labels, envelopes, nametags, or catalogue documents to group of people as stored in a list in a database or spreadsheet. 3. Main document the letter which contain the email information for each of the merged document that can be letter, stationary or template. It also contains the field names which contains the instructions for carrying out the merge. 4. Data source it is also called data file which comprises the information to be merged into a document such as the list of names and addresses to be used in a mail merge. This must be connected to the data source before it can use the information in it. 5. Merge document this is also a word processing document that is the generated output after executing the merge process.
  • 19. Main Document Main document the letter which contain the email information for each of the merged document that can be letter, stationary or template. It also contains the field names which contains the instructions for carrying out the merge.
  • 25. Select Use the current document 2
  • 26. 3 Select Type a new list Select Create
  • 35. 6 28
  • 36. Activity: Hats Off to You! Directions: Step 1: Check under your chair. Those who have the hat under their chair, get the meta strip found inside the hat. Step 2: Identify the steps in the process or event. Step 3: Using a sequence chart, arrange these steps in sequential order. Steps in creating Mail Merge
  • 37. Lets Practice! Problem: Mrs. Adnha P. Timagos, the school principal of MNHS, has asked you to send an orientation letter announcement for the progressive limited face-to-face classes. Create a folder in your desktop called MNHS Mail Merge. Save all files created in this activity into this folder. Start with a blank file and save it with the filename MNHS Letter. When you are working always Save your work as often as you can. Before doing anything, use A4 paper size. Select 1.15 Line and Paragraph Spacing. Font style should be Arial size 12. Margins should be at 1-inch all sides. Create the data file or the recipients from the table below. Save the data file with the name MNHS stakeholders. Save the file into the folder in Step 1.
  • 38. Recipients Table Title First Name Last Name Position Address Hon. Merlyn Pore Brgy. Captain Brgy. Malaga, Calbayog City Hon. Harry Cabrigas Brgy. Captain Brgy. Tinaplacan, Calbayog City Hon. Renante Dura Brgy. Captain Brgy. Cagmanipis Sur, Calbayog City 5. Use the text below as the body of your letter. Follow the steps you have previously learned. 6. When you are done, save your work in the folder in step 1. 7. Print the merged document.
  • 40. When would you use Mail Merge? Fundraising letters Event Flyers Workgroup Notifications