microsoft word for mac 2011 mail merge word and excel

Use “friendly” column headers such as First Name, Last Name, Address, and City instead of Column 1, Column 2, Column 3, and Column 4.When setting up your address list in Excel, consider the following tips: Each merge field corresponds to a piece of the address on the label-first name, last name, street address, and so on. Word pulls out the information in your Excel columns and plugs it into the corresponding merge fields, with an end result that looks something like this: The key thing to understand is that your column headers, or categories, in Excel will become merge fields (placeholders) in Word. If you get this part of the process right, things will run more smoothly when you’re setting up your labels in Word. This post is about that first step-the one where you prepare your address list in Excel so that you can use it in Word. Learning how to make your Excel address list magically show up on your sheets of labels boils down to five basic steps: And if you create labels infrequently, it’s hard to remember what to do and what to watch out for.

PPT To Image PPT To HTML PPT To PPTX Image Converter.Hey, the holidays are fast approaching, which means you’ve got to get your cards signed, sealed, and delivered! This post goes out to those of you who keep your address list in Excel and need to figure out how to use it to create mailing labels in Word.Ĭreating labels can be intimidating, mainly because there are a number of intricate steps to follow and you’re typically working with different programs-in this case, Excel and Word. Excel To Image Excel To Word Excel To Html Excel To Txt Excel Encrypt Merge Excel Combine WorkSheet Excel Replace Text PPT Convert. Word To Image Word To HTML Word Split TXT To Word/HTML Word Watermark Merge Word Word Replace Text Excel Convert. I want to create 5500 PDF files with a field in the excel field (merge field) as the name of each PDF file. I created a mail merge with 5,500 records. I have a Micro soft Word Mail merge using Microsoft Excel as the data source. Let’s make sure you have the supporting files installed in the correct location. The Word converter for Excel files is included with the Office package. This should be very straight forward, meaning if you have an Mac Excel 2008 (.xlsx) file as your mail merge data source, Mac Word 2008 will convert the file and use it as your data source. For more info on using the dialog box, see Edit Data Source. In the New Address List dialog box type recipient information in each column as appropriate. Choose Select Recipients Type a New List.

Microsoft word for mac 2011 mail merge word and excel