(See instructions for using Microsoft Works at the bottom of this page.)Ī simple database is a grid comprised of rows and columns, which are called Records and Fields, respectively. Although there are heavy-duty database programs available, such as Access, a spreadsheet program like Excel works just fine for this purpose.īetter yet, MSWorks comes with a database utility and a word processor built right into one program. Other databases might include all the parts in a particular car model.īut the DB most of us use is simply a list of friends and relatives, along with their addresses, phone numbers, email addresses, etc.
#AVERY WIZARD FOR MICROSOFT WORD 2003 CODE#
A mail-order business, for instance, might ask its DB program to display the names of all its female customers over age 40 who live in a certain zip code area and who bought something from them within the past year. It's basically a program which organizes various kinds of lists so they can be cross-referenced. The top of your Excel worksheet should look something like the following illustration: " Type First Name, Last Name, Street Address, City, State and Zip into the top row'sįirst six cells. Simple database if you use the top row as a " header row. Let's start by using Excel as the database.Įxcel, technically, is a spreadsheet program - but it also works fine as a However, the whole thing can be done in MSWord by using Word's " Table" utility as the database. In WordXP (Word 2002 or 2003) you can go to Tools, Letters & Mailings, Mail Merge Wizard, choose Envelopes or Labels and use the "wizard" prompts to complete the job.įor earlier versions of MSWord use the following instructions:Įxcel will be used to create the " database" of names and addresses, while MSWord will be used to format the printing of the labels or envelopes. Doing Envelopes & Labels with MSWord Two methods will be explained here:ġ Using Excel & Microsoft Word 2 Doing it all with Wordĭoing Envelopes & Labels with Microsoft Works