On the Mailings tab, in the Start Mail Merge group, clickĥ. Launch Word-2007 and a blank document will open.Ĥ. Now that you have a spreadsheet/database of names and addresses in Excel-2007, you will use Word-2007 to format the actual printing of the labels. Another way to AutoFit columns on a worksheet is to double-click any boundary between two column headings.Īfter you've typed in your data, your database page should look something like this:.To make the column widths match their data do Ctrl+A (select ALL) and go to Home> Cells> Format> AutoFit Column Width. Choosing a smaller, narrower font also helps. This can help make all columns fit on a page. If you want to print your Excel spreadsheet/database, it's usually best to do it "sideways" by going to Page Layout> Orientation> Landscape.
( If you don't see extensions on any of your file names - such as. By default, it will be saved in your My Documents folder. Name the document something like Holiday Address List. Click on the Office Button and choose Save As> Excel Workbook. A simple database is a table of rows and columns, which are called "Records" and "Fields." A row above the fields in our databese will contain "Headers" (such as FirstName, LastName, StreetAddr, City, State, and Zip).We'll start by creating a "database" of names and addresses using an Excel-2007 spreadsheet. Therefore, this tutorial is a simple and straightforward set of instructions for placing the names and addresses in an Excel-2007 file, followed by formatting the actual print-outs of the labels with Word-2007. The type of mailing list I receive the most questions about is a collection of friends and family to whom a person wants to send holiday greeting cards. This tutorial is intended for Microsoft Office 2007 users who have a list of names and addresses for which they would like to print adhesive mailing labels.
0 kommentar(er)
