Office 365 Variable Image Mail Merge - Same image repeats

Question

Hi All,

I've been working on this for a few days now and have read through a bunch of discussions from 2013, 2014 and one from 2017.  I'm doing a mail merge where I need to pull in images matched to a person from an excel data file.

The same image repeats.  

I've read this is because I need an "If True" or maybe just an "If" in the syntax.  I'm also struggling with the *MERGEFORMAT command that comes bundled with the INCLUDEPICTURE.

Where I'm at is:  I can either see the image, but the image repeats OR I use an IF TRUE and the image breaks and turns into a red X.

My specific questions:

1. Is it better to include the path in a separate field from the merge OR just type it into the INCLUDEPICTURE
2. I've seen examples with spaces { INCLUDEPICTURE and {INCLUDEPICTURE and I'm not sure if it makes a difference?
3. What function does the *MERGEFORMAT serve?
4. Why do my images just repeat?  Iv'e tried also the {Next Record] but that also didn't work.

Someone always cuts and pastes an article from 2013 to answer this - but I've followed that character by character and I still get the same errors.

I very much appreciate any advice or help!

BC

I

Answer 1

See the following page of Graham Mayor's website:

http://www.gmayor.com/mail_merge_graphics.htm

Answer 2

Hi BoozeCakes,

Did you check above replies? If you still need help, please update us.

Regards.,

Neha

Answer 3

My experience with image merges is that often the pictures don't update automatically. If you select the merge results and press F9, do you get any change?

Hi!  Thanks for the reply.

The images don't appear until I hit F9 - until then, it's just an error message.

Once I hit F9, the image appears - but only just the same one, even through there are hundreds of images.

Answer 4

My experience with image merges is that often the pictures don't update automatically. If you select the merge results and press F9, do you get any change?