Letters and mailings in word 2013
Formatting the finished job is where Word comes in. Keep in mind that any font selected here has nothing to do with the one to be used later on the finished labels or envelopes. To make the column widths match their data do Ctrl+A (select ALL) and go to Format, Column, AutoFit Selection. This can usually make all columns fit on a page.
![letters and mailings in word 2013 letters and mailings in word 2013](https://support.content.office.net/en-us/media/a3637dd7-6057-4df4-b8ad-0d8be5769a73.png)
If you want to print out your database, it's best to do it "sideways" by going to File, Page Setup, Page, and choosing Landscape. You can alphabetize your records by clicking on Data, Sort, Last Name, Ascending. By default, it will normally be saved in the My Documents folder, but you can designate any folder you want. Go to File, Save As, and name your database something like Address List.xls. Let's use the following six fields for our example: FirstName, LastName, StreetAddr, City, St, and Zip. A menu listing above the fields contains " Headers" (such as First Name, Last Name, Street Address, etc.). (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.
#Letters and mailings in word 2013 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.
![letters and mailings in word 2013 letters and mailings in word 2013](https://i.stack.imgur.com/WwOie.png)
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