Tuesday, April 19, 2011

This allows sharing different data and avoid

The four skills to merge Mail in Word
"Mail Merge"is an advanced feature of Word, is the basic technologies which office automation staff should master. But there is a very brief introductions about "Mail Merge" in most books. if you do that according to the books, the   mail merge print effects can not be completely satisfied. So, i will teach you a few tips of Mail Merge, hope it can help you to improve your office efficiency.
(1) Printing multiple messages with a page
we can use Word to batch processing and print messages. Our mail is very short and only need a few lines of the space in many case. However, we will use the entire page when printing, it's waste of paper as well as slow down the print speed. The reason for this is that each message has a "section break" so that the next message is assigned to another page. How can I print more than a short email within one sheet?Is actually very simple, the specific approach is to use Word's "Find and Replace command" in the Find and Replace dialog box, and then enter "^ b" in "Find what" box, then enter "^ l" in the "Replace" box , click "Replace All". After that you can print multiple messages in a sheet.
(2) To merge a different mail at one time
Sometimes we need to send the same or little different mail to different people. For example, if we send the "school report" to student's parents, we will writing different contents according to the difference of student's score. We will write "Learning model" on the report if the student's sore exceed 290, however, other reports haven't get this sentence. "How can we merge different mails by use the same documents and data source?". We may use "Insert Word" this time. We can insert "if ... then ... else (I) ...".in "Insert Word" to where the different area.
(3) Sharing various data sources
You can use many sources apart from the source created by Word when you merge the mail. The Excel workbook, Access database, Query File, Foxpro contents of the file can be used as the data source of mail merge. It;s no need to create a new data source as long as these files exist, you can open and  use these data sources directly. But you should pay attention to that: you must ensure that the data file is a database format when you use Excel workbook, the first line must be field names and there is no blank lines in the middle row . This allows sharing different data and avoid duplication.so you can improve your office efficiency.
(4) Filtering and sorting
With the "Query Options " in Mail Merge Helper, you can select filter records to merge and sort the record. You can improve your work efficiency when you remember they work

No comments:

Post a Comment