Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-19-2016, 02:16 PM
utzja1 utzja1 is offline Mail merge with picture Windows 7 64bit Mail merge with picture Office 2013
Novice
Mail merge with picture
 
Join Date: Jun 2015
Posts: 11
utzja1 is on a distinguished road
Default Mail merge with picture

Hi, I'm trying to perform a mail merge and having issues getting my images to format properly. I created a single-cell table and have fixed the height/width of the cell so that the image would not push the cover sheet text onto another page. Each record has a photo path field associated with it, and I have edited the file path to use the (\\) separators as opposed to the (\) separators.

Inside the cell, i have the following field code text:


{ INCLUDEPICTURE {MERGEFIELD "PhotoPath"}\* MERGEFORMAT}

Two things are happening:



I am getting the same picture on every sheet, even after I complete the merge, select all and hit F9 to refresh the fields.

My picture is not automatically scaled to fit within the table cell, it's as though the picture is full-scale and the table cell is only a partial window onto the picture.

Any thoughts? I have seen multiple posts about this topic but none have seemed to be directly applicable.

Many thanks for your help!
Reply With Quote
  #2  
Old 01-19-2016, 03:52 PM
macropod's Avatar
macropod macropod is offline Mail merge with picture Windows 7 64bit Mail merge with picture Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See Managing Mailmerge Graphics in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-19-2016, 11:23 PM
gmayor's Avatar
gmayor gmayor is offline Mail merge with picture Windows 10 Mail merge with picture Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

I produced a simple add-in template that simplifies the insertion of the correct syntax that you might find useful - http://www.gmayor.com/mail_merge_graphics_addin.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert picture as a header with mail merge (resolution issues) sanpedro Mail Merge 2 02-03-2015 09:54 PM
mail merge and add the contact picture outlook 2013 iwshim Mail Merge 1 08-04-2014 06:47 AM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Mail merge with picture Insert picture background in Word mail merge labels obasanla Mail Merge 6 11-26-2012 11:53 PM
Mail merge with picture Mail merge picture into Publisher from URL BlueSprint Publisher 1 07-31-2011 03:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft