Download Computer Science Useful Resources
Explore structured advanced study materials through the Digital Documentation Session 05 Implement Mail Merge Notes Set 01. Tailored for learners, utilizing these Computer Science resources ensures thorough preparation and strengthens foundational knowledge before final evaluations.
Access Study Guides and Summaries
Access the complete useful resource PDF for Computer Science below. Regular practice with these targeted academic notes builds familiarity with complex topics and helps secure higher marks in final school evaluations.
This page introduces mail merge in Writer for sending the same letter to many people with different names and addresses. It covers planning the letter fields, registering a spreadsheet, text file or Access data source, dragging fields into the letter, and editing saved mailing labels.
Mail Merge
Mail Merge: The automatic addition of names and addresses from a database to letters and envelopes in order to facilitate sending mail, especially advertising, to many addresses.
You can use Mail Merge in printing letters for multiple users with different names and addresses at the same time.
Create a Mail Merge Document: Letter
Open a template, if you have one you want to use, or create a new Writer document.
Save the document with the appropriate name, like mailmerge_parents.odt.
Write out the text that will be going to everyone, and plan where you want the fields. For instance, you might know that you are going to have an address block at the top of the letter, so you’ll leave a few blank lines for that. Then you’d write something like the following, knowing that you’d add the fields firstname and years_of_service later:
Dear (firstname field),
Remember that next month is open enrollment for benefits. Employees with over five years of experience are also eligible for sabbatical; you have been with us for (years_of_service field) years so please get your application in early if you plan to apply.
Regards,
Human Resources
If you’re doing anything complex and this is your first mail merge letter, write out the letter completely as you want it to read including sample data. Use all the text, including samples for firstname, lastname, etc. This will help you determine which fields you need to use, where you need spaces before and after fields, etc. In the following example, for instance, if you want to communicate this, you’ll need to use fields from the database for title, lastname, childs_name, study_area, and test_score.
Dear Ms. Smithson,
Your child Jenny is such a joy to have in the classroom. Her score on her Social Studies test last Friday was A-.
Regards,
Mr. Thomson
Once you have the letter written out and you know what fields you need, you can delete the specific data like “Ms. Smithson” and insert the fields from the database instead.
Making the Data Source and Entering Data
OpenOffice is set up with a middle-man file in the mail merge process to make merging work easily. You’ll create a small file, one for each spreadsheet or other data source. Once you create it, you don’t have to do it again.
Choose File > New > Database. Select the type of data: spreadsheet data, text file data, your particular type of address book, or the type of database you’re using like Access or MySQL. It’s very important to select the right type. Click Next. What you do next depends on what you chose as the type of data you’re working with.
Spreadsheet
Click the Browse button and find the spreadsheet containing your data. Then click Next and continue to the next step.
Text File
Click the Browse button and find the directory containing your text files. Fill out the rest of the information: specify the type of files you want to access, that is, whether the file name ends in .txt or .csv.
Microsoft Access
Click the Browse button and find the .mdb Access file containing your data.
In the next window, just be sure to keep the option for registering selected. Unmark the selection to open the database for editing unless you want to see the database editing window. (You don’t need to unless you want to make a query or other database-related item.)
Click Finish. You’ll be prompted to save the database file. Name it something very descriptive; this is the name you’ll be looking for when you’re adding database files to your mail merge documents.
You can see your databases by pressing F4 when you’re in a Writer or Calc document. Click the + icon next to the database you created to see the items named Queries and Tables. Click the + next to Tables to see the tables you created; select a table to see the data in it. When you’re done viewing your databases, press F4 again to hide the panel.
You’re done creating the database file. You only need to do this once for every spreadsheet, database, or directory of text files.
Merging the Data Source with the Main Document
Open the letter you want to use.
Once you have the letter written out and you know what fields you need, you can delete the specific data like “Ms. Smithson” and insert the fields from the database instead. Press F4. Click the + next to the database you want, then click the + next to Tables and the + next to the table you want. Now just drag the field you want into the letter, to the place you want it.
a. Click and hold down on the name of the first field you want. Don’t click on the data, like Smithson; click on the name of the field, like lastname.
b. Drag the field name into the letter to the place where you want it. The mouse pointer will have a + attached to it.
If you didn’t get it exactly where you want it, just select it, and cut and paste it to the place where you want it. The easiest way to select a field is to click on the right side of it, hold down the Shift key, and press the left arrow key once. Then it’s selected and you can cut or copy.
Drag in all the other fields you want, the same way. If you want a field in the letter twice, you can drag it twice, or drag it in once, then copy and paste it to the other location.
The fields should display with a gray background. It won’t print; it just helps you see which text is from the database and which text you typed. Format the document any way you want it. The fields respond to formatting the same way that normal text does.
You’re done creating the mail merge document. You only need to do this once. The next step is to either print the letter to a printer, or “print” to a Writer file so you can see all the data merged, and so you can customize, before printing on paper.
Editing a Saved File of Mailing Labels
To edit a saved file of mailing labels, open the saved label file in the normal way. You will be prompted to update all links. Choose No for the following reason: The first label on the page is termed the “Master Label” and all other labels are linked to it. If you update the links, then all labels will end up containing the same data, which is probably not what you want. You can edit individual records in the normal way, by highlighting and changing the font name, for example.
Free study material for Computer Science
CBSE Computer Science Study Material: LibreOffice Writer Word Processing
Core Study Kit: Computer Science LibreOffice Writer Word Processing
Explore essential learning tools for Computer Science LibreOffice Writer Word Processing. This curated collection features in-depth notes and targeted practice questions built around the active 2026 curriculum to streamline your daily revision.
NCERT-Aligned Solutions for LibreOffice Writer Word Processing
Designed around the official curriculum, these study guides guarantee standard compliance. Reviewing step-by-step solutions clarifies complex sub-topics within LibreOffice Writer Word Processing and demystifies standard marking schemes for Computer Science evaluations.
Next Steps in Your Exam Preparation
Maximize your grade potential by utilizing Computer Science practice papers in tandem with these structured notes. All printable assignments and interactive mock tests on our platform are updated for the 2026 session and available free of charge.
FAQs
The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.
Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.
Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.
in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.
All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.
Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.