Having major problems using INCLUDEPICTURE for a mail merge.

I know this is a common question.  I'm using Word 2010 and connecting to a SQL 2012 local Express database for a Mail Merge.  

I have a string field in my table defining a location for an image.  I am certain the path is correct.  I've verified that the string itself is getting through correctly.  (C:\\TEST\\FILENAME.jpg, etc).  

Most of the examples I've looked at talk about inserting a picture with the Link To File option, then doing an Alt F9.  Beyond that I just can't get it to work.  

I have, among other things followed Graham Mayor's advise and unchecked the Update Link on Save option (although I still seem to be getting that //..//..// format.)

Beyond that my attempts have mostly been similar to this,  Alt-F9 then insert variations like this: 

{INCLUDEPICTURE "{ IF TRUE "MERGEFIELD ClientImage" }" \* MERGEFORMAT \d}

(By the way, it's not clear to me from my reading whether all the brackets should be generated by CTRL-F9 or just the outermost.  I've tried it both ways, without success.)

Does anyone have a reliable list of steps they could provide?  This is getting too frustrating.



Answer
Answer

The field construction should be

 

{ INCLUDEPICTURE { IF TRUE "{ MERGEFIELD ClientImage }" } \d }

 

You must use Ctrl+F9 for each pair of field delimiters

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

4 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

Remove the \d switch (which stops the graphic data being stored in the document) if you want to email it.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated August 23, 2023 Views 9,768 Applies to: