Bring "mail merge" with Yongzhong Office

  
                

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 technology, it effectively solves the data integration and sharing between Office applications. The problem 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 practice, we often need to edit a large number of consistent formats, the same data fields, but the data content is different, and each record is written separately, separately filled out, such as mail envelopes, payroll, various notifications and many more. 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 the work efficiency? Recently, when I used Yongzhong Office, I found a message called "Mail". Merging & rdquo; good stuff, this feature can easily meet the needs 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!

First, create 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 build this database.

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), complete After the worksheet.

Second, the main document

In the text processing of the Yongzhong Office that was just opened, a master document is created, which 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.

Third, mail merge

Now, print the documents of the parent notice is ready After that, we can see the true features of Yongzhong Office mail merge"

1. In the main document you just created, select “Tools & Rarr; Letters & Mail & Rarr; Mail Merge & rdquo; in the menu bar, then 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 the “Mail”. To merge the & rdquo; dialog box, 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 (in the drop-down menu) The options are one-to-one with the header lines in the spreadsheet, then click the appropriate 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 and you will receive unexpected results - each student's parent notice becomes a new document. No longer need us to carry out any processing, it is very convenient and efficient, how about, don't try it quickly?

Copyright © Windows knowledge All Rights Reserved