如何用邮件合并功能成批制作带照片的工作证？

如何用邮件合并功能成批制作带照片的工作证？ 如何用邮件合并功能成批制作带照片的工作证, Preparation: prepare a candidate information database can be created by the Word data source, can be like the Excel workbook, Access database, Query file, Foxpro file, can be used as a data source for mail merge. As long as these files exist, there is no need to create a new data source for mail merge, and you can directly open these data sources. Note that when you use the Excel workbook, you must ensure that the data file is in the database format, that is, the first row must be a field name, and there is no blank line in the middle of the row. This will enable different data sharing, avoid duplication of work, improve office efficiency.. I Excel is the most popular book, which contains the field number, ticket number, name and other relevant information, to print photos then the bulk of the field path and file also need to add a photo of the name (if the photo file name is just the examinee's ticket number or name it free), assumption photos in a e:\photo folder, each candidate picture file name and ticket number corresponding to (if name words may have the same name problem). The correctness of the data preparation is related to the correctness of the printed documents, so it is necessary to proofread them correctly. The next job is to design the template for mail merge. The steps are as follows: 1. start the word program, and select tools - mail merge from the menu bar, which will appear in the mail merge helper dialog box; 2. in the "first step" to help the mail merge dialog box and click create document "in the drop-down button, select" form letters "(if you want to print multiple copies of it, on a piece of paper, and then select the" classification ") in the dialog box click the active window (A)" button. 3. in the mail merge helper dialog box, click the get data (G) drop-down button, and select open O..." In the open file dialog box appears, just open the saved Excel spreadsheet, click "OK" and in the pop-up dialog box, click the "Edit main document (M)", then you will find the toolbar more column mail merge toolbar 4. and then fill out the form of painting project layout, set the paper, then put the cursor where you want to insert the corresponding project location, click mail merge toolbar drop-down menu "Insert Merge field" (the title for the corresponding option in the drop-down menu and Excel data in the table are corresponding one by one), then the corresponding options click the drop-down menu, to insert all contains only text domain. 5. below is a key step in implementing batch printing of photos, which is the implementation of photo domains: First position the cursor where you want to insert a picture, press Ctrl+F9 to insert a domain, type "IncludePicture" e:\\photo\\ "(not including the lateral double quotes), and then press Ctrl+F9 to insert a field, enter" MergeField "ticket number", the cursor to the field after the input ".Jpg", "finally see the results should be: {IncludePicture "e:\\photo\\{MergeField" pass number "}.jpg"}. This is a good idea. You can't enter a path for each file after you use the pass number Now keep the cursor in the field and press Shift+F9 to translate the code to the result, that is, to display the picture. At this point, if nothing is displayed, don't panic, just press F9 to refresh the domain. In fact, you can also display the picture directly by pressing the F9 refresh field before pressing Shift+F9. But the picture doesn't seem to fit properly. Adjust it. 6., then click merge to the new document button, and then switch to the new document generated. "Hey, how come the photos don't have anything?" You can't be fooled, right? Don't worry, file (do not close the file and then open), press Ctrl+A to select, and then press F9, ha ha, candidates for each corresponding photos are not all out. ^ - ^ Wrong...... It seems that all the pictures seem to be pictures of the first person. Never mind, select the Word document, and then press F9 to refresh all domains. This picture should be replaced with the correct pictures, if not, perhaps Word BUG -- so that you put the documents preserved, closed, open, select, refresh F9. The problem with picture refresh is solved, but there is another problem, the picture size has become adjusted before. That is, the adjustments we have made after inserting the INCLUDEPICTURE domain are all invalid. Check the Word help documentation can be found, all domain code can have a switch to save the results: the format changes to domain MERGEFORMAT (watch in front of the is a must, "*" followed by a space). So, the INCLUDEPICTURE domain code above to {INCLUDEPICTURE "e:\\photo\\{MergeField" ticket number "}.jpg" the MERGEFORMAT} In the mail merge template, the F9 refreshes the display picture, adjusts the picture, merges it into a new document, and refreshes the entire domain -- OK, this time all in the adjusted format. In fact, insert a picture by using the domain is {IncludePicture "e:\\photo\\001.jpg"}, insert the ticket domain with the {MergeField "ticket" and the two}, a nested domain up to {IncludePicture "e:\\photo\\{MergeField" ticket number "}}.Jpg" so as to realize the initial request -- batch print photos. If you want to print in school, documents, archives, in ready database files under the condition of the corresponding design modifications to the main document template, can also realize it Yijuduode, don't look for special software to batch print photos. It is recommended to use Word2000 to insert text fields in Word 2003, which is annoying. Attached: use of the Word field of "INCLUDEPICTURE": Domain usage: {INCLUDEPICTURE, FileName, [Switches]} "FileName": the name and location of the graphics file. If it contains a longer space file name, please quote it in quotation marks. Such as "{IncludePicture D:\\Documents and Settings\\Administrator\\ Word \ \ desktop mail merge to achieve batch printing with photo ID \ mail merge [url=file://\\photo\\4220001.jpg]\\photo\\4220001.jpg[/url]"} Specifies the path (path: the path in which the operating system is used to locate a folder or file, such as C:\Manual\Art\Art 22.gif). Instead of a single slash, double slashes are used instead. For example: "C:\\Manual\\Art\\Art 22.gif."" Relative paths can also be used for file names in the IncludePicture domain. If {IncludePicture "mail merge [url=file://\\photo\\4220001.jpg]\\photo\\4220001.jpg[/url]"}, after the file is saved, you will find the corresponding file from the folder where the document is located. Relative paths is good as long as the template file contains word, database files and photos folder in a folder, then copy to any other one to install Office software on the computer can be printed with. The Switches switch is as follows: \c Converter specifies the graphical filter to use. The file name of the graphical filter does not have the.Flt extension. For example, enter picture to represent the filter file Picture.flt. \d graphics data is not saved with the document to reduce the file length. The MERGEFORMAT watch in front of the "*" is a must, and a space behind, all domain code has the switch, to save the results of domain format modification. Matters needing attention: 1. when inserting fields, the pair of braces that contain the domain code are not manually entered. You should use Ctrl+F9 to insert the field (at this point automatically insert the pair of braces that represent the domain) and fill in the domain code in it. 2., pay special attention to the quotation mark in the name of the document must not be wrong, or even add a blank space is not, otherwise, Word will not find the image file, only a red fork. For example, can not be written: {IncludePicture "e:\\photo\\{MergeField" pass number "}.jpg"}, because e: more spaces before. 3. finally, there is one point to note that the picture can only be used for mail merge only when the "embedded" format is applied. If you choose another format, though it is convenient to locate, you will not recognize it when you mail it. If you really need a flexible positioning, you can consider inserting a text box, remove the border and other properties, and in this text box insert INCLUDEPICTURE domain code, adjust the text box location