A family of Microsoft word processing software products for creating web, email, and print documents.
What is in the PictureLocation field?
The filepath separators need to be duplicated \ or you need to use / as a separator.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
Right. I didn't read all of your post, but you were suggesting putting the entire path in the data source. I see you did later suggest putting just the changeable part, which was my suggestion.
I looked at Cindy's article and concluded that, if I didn't already know how to do this, I would not be able to figure it out from Cindy's instructions.
The OP was trying to put the INCLUDEPICTURE field in the data source!
Although you could do it the way Doug suggests, what I described is what I
do:
C:/Documents and Settings/ProfileName/My Documents/My
Pictures/RésuméPhotos/Brown.jpg
C:/Documents and Settings/ProfileName/My Documents/My
Pictures/RésuméPhotos/Jones.jpg
C:/Documents and Settings/ProfileName/My Documents/My
Pictures/RésuméPhotos/Smith.jpg
{ INCLUDEPICTURE "C:\Documents and Settings\ProfileName\My Documents\My
Pictures\RésuméPhotos\Jones.jpg" \d }.
If you do it this way, you don't have to worry about the proper formatting for the field (backslashes, quotation marks, etc.). You let Word do the work for you.
{ INCLUDEPICTURE "C:\Documents and Settings\ProfileName\My Documents\My
Pictures\RésuméPhotos\{ MERGEFIELD Picture }.jpg" \d }
Note that, in order to see the IncludePicture field code, you must have the picture wrapping set to In Line With Text. If you want text wrapped around it, you can change the wrapping after you get the field working.
Note that the \d switch in the IncludePicture field means that the pictures will not be embedded in the file (so your merged document would likely break if you moved it to a different machine. If you want the pictures embedded, you can remove the \d switch before merging (I think) or unlink the photos (with Ctrl+Shift+F9) after merging.
No, Doug, that is not what I suggested at all. It would work, of course, but I find it much easier to put the path in the mail merge main document and use the mergefield for just the filename. That way the mail merge data source is much less cluttered.