同济大学：《大学计算机基础》课程教学资源（教案讲义）Mail Merge

Mail Merge

Mail Merge

Use of Mail Merge Send mails,test scores to many people Require a template(some data are different) Use the offered mail merge function A. Create data source B. Build the main document C. Merge the data source and the main document

Use of Mail Merge  Send mails, test scores to many people  Require a template (some data are different)  Use the offered mail merge function A. Create data source B. Build the main document C. Merge the data source and the main document

Step 1:Create data source Use Excel to create the data source C17 A B C D E No. Name Student ID School Year 2 20110001 Marco 112045 Medicine 5 3 20110002 Peter 113056 Urban Planning 5 4 20110003 Alice 110034 Electronics and Information Engineering 4 5

Step 1: Create data source  Use Excel to create the data source

Step 2:Build main document Main document(template) Example:admission letter Stamp of the university Watermark

Step 2：Build main document  Main document (template)  Example: admission letter  Stamp of the university  Watermark

Step 3: Use the mail merge function Insert data(from the source file)into the main document N records will result in N mails Operation:6 steps 米Demo

Step 3:  Use the mail merge function  Insert data (from the source file) into the main document  N records will result in N mails  Operation: 6 steps  Demo