Yongzhong Office integrates three major applications of word processing, spreadsheet and presentation production under a standard user interface; based on the innovative patented data object storage library technology, effectively solved Office The problem of data integration sharing between applications is "the first real Office". Yongzhong Office can run on many different operating systems such as Windows, Linux and MacOS. After the evolution of several major versions, Yongzhong Office's products are rich in functions, stable and reliable, can highly replace imported similar software, and have many innovative functions. It is an excellent domestic office software with independent innovation. It is understood that recently, when I used Yongzhong Office, I found a good stuff called “Mail Merge”, which can easily meet the needs of users.
In practical work, we often need to edit a large number of consistent formats, data fields are the same, but the data content is different, and each record is written separately, separately filled out documents, such as mail envelopes, payrolls, various notices, and so on. If you edit the prints one by one, although each file only needs to modify the individual data, once the number of copies is large, it becomes a very distressing thing. Of course, we can also leave room for it, and fill it out manually after printing, but it seems to be out of order.
So, is there any way to reduce the dull and repetitive work, and to show the superb file editing level to improve work efficiency? Recently, when I used Yongzhong Office, I found a message called “Mail Merge”. The good stuff, this feature can easily meet the needs of the majority of users. From the name of the mail merge, it seems to use mail, but it is not, its main role is file consolidation, is to first create a main document containing all the files shared content and a database containing change information, and then use this function Insert the changed information in the main document to form a merged new file. The synthesized file can be saved or printed. Of course, it can be sent by email. It depends on the personal needs of the user. After reading the above introduction, is it really amazing? Do you want to hurry to experience this magical function? Next, let's take the print student parent notice as an example to see the magic of this function!
一, establish a database
As described above, use the "mail merge" function to print the student parent notice, you must first have a database of changes, obviously this database is a list of respected parents! So, we should put This database is built.
Open Yongzhong Office, enter the parent of each student in the spreadsheet's worksheet and save it (be careful not to omit the title line in the table, so as not to find the merged domain name when the mail merge), after the completion of the work table.
Second, the establishment of the main document
In the text processing of the Yongzhong Office that was just opened, the establishment of a main document is a notification file for all parents. As long as we leave a space in each notice to fill in the name of each parent.
Three, mail merge
Now, after printing the documents of the parent notice, we can see Go to the Yongzhong Office & ldquo; mail merge & rdquo; function of the real face.
1. In the main document you just created, select “Drawup & Rarger; Letters & Mail & Rarr; Mail Merge” in the menu bar, and the “Mail Merge” dialog box appears.
2. Click the “Fold” icon to find the database you just created, select the cell data area (including the header line), and then click the “Extension” icon to return to “Mail Merge” Dialog, click the “OK” button. The Mail Merge toolbar is now displayed below the menu toolbar.
3. Place the cursor where you want to insert the item and click the "Insert Merge Field" drop-down menu (the corresponding option in the drop-down menu) The header lines in the spreadsheet are one-to-one correspondence, then click on the corresponding option in the drop-down menu until the operation is complete.
4. Finally click on the "Merge to new document" button in the mail merge toolbar, you will receive unexpected results - each student's parent notice becomes a new document, no longer needed We do any processing, it is very convenient and efficient, how about, don't try it soon?