![]() ![]() = Record 4,5,6 on the top, Record 32,33 on the bottom, etc. = Record 3,4,5 on the top, Record 31,32 on the bottom = Record 2,3,4 on the top row Record 30,31 on the bottom row Now I go to UPDATE LABELS and the > shows up in the #2 and #3 label, and the #29 and #30 label for a total of five labels (1,2,3,29,30). Go to the Mailings tab, go to the Start Mail Merge section, click on Start Mail Merge, and slide down to Step by Step Mail Merge Wizard. ![]() You may start the mail merge process using the wizard. Upon hitting "Preview Results", I have the correct address showing in the first label space. It is not necessary to begin typing the form letter yet. I then highlight the whole label sheet (clicking on the little corner icon in the top left corner) and change the font to Arial Narrow, 11 point, so the print will fit). All 85 of my records show up in the little preview box. Select All and Click OK to merge the labels. The Merge to new document dialog box appears, so that you can select which records to merge. To merge on the screen, click Edit individual labels. I then go to ADDRESS BLOCK and match my headings for the merge. Click Next: Complete the merge Perform the merge In the Mail Merge task pane, verify that the Complete the merge step is displayed. The first label is blank and the other 29 labels have >. Mail merge from Excel to Word allows us to create and send. I then SELECT RECIPIENTS, go to "Existing User" and find my worksheet and open it. Want to learn how to mail merge from Excel to Word Step-by-step Mail Merge Wizard will teach us how to merge data from Excel to Word. Go MAIL>Start Merge, and choose "Label" and select my label (Avery 5160). I go to WORD 2007 and open a new document. I have an EXCEL 2007 worksheet (name, address, city/state/zip as headings) saved with 85 records. ![]() Okay, I've been working on this all day and feel like I'm trying to learn brain surgery. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |