the size they show up in when you initially Insert an image into the document) when they are merged. That is because Word will reset all the merged images' size back to their default (i.e.
All of the images that will show up in a given position on the page must be the same size, and you must not adjust (shrink or stretch) those images' size in Word. Not a problem for some people - but a major issue for others - depending on skill level. Microsoft word for mac 2011 mail merge manual#
You'll need to do some manual coding of mail merge fields.The last point can be critical because merging directly to e-mail or fax is the only way to make Microsoft Word use e-mail addresses and phone numbers from the database to send your message. You cannot mail merge to e-mail or fax since you must Merge To New Document.Also, the additional steps may require you to specially train anybody who may need to run the mail merge operation, including temporary and replacement staff. That means large merges will take longer because you cannot merge directly to the printer. As you can see from the directions above, you must first Merge To New Document, select the new merged document, press Ctrl + A, and press F9 before saving or printing your new document.Here, I'll discuss those traps and suggest some ways of working around some of them. heading below.įor all of its usefulness, IncludePicture does have some gotchas that may limit its usefulness to you. If you just need to get something done quickly and move on, or if you're the impatient type, IncludePicture may not be for you see under the Alternatives. Is IncludePicture for You?įirst, a reality check: as you can see from the huge pile of questions and comments below, using IncludePicture is a "project." In other words, plan to put some time into learning this and getting it dialed in. If you're merging barcodes, check out my Hub about Word's DISPLAYBARCODE. Go through the merged document and "manually" do any necessary fix-ups to image size or rotation.
Don't miss this step, it's very important: Select the new document Press Ctrl + A Press F9.Run the or (not to a printer, fax or e-mail).
Press Alt + F9 again to go back to Picture View so that you can view your handiwork. The picture you just inserted will become something like this on a gray background: You're now ready to make the image into a variable image. 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 format or resize the picture. However, do not press the Insert button as usual after selecting the file. Locate where you want to position your image, and insert an image from the image collection (any of them will do for now) onto the page in the usual manner using Insert + Picture + From File. Only if you're using Word 2003 or before, also make sure that the Mail Merge toolbar is visible in Word's menu bar if not: Tools + Customize, check off the Mail Merge box. If it's not already selected, select the data source (database) into the master document you'll be working with. Don't bother reporting the bug to Microsoft: they've known about it for a long time. If you're using Word 2007 or later, Save As the document in the Word 97 - 2003 (.doc) format - NOT the Word 2007 (.docx) format. 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, and to name the images files the same as the contents of a field in the database. IncludePicture finicky and won't work if you so much as breathe on it the wrong way. Try to follow the instructions very, very precisely. This step-by-step explanation has been excerpted from an online article on using IncludePicture and is included here by kind permission of its author.