Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-12-2021, 05:50 PM
paluccie paluccie is offline IncludePicture with Mergefield Windows 10 IncludePicture with Mergefield Office 2019
Novice
IncludePicture with Mergefield
 
Join Date: Mar 2021
Posts: 2
paluccie is on a distinguished road
Default IncludePicture with Mergefield

Hi everyone,

I have been trying all different combinations and I can't get anything to work.

I get an error depending on the method I run Error! Filename not specified.

Other times I get the nothing to appear.

I have a mergefield set to {MERGEFIELD mem_number \* MERGEFORMAT } and this works just fine. I get the appropriate Mem_number from the field

Now what I would like to do is pull an image from a specific directory. I've done the following:

{INCLUDEPICTURE "C:\\TEMP\\{MERGEFIELD mem_number}.jpg" \* MERGEFORMAT}

this does not work. when I do an ALT+F9 to see what the path is I only get c:\temp\.jpg

Its dropping the mergefield.



If anyone can figure this out, I would greatly appreciate the help. thank you
Reply With Quote
  #2  
Old 03-12-2021, 09:26 PM
gmayor's Avatar
gmayor gmayor is offline IncludePicture with Mergefield Windows 10 IncludePicture with Mergefield Office 2019
Expert
 
Join Date: Aug 2014
Posts: 3,439
gmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to all
Default

You need the correct syntax for it to work i.e.

{INCLUDEPICTURE "{IF TRUE "C:\\Temp\\{Mergefield FieldName}.jpg"}" \d }

See Mail merge graphics and
Mail Merge Graphics Add-in
__________________
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
  #3  
Old 03-12-2021, 09:44 PM
macropod's Avatar
macropod macropod is offline IncludePicture with Mergefield Windows 10 IncludePicture with Mergefield Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,169
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

This is all explained in the Mailmerge Tips & 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
  #4  
Old 03-13-2021, 06:34 AM
paluccie paluccie is offline IncludePicture with Mergefield Windows 10 IncludePicture with Mergefield Office 2019
Novice
IncludePicture with Mergefield
 
Join Date: Mar 2021
Posts: 2
paluccie is on a distinguished road
Default

thanks, got it to work. needed to remove the beginning and end quotes.

Appreciate the help
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IncludePicture with Mergefield IncludePicture does not refresh the pictures ragesz Mail Merge 5 10-23-2020 03:41 AM
IncludePicture with Mergefield Copy IncludePicture field code VEA Word 1 06-21-2016 07:01 PM
InCludePicture are strecthed VEA Word 3 06-20-2016 03:10 AM
IncludePicture with Mergefield Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
IncludePicture with Mergefield IncludePicture does not work in Mailmerge malalex Mail Merge 4 12-10-2013 07:09 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:18 PM.


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