Hi Paul,



I'm having exactly the same problem, but can't seem to find a way to PM you. I would just like to ask you some advice or guidance as to what I am doing wrong, but since this thread (https://www.msofficeforums.com/mail-...ut-images.html) has already been resolved, I don't want to spam it.

Thanks in advance.

- Dewald

Hi Dewald,

Without knowing what you're doing, I can't really offer any specific advice. As indicated in my last post, though, it would be useful to know what the actual filepath is and what the field referenced by mergefield concerned is named and what it returns.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,

I'm trying to do a mail merge from an Excel spreadsheet. Everything works great and I have 8 images on each page (Using labels and each one has an image) but every 3 pages or so, the image changes. The name of the image it has to use is stored in the Country column in Excel. On pressing Alt-F9, it shows the URL correctly (In the final document) but all the images are showing the first pages' images. Currently the images in the template have this code:

I'd be willing to send you the images, spreadsheet and Word document, but only personally since I wish for it to be kept confidential. If you could send me an email (You should be able to see my details), I can send them to you. Thanks for the quick reply and the willingness to help!

- Dewald

Simply inserting a hard-coded INCLUDEPICTURE field into the document won't work. You need to use a field construction similar to the one I've already provided in post #2 above. Since you haven't provided the information requested, though, I can't give specific advice for your situation.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,

Sorry, just noticed that for some reason, copying the code and then pasting it gives the hardcoded version. Here's the actual one typed out:

The images are in the same directory as the Word document and they work fine, it's just that whenever I actual mail merge the document, they don't show correctly. Would be great if I could send you the files somehow.

Thanks in advance.

- Dewald

Again, as mentioned in post #2 at https://www.msofficeforums.com/mail-...ut-images.html:
The post goes on to show how both issues can be resolved, using a different field code.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Like I said, I've already tried your fix(es) in the second post and they didn't work for me. All I get is an output of "{ IF" where the images should be.

Alright, so here are the files. I retried your solutions in the second post and it still doesn't work but I'm guessing I'm doing something wrong. Hopefull you'll be able to help. Really appreciate it, Paul!

- Dewald

This is the first indication you've given of what the problem is. The simple answer, as stated in post #4 at https://www.msofficeforums.com/mail-...ut-images.html, is that you can't type the field braces (i.e. { }) - they must be created (in pairs) in the document via Ctrl-F9 (Cmd-F9 on a Mac).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tried that and it doesn't show the "{ IF" anymore, but now it just shows blanks, even after refreshing. Thanks for the help so far!

The issue may be that the field code needs the path to work with the construction you're using. If you can be sure the pictures will always be in the same folder as the mailmerge main document, you can modify the field code by adding a FILENAME field thus:
{IF{INCLUDEPICTURE {IF TRUE "{FILENAME \p}\..\{MERGEFIELD Country}.png"} \d} {INCLUDEPICTURE {IF TRUE "{FILENAME \p}\..\{MERGEFIELD Country}.png"} \d}}
The above works in my testing, though your workbook has some active but unused rows at the bottom and this causes an extra page of labels with no data to be generated.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,

It works! Thanks for all the help. At first it was just giving blanks again but then I noticed I had to refresh my template and not the merged document. Thanks once again!

- Dewald