If everything looks okay, you're ready to print the actual labels, To see what your finished pages will look like. Two more Next clicks will get you to the Printing dialogue box. Here you'll click Add Field and New Line until you get the sample label to look something like this:Īdditional formatting options, such as different font styles and colors, are available by clicking on Advanced. Now, assuming you plan to print a label for every name on the list, keep clicking Next until you arrive at Label Layout. Now a window will open and display all the Works databases you might have created. (Choose Avery 5160 for laser printers.) Click Next. If you plan to use today's most popular type of inkjet label (2 5/8" x 1" - 30 labels to a sheet) choose Avery 8160. Now a rather intimidating multiple-choice window will pop up - but don't let it scare you.
Use File, Save As to name this file ( Holiday Label Layout,įor instance). (Here's where you need the word processor.) Now let's format the printing of the labels. Here's how: Go to Record, Sort Records, and choose LastName, Ascending. To make the column widths match their data do Ctrl+A (select ALL) and go to Format, Field Width, Best Fit.Īfter you've typed in your data, your DB page should look something like the example below:Īt some point you'll probably want to Sort (Alphabetize) your data by Last Name. Choosing a smaller, narrower font also helps. This can help make all columns fit on a page. If you want to print out your database, it's best to do it "sideways" by going to File, Page Setup, Source, Size & Orientation, and choosing Landscape. By default, it will probably be saved in the C:\MSWorks\Documents folder or in the C:\My Documents folder - but you can designate any folder you want. Go to File, Save As, and name this file, say, Holiday Address List. Repeat this process for each Header and then click Done. In the Field 1 box type FirstName and click Add.
Launch Works and go to Works Tools, Database. Let's use the following six fields for our example: 1stName, LastName, StreetAddr, City, St, and Zip. A menu listing above the fields contains " Headers" (such as 1stName, LastName, StreetAddress, etc.). 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.Ī simple database is a grid comprised of rows and columns, which are called Records and Fields, respectively. 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.
MAIL MERGE FROM EXCEL TO ENVELOPES 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.
0 kommentar(er)
