Word 2003: Mail Merge: Using an Excel Database for Mail Merge ... [PDF]

In addition to the features and functions of Excel that make your database useful, you can also use the database to merg

3 downloads 32 Views 84KB Size

Recommend Stories


How To Mail Merge PDF Documents
At the end of your life, you will never regret not having passed one more test, not winning one more

membuat mail merge dengan microsoft office 20071
At the end of your life, you will never regret not having passed one more test, not winning one more

Merge Sort
You often feel tired, not because you've done too much, but because you've done too little of what sparks

PERTEMUAN 11 Membuat surat dengan Mail Merge Microsoft Word Tidak jarang sebuah surat
Sorrow prepares you for joy. It violently sweeps everything out of your house, so that new joy can find

Merge Sort
Those who bring sunshine to the lives of others cannot keep it from themselves. J. M. Barrie

Merge Energy AR 2017.pdf
The happiest people don't have the best of everything, they just make the best of everything. Anony

Merge-In-Transit Retailing
The greatest of richness is the richness of the soul. Prophet Muhammad (Peace be upon him)

Map-Reduce-Merge
If you feel beautiful, then you are. Even if you don't, you still are. Terri Guillemets

Microsoft Office for Mac 2011 Tutorial: Use Mail Merge to create a form letter.docx
Never let your sense of morals prevent you from doing what is right. Isaac Asimov

Mergers Why merge?
When you do things from your soul, you feel a river moving in you, a joy. Rumi

Idea Transcript


Home LTS Help Desk Workshops Permission to Use

Microsoft Word 2003 Mail Merge: Using an Excel Database for Mail Merge In addition to the features and functions of Excel that make your database useful, you can also use the database to merge information into Word for large mailings. This means that you will not have to duplicate information you already have in your Excel database to perform a mail merge. NOTE: These instructions assume that you have an understanding of the Word Mail Merge process. If you need more information, refer to Mail Merge Wizard: An Overview.

Important: Before You Start The field names of your Excel database must begin in the upper-left corner of your worksheet, cell A1 (the first row and column). Navigating to your Excel data document is similar to selecting a Word data document. 1. Open a blank Word document 2. From the Tools menu, select Letters and Mailings » Mail Merge... The Mail Merge task pane appears. 3. Under Select document type, select Letters 4. Click NEXT: STARTING DOCUMENT 5. Under Select starting document, select Use the current document 6. Click NEXT: SELECT RECIPIENTS 7. Under Select recipients, select Use an existing list 8. To retrieve an existing recipient list, a. Under Use an existing list, click BROWSE... The Select Data Source dialog box appears. b. From the Look in pull-down list, locate and select the Excel workbook you will use for your list c. Click OPEN The Select Table dialog box appears.

9. If your Excel workbook has multiple worksheets, select the worksheet containing your list of recipients 10. Click OK The Mail Merge Recipients dialog box appears. 11. Select the recipient(s) you want to include in your mail merge NOTE: To edit the recipient information, refer to Working with the Recipient List. 12. Click OK 13. Click NEXT: WRITE YOUR LETTER 14. If you have not already done so, write your letter and insert the variable fields 15. When finished, click NEXT: PREVIEW YOUR LETTERS A preview of your first recipient appears. NOTES: For more information on editing the recipient information, refer to Working with the Recipient List. To remove a recipient from the mail merge, under Make changes, click EXCLUDE THIS RECIPIENT. 16. Click NEXT: COMPLETE THE MERGE 17. To print the letters, a. Under Merge, click PRINT... The Merge to Printer dialog box appears. b. Make the appropriate selection c. Click OK The Print dialog box appears. d. To specify the feedsource, a. Click OPTIONS... The second Print dialog box appears. b. From the Default tray pull-down list, make the appropriate selection c. Click OK e. To specify the printer, in the Printer section, from the Name pull-down list, make the appropriate selection f. Make any necessary adjustments g. Click OK To make changes to the letters, a. Under Merge, click EDIT INDIVIDUAL LETTERS... The Merge to New Document dialog box appears. b. Make the appropriate selection c. Click OK Make the appropriate changes in the new document that appear d. Save the document

LTS Documentation • OL 1105 • University of Wisconsin-Eau Claire • Eau Claire WI 54702-4004 Questions/Comments: [email protected] Updated: February 8, 2011 Copyright © 1995-2011 UW-Eau Claire and the Board of Regents of the University of Wisconsin System

Smile Life

When life gives you a hundred reasons to cry, show life that you have a thousand reasons to smile

Get in touch

© Copyright 2015 - 2024 PDFFOX.COM - All rights reserved.