Microsoft Office Tutorials and References
In Depth Information
Using Excel with
Office applications have complementary benefits.
Microsoft Word, for example, enables you to do just
about anything with words, while Excel provides a
more structured environment for working primarily
with numbers. Word includes a Mail Merge feature
with which you can merge information from Excel
into Word documents of your own design. Use Mail
Merge to create mailing labels, form letters, printed
envelopes, directories, and other useful documents.
Using Excel with Mail Merge has three major steps.
First, create an Excel list consisting of addresses or
other structured data. Second, access the list in
Word. Third, use Mail Merge to integrate the list into
your Word document.
You can use Mail Merge with letters, name badges,
CD labels, notebook tabs, business cards, and more.
On the Mailings tab, click Start Mail Merge and select
an option. Word automatically formats the output to
fit your purpose.
After you import your Excel list into Word, you can
use the Edit Recipient List option to edit it.
Create a list in Excel.
Save your document.
Close your document.
Open your Word document.
Click the Mailings tab.
Click Select Recipients.
A menu appears.
Click Use Existing List.