Current location - Quotes Website - Personality signature - How to use the mail merge wizard to make greeting cards?
How to use the mail merge wizard to make greeting cards?
Making postcards by using word mail merge function Step 1: Prepare data source This data source can be Excel worksheet or MS SQL Server database, and any data that can be controlled by SQL statement operation can be used as data source. I take Excel as an example. The following figure shows an Excel worksheet with four data records. Our task is to print these four records into postcards according to the specified template. In order to facilitate later typesetting, the "Postal Code" column is set to text. Step 2: Prepare the template file (1), set the paper and locate the text. Here I take office Word 2003 and greeting cards with a length of 10cm and a width of 18.3cm as examples to introduce the specific operation methods. 1. Set the paper size. Open Word, select Tools → Letters and Mail, and select Show Mail Merge Toolbar, and mail merge will be displayed on the toolbar. Click the first icon on the left to set the document type, select "Envelope" and "Custom" as the envelope size, and set the width to 18.3cm and the height to 18. 2. Text positioning ① First locate the postal code of the recipient. Use a ruler to measure the distances between the left and top lines of the leftmost box of the recipient's postal code box and the left and top lines of greeting cards as 1.3cm and 1. 1cm respectively, and then measure the overall width of the postal code box as 5.4cm After obtaining the specific size, add a rectangular box in the upper left corner of the Word page, and right-click "customize graphic format" to enter. The font of postal code is set to 20 points bold (other fonts and sizes can also be set). Click Format → Paragraph to enter the Indentation and Spacing tab, select a fixed value in the line spacing column, fill in 18 in the setting value column, and set the alignment mode to scattered alignment. Tip: The value 18 in the column of "Set Value" is obtained by subtracting an estimated value from the point size of the font, so that the text in the text box is close to the upper edge of the text box. In addition, when measuring the size, you should add or subtract an estimate from the actual measured size, which depends on the font size you set, so that the text can be placed in the center of the text box. ③ Double-click the "Text Box" and set the fill color and line color as "No Fill Color" and "Wireless Bar Color" in the "Colors and Lines" tab; Enter the size tab and set the width to 5.4cm;; Enter the text box tab and set the inner margin of the text box to 0. Select the postal code text box, hold down the Alt key, and drag with the mouse until its upper left corner coincides with the lower right corner of the rectangular box. ④ Measure the distance from the left starting point of the first of the three lines to the left line of the greeting card by 7.3cm;; Then the distance from each line to the top of the greeting card is 4.9cm, 6. 1cm and 7.3cm respectively. Finally, measure the length of the three lines, all of which are 7cm. ⑤ Set the size of the rectangular frame in the upper left corner to be 7.3cm wide and 4.9cm high. Take the lower right corner of the rectangular box as the starting point, hold down the Shift key, draw a straight line, and double-click to enter the "AutoShape Format" with the width set to 7cm. After locating the first line, copy and paste the second line. Select the rectangular box again, set the height to 6. 1cm, and then move the left starting point of the line just pasted to the lower right corner of the rectangular box. Draw the third line in the same way. ⑥ Insert horizontal text boxes above three lines respectively. The width of the text box is the same as the length of three straight lines, the left and right positions are aligned with the straight lines, and the upper and lower positions are appropriate. The Alignment of the text in the text box is set to Center. Then set the three text boxes to "No Fill Color" and "Wireless Bar Color" by the method in step 3. Finally, delete the three auxiliary lines just drawn. Tip: When setting the fonts of three text boxes, you should consider the problem that the length of the recipient's address is uncertain. I adjust the text by manually adjusting and compressing its horizontal width. To compress the horizontal width of text, click Format → Font, and select the appropriate percentage in the zoom column of the Font Spacing tab. When it is less than 100%, the horizontal width will be compressed, and when it is greater than 100%, the horizontal width will be widened. ⑦ Finally locate the postal code of the sender. The distance between the right line of the word "code" at the lower right of the greeting card and the left line of the greeting card is 12.3cm, and the distance between the upper edge of the word and the upper edge of the greeting card is 8.4cm. After measuring the size, the postal code of the sender is located by locating the postal code of the recipient, but the "alignment" of this text box is changed to "left alignment" instead of "scattered alignment". After all the adjustments, the rectangular box used to assist positioning is deleted, which makes it much easier to show personality and add greetings because its position is more flexible. If you feel that the greeting directly entered in the text box is too monotonous, you can click "Insert → Picture → WordArt" and select the satisfactory WordArt in the "WordArt Library" window. In the Edit WordArt text window that appears, you can enter a greeting and set the font and font size. If your printer is a black-and-white printer, when choosing the type of wordart, you should pay attention to whether the selected font has any effect after being converted into black and white. If the artistic words can't meet the requirements, you can insert your favorite picture into the greeting by "Insert → Picture → From File". Friends with scanners can scan personal signatures and insert them; You can also use image processing software such as Photoshop to process greetings into ideal pictures before inserting them. Tip: I suggest not to insert pictures directly. Insert a text box before inserting a picture, and then insert a picture in the text box. This can avoid affecting the position of other characters when resizing the picture in the future. Step 3: Mail merge. Open the template file and select Letters and Mail from the Tools menu. Show Mail Merge Toolbar. After that, there will be an extra column on the toolbar, which is the mail merge toolbar, as shown in the red rectangular box in Figure 3. 1. Set the data source Click the "Set Data Source" button on the mail merge toolbar, select the "Historical Story" file, click Open to open the "Select Form" window, select the worksheet 1, and click OK directly to complete the data source setting. 2. Insert data field Place the cursor where you want to insert data, click the Insert Field button on the mail merge toolbar, select Postal Code in the pop-up window, click Insert, and then click Close. Repeat the above operation several times, and insert the address, name, title and greeting of the recipient in turn. 3. View the merged data Click the View Consolidated Data button on the mail merge toolbar (the button to the right of Insert Word Field in Figure 3) to view the merged data. There are also some buttons and input boxes on the toolbar to view the previous, next and specified records. At this point, the mail merge work is basically over, and you can print directly. You can choose "Merge into a new document" (only applicable to dozens or hundreds of records) to output this information into a Doc document, and then you can print it directly. You can also choose "Merge to Printer" (for hundreds or thousands of records) to print directly instead of generating a Doc document. Reprinted: /show.aspx? id = 206 & ampcid= 19