This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
My data source is an xlsx file and one field (PictureLocation) has the full path name of each jpg file I want to merge into a document. I use this merge function: {INCLUDEPICTURE "MERGEFIELD PictureLocation}"} which works fine except I only get a box with a small red x in upper left-hand corner where the picture should be. I have tried F9, but to no avail. What am I doing wrong or what have I set incorrectly? I use VISTA and OFFICE 2007. dottybee
A family of Microsoft word processing software products for creating web, email, and print documents.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
What is in the PictureLocation field?
The filepath separators need to be duplicated \ or you need to use / as a separator.
And what's the \d for? I've seen examples in these messages putting \d near beginning of includepicture string, at the end and not at all. I've moved this \d all around - always the error message.
What is the key to getting all this string of includepicture stuff to manipulate the image and not the text? All these variations I'm getting prove one thing - that there's some little piece of missing information that falls before (I think) I even get to the includepicture part. Since 21jun that's the piece I'm missing. I mean, I could have just done all these things manually and I'd be done by now. So I'm in this for the technical challenge and I'm not walking away.
I've noticed instructions to enter filename.jpeg and filename.jpg and filename without extension. I've tried all three.
The closest my merged document comes to matching any thing to this field is now, next to the picture that remains the same for every person, in place of the <picture> merge field, now the actual words appears "filename.jpeg" and at least the filename matches the person's name.
There's just some huge disconnect about what goes where on my main document. I think I have the data source updated correctly. I just can't seem to make the connection as to the steps I'm supposed to follow on the main document..... I've tried all kinds of things and nothing seems to clear the field calculation error. The only thing that is clear is the field that this error refers to. :-(
1- You said you had said up a field (column) for the picture names. It's up to you whether you put the entire file path or just the filename.
2 - I then insert the Photo (or in your case "picture") merge field in front of the .jpg in the IncludePicture field.
If you've included the entire file path, then you would substitute the merge field for the entire picture path in the IncludePicture field.
--
Suzanne S. Barnhill
Responding to your above message line by line
1- My data source column called pictures - I removed the entire file path and input filename.jpg and also filename without the extension. Either the same results occur. I get field calculation error.
2 - I think you're talking about the main document and this sentence makes no sense to me. so maybe this is where the communication problem is. I can't go forward with this.