Click the Update Labels button to update all fields.Once the address is being displayed properly, click OK to place the ">" field into the first label.If the address is not being displayed properly, click the Match Fields button and change how the fields are being matched.Click the Address Block option in the Ribbon and verify the address is properly formatted.If the CSV file inserts properly, ">" should appear on each of your labels. In the Select Data Source window, point Microsoft Word to the location of your CSV file and click OK.After the labels are created, click the Select Recipients button in Mailings and then click Use Existing List.Search for xxxxx template, where xxxxx is the product number you are trying to find.
(Word updates all fields prior to printing.If your label product number is not listed, you can often download the template for your labels from the manufacturer's website.
To force this, simply select the entire document ( Ctrl+A) and press F9 or print the merged documents. This simply occurs because Word doesn't update the INCLUDEPICTURE field for each record it merges. Thus, your merged document will appear as if it contains multiple instances of the same picture. To speed things up, Word displays the same picture for each of the INCLUDEPICTURE fields. It is important to remember that after you perform your merge operation in Word, it may appear that your graphic merge didn't work properly. To create and print the mailing labels, you must first prepare the worksheet data in Excel, and then use Word to configure, organize, review, and print the mailing labels. The remaining INCLUDEPICTURE field is then translated by Word as a directive to include the noted picture. The mail merge process creates a sheet of mailing labels that you can print, and each label on the sheet contains an address from the list. When you create your merge document in Word, you can include a merge field such as this: The following is an example of such a file address:įor the purposes of this discussion, let's assume that you named the column PictureLocation. Microsoft has replaced this default setting by a new OLEDB connection method. In earlier versions of Word connection to the data file was by DDE. Each record in the worksheet should have a complete drive name, path, and file name (in a single column) for the graphic associated with that record. More Mail Merge with Excel as Database (Word) Mail Merge Labels with Word XP, Word XP changed things, you may have to read this document for doing special things. Just make sure you set up your worksheet so that it contains the file address of the graphic you want to merge.
For instance, you might have an Excel worksheet that contains a group of real estate listings. The key to merging graphics is to make sure that you don't try to merge the graphic itself, but to merge a field that "points" to the graphic file. There may be times, however, when you want to merge a graphic into your document.
Here’s how to fix it: For Word versions previous to 2007: Tools, Options, General tab. Word will display your dates, prices, and other numbers in an odd layout. This is a problem with the connection between Word and Excel. Normally the mail merge feature is used to merge text into a document-items such as a customer name or a part number. Word Mail Merge Is Messing Up My Numbers. The mail merge feature in Word is extremely powerful, and you can use it to easily create customized versions of documents from information in a data source (such as a Word table, an Excel worksheet, or an Access database).