How to Mail Merge Pictures: INCLUDEPICTURE in Microsoft MS Word

Loading...

Merge Images Merge Barcodes Merge PDFs Store How-To Free Trial









"I'm using OnMerge mainly for picture name badges (for the church I attend) and it is working very well." Alan F

IncludePicture How-To: Mail Merge Variable Images, Pictures, Photos with Microsoft® Word Do you need to mail merge photos and images to create a directory, catalog, or a bunch of letters with many different photos, signatures, logos, and so forth? This article shows 2 alternatives: the classic IncludePicture field built into Word, and the OnMerge Word Add-in which greatly simplifies the process.

Step-by-Step How-To Using INCLUDEPICTURE

Alternate OnMerge Images Step-by-Step

Checklist Before You Start

Checklist Before You Start



OnMerge Images is a Word add-in that replaces IncludePicture, does much more. It makes merging images easy—fun, even.

IncludePicture is FREE, but finicky. Very. So: breathe. Set aside some time to follow the procedure below exactly. Looks simple, but you have to get everything exactly perfect.

Make sure the OnMerge Images is installed in Word. Download free trial version here.

IncludePicture Step By Step

OnMerge Images Step By Step

1

Name the picture or image files the same as (keyed to) the contents of a field in the database. For example, if you have a database which includes a “FirstName” field, you might name personnel photos “John.jpg,” “Mary.jpg,” and so forth. The key to variable images is to have a collection of photo or image files in a folder on your computer or network.

Name the picture or image files the same as (keyed to) the contents of a field in the database. For example, if you have a database which includes a “FirstName” field, you might name personnel photos “John.jpg,” “Mary.jpg,” and so forth. The key to variable images is to have a collection of photo or image files in a folder on your computer or network.

2

Save As the document in the Word 97 - 2003 (.doc) format -- NOT the Word 2007 (.docx) format. IncludePicture does not work in .docx documents due to a bug in Word.

Use the .doc or .docx document formats. Both are fine.

3

Select the data source (database) into the master document you’ll be working with using Mailings + Select Recipients + Use an Existing List.

Select the data source (database) into the master document you’ll be working with using Mailings + Select Recipients + Use an Existing List.

4

Place the cursor where you want to position your image.

Place the cursor where you want to position the image.

Insert an image from the image collection (any of them will do for now) onto the page in the usual manner using Insert + Pictures.

Click the OnMerge Images Icon in the Mailings ribbon. The OnMerge Images dialog pops up.

Wait! Do not press the Insert button at the bottom of the Insert Picture dialog box as usual after selecting the file. Instead, press the little triangle on the right edge of that button to get a three-line menu, and click “Link to File.”

Do not attempt to format or resize the picture.

5

To make the image variable: Press the Alt + F9 key combination. The picture you just inserted will now appear as something like this (all on one line—ignore the break between lines shown below):

Click on the Folder button to get a popup, choose the folder with your images, press OK.

{ INCLUDEPICTURE "c:\\staff\\pictures\\John.jpg" \*MERGEFORMAT \d } Note that copying and pasting the above text from this article into Word will not work. You must carry out this procedure as described.

6

Select and delete the filename portion, but leave the folder name(s) with the backslashes, and leave the file’s “extension” (.jpg in this case, might be .gif, .bmp, .tif or other).

In the first line under the folder name, under Type of name part, click small right triangle to see a list of field types. Select Merge Database.

The doubled-up backslashes are no typo: Word requires them that way. In this example we’ll only remove “John” and the line will now look something like (again, ignore the line break): { INCLUDEPICTURE "c:\\staff\\pictures\\.jpg" \*MERGEFORMAT \d

7

Leave the cursor where "John" used to be.

Immediately to the right, drop down the Field Name and choose the data field's name.

Press Mailings + Insert Merge Field and select the database field you need.

You'll immediately see a preview of the image in the top, right corner. A preview of the picture file's full name is to the left for reference.

In this example, you'd get (again, ignore the line breaks below): { INCLUDEPICTURE "c:\\staff\\pictures\\ { MERGEFIELD “FirstName” }.jpg" \*MERGEFORMAT \d } 8

Press Alt + F9 again to go back to Picture View to view your handiwork.

10

Run the Mailings, Finish & Merge, Edit Individual Documents. Do not merge to a printer, fax or e-mail. The images won't appear to have merged correctly. The next step will correct that.

That's it! Press OK. The picture will appear in your document at the cursor location. Pages will update if you use Word's Preview Results controls to scroll through database records. Finish & Merge as usual. Merging to printer and e-mail work fine.

11

Very important after-merge steps:



Select the new document Press Ctrl + A Press F9 You can now print the resulting document or save as a PDF. Mail merge to e-mail is not possible.

Possible Problems and Workarounds

OnMerge Solutions to Common Problems



To resize, click on an OnMerge Image to reveal small selection rectangles at each corner.

Image Size The photos in the merged document will probably be the wrong size.

Drag the corners to set the width and height of the overall barcode.

Don't attempt to change the picture in the original Word document. If you do so, the change will appear to work but Word will change the image back to the incorrect size as soon as you do a merge. This is one of Word’s quirks: whenever it merges in a new image, Word resets the image to its “natural” state. That’s just the way Word works, so you must work around it. There are two ways to work around the image-size quirk: Before merging, change all original images’ size to the desired size using Photo Editor or similar software After the merge is done, manually resize troublesome images in the resulting document.

OnMerge can compress/stretch the photo to fit just inside a predetermined area while keeping the pictures' correct proportions. That can be very handy if you have both landscape and portrait images (horizontal & vertical) in the same collection.

Those are the only options, aside from unfriending Bill Gates.

Image Rotation and Orientation

To automatically rotate: double-click on an OnMerge Image to pop up the dialog box. Select the Merge Options tab.

The photos in the merged document may be turned the wrong way horizontal vs. vertical. Don't attempt to change the picture in the original Word document. If you do so, the change will appear to work but Word will change the image back to the incorrect orientation as soon as you do a merge. This is one of Word’s quirks: whenever it merges in a new image, Word resets the image to its “natural” state. That’s just the way Word works, so you must work around it.

Select the Copy images... checkbox.

There are two ways to work around the image-size quirk: Before merging, change all original images’ orientations to the desired size using Photo Editor or similar software After the merge is done, manually rotate troublesome images in the resulting document.

Mail Merging Images from PDFs

You can also select one of the Auto-Rotate options from the list to force images to be turned in a particular way. Press OK. Copy or mail merge photos or entire pages from PDF files using the PDF Mashup feature in OnMerge Images Suite. We don't have the space for details here, but this screenshot will give you an overview.

IncludePicture cannot directly insert pictures that are in PDFs. You can open the PDF in Word, then cut & paste each picture into a photo editor such as the Paint program that comes with Windows; save each picture to its own file. You can also make screen grabs and save them to individual files if you aren't concerned about image quality.

See here for details about merging from PDFs.

Beware Missing Photos and Images

OnMerge Images has options to do whatever you need when image files are missing.

You may notice in your finished merge that some of the images are missing, with a red-X box like this in their places. That is what Word does if the database look-up comes up with a file name which doesn’t exist.

Double-click on an OnMerge Image to pop up the dialog box. Select the Merge Options tab. Select an option as shown here:

There’s no way to get rid of the red X except to give Word what it wants: an image file. If you don't want an occasional red X, you can either (a) fix your database if the data is genuinely incorrect, (b) create suitably-named allwhite "dummy" image files for each missing name using Photo Editor or other program, or (c) delete the red X's after the final merge. The data you’re testing with may not have missing image files, but be aware that missing images may occur when you roll out your master document with a larger database. It’s important to take steps to check data to make sure that it’s clean, or that there are dummy files for all possible missing names.

Notice you can select a default picture or graphic to merge if the requested image file is missing.

Summary

OnMerge Images



There are dozens of other ways OnMerge Images saves time, frustration and does things that otherwise would be impossible. We only have space to list a few here:

Admittedly, INCLUDEPICTURE can be difficult to use, but can be very useful. In summary, here's how to take the basic steps for successful variable image mail-merging: 1. Rename image files to match the database (or change the database to match images); 2. Setup coding of merge fields using a database; 3. Resize each image file to the correct size and orientation; 4. Check and scrub the database of names that don’t have corresponding image files (or create dummy blank images); 5. Run the Merge to New Document; 6. In the new document, press Ctrl + A followed by F9

merge pictures from websites merge images from variable PDFs automatically resize each merged image to fit a specific box size without “squishing” the image nor resizing the original compose an image file name from multiple database fields (such as FirstName + LastName) barcodes Download your free OnMerge Images tryout version here.

Privacy Policy

Support

Buy



Terms & Conditions

Contact Us

Download Free Trial





Copyright © 2005 - 2017 Soft Horizons All trademarks are property of respective owners.



Loading...

How to Mail Merge Pictures: INCLUDEPICTURE in Microsoft MS Word

Merge Images Merge Barcodes Merge PDFs Store How-To Free Trial "I'm using OnMerge mainly for picture name badges (for the church I atte...

762KB Sizes 2 Downloads 17 Views

Recommend Documents

How to Use Mail Merge in Microsoft Word | Study.com
When you click on that, 'Start Mail Merge' is the third option from the left side of your screen. After clicking that, y

How to Use Mail Merge in Microsoft Word | Webucator
In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge

Microsoft Word Mail Merge - MIStupid.com
It will then be used to create a form letter and labels for each name in the data file. Create a Data File in Excel · Cr

Performing a Mail Merge in Microsoft Word
Performing a mail merge in Microsoft Word involves four steps: Creating the Main Document. Creating the Data Source in M

How to use Mail Merge in MS Word 2016? (with Pictures) - QueHow
Sep 17, 2016 - Steps to use Mail Merge in MS Word 2016: Let us suppose, you have to prepare an interview call letter for

Mail Merge (Microsoft Word) - Word Tips - Tips.Net
Word has a Mail Merge manager that makes putting individualized data into your document easy. The following articles exp

How to Create a Mail Merge Document Using Microsoft Word
Sep 8, 2011 - Mail Merge mass produces letters, mailing labels or other documents. To perform a mail merge you need two

How To Mail Merge In Microsoft Word: 12 Steps (with Pictures
Microsoft Word » How To Mail Merge In Microsoft Word: 12 Steps (with Pictures)

How to do a Word Mail Merge with Microsoft Access
This section covers the how to create labels with an Access database. It uses Office 2002 so for people with office 97,

Word How-to: Mail Merge Setup | Symplebyte
Jun 23, 2006 - Invitations and thank you cards went out using the same mail merge, from Excel to the label sheets using