Replies

Ok thanks Paul, I have tried to verify the spacing and didn’t see any error, and I take it that my construction is not “incorrect” since images are properly displayed when one is indicated. I tricked the system by creating a fake blank image so that there is always a link to an image in Excel, and I no longer have the error.

It’s not really fixing the initial problem since I have to make sure I insert a link to my fake image for records without one, but at least I won’t have to hit “ok” 650 times when prompted “a field calculation error occurred in record xx”

Thanks anyway for your help, already very happy to be able to display my images.

Side Note: I’m using Word 2010, PC, and was displaying an error message when completing the merge for the links leading to a pdf , it was displaying a white empty table with a small cross logo and a note “The Linked image cannot be displayed. The file may have been moved, renamed or deleted. Verify that the link points to the correct file and location.” However when I open the completed merge file under Mac, I see the proper picture. I thought it would be worth mentioning.

Hi Paul,

First of, I wanted to thank you for your detailed tutorial of April 7 2013, I was so relieved to see that inserting an image from a url worked I almost cried. I am running a merge on over 2000 records and couldn’t see myself exporting and then inserting the images manually for half of the records, so a big thank you.

Now I am facing with another challenge, I am using your merge “construction” and my line reads:
{IF {INCLUDEPICTURE {IF TRUE “{MERGEFIELD Link }”} d} {IF {INCLUDEPICTURE {IF TRUE “{MERGEFIELD Link}”} d}}

But as I mentioned above, only a part of my excel source’ records have a url leading to an image, therefore I get the message “Error! Filename not specified.” for those without link/image. That is fine because I can simply change the font into white and no one will see the error message, however, when I run the merge, I get a pop up for each record concerned saying “a field calculation error occurred in record x”. I read on the Windows help menu that I should be leading to a “then” second option for the If statement, as in “if you don’t find any image, then do nothing”.

Any clue on how I modify my line to avoid generating any error message?

Thanks in advance for any help you may bring!

Sophie