![how to do a mail merge in word 2007 for labels how to do a mail merge in word 2007 for labels](https://www.officearticles.com/img/content/word/mmlbls1.jpg)
Word-2007 uses a "Table" to lay out the grid lines. Click OK and Word-2007 will create a document that contains a template of the sheet of labels, complete with grid lines that indicate the labels that will be printed. In the Label Options dialog box that appears chooseĦ. 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. Now choose the ‘Select Recipients’ button and choose ‘Use. choose the kind of merge you want to run. On the Mailings tab, choose the ‘Start Mail Merge’ button, a list of different types of documents will drop down (i.e. If you want to print your Excel spreadsheet/database, it's usually best to do it "sideways" by going to Page Layout> Orientation> Landscape. In Word, open the existing file and press the ‘Mailings’ tab in the main menu.( 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. In my case I am going to use Avery US Letter. Now it's time for you to select the Label Vendor. Next, click on the Start Mail Merge button and select Labels. Now open up Microsoft Word 2007 and click on the Merge tab. 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). Before you start make sure you have your Excel spreadsheet ready.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. Scroll through entries & I hope we are sorted.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. The DATE field will be showing the date as mm/dd/yyyy REALLY ANNOYINGġ1) Click once on the DATE field (to highlight it)Įnter this text MMM yyyy" so that the field becomes:ġ3) VERY IMPORTANT: Note the lower case dd, UPPERCASE MMM, lower case yyyyġ4) Click preview results until the data shows. I think you are just not following the instructions precisely.ġ) Set up an xlsx file with two headings DATE and DATETEXTĢ) enter the a these 2 dates in the DATE column:ģ) enter this text in the DATETEXT column & don't let it format into a date:Ħ) Click mailings, Start mail merge & letters, Select Recipients & use existing list & select the list you just made & click OKħ) Click Insert merge field & click DATE & then OKĩ) Click Insert merge field & click DATETEXT & then OKġ0) Click Preview Results & jump through the 2 entries. Not sure why Microsoft have made this so complicated. How do you do this Martin? I'm pulling my hair out. The field you selected should now look like this: Step 2: Press Shift-F9 to make the field coding visible. Step 1: select the merge field you want to change.
How to do a mail merge in word 2007 for labels how to#
This tutorial will show you how to format date, currency and number properly in word during mail merge.įormatting date properly during mail merge in Wordįormatting currency and number properly during mail merge in Wordīefore we change the format of date, number and currency in mail merge, we need to apply following operations firstly. However, when we merge some mails, we should pay more attention to the format of date, currency and number. Mail merge is a useful tool to create a set of documents that are essentially the same but where each documents contain unique elements. How to format date, currency and number during mail merge in Word?