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.
No, that assumption is not correct! I
In the data source, in the Picture field, you need to have the (path and) filename of the picture, such as your
C:\Documents and Settings\ProfileName\My Documents\My Pictures\RésuméPhotos\Jones.jpg
Then in the mail merge main document, where you want the picture to appear, you need to insert a
{ INCLUDEPICTURE "{ MERGEFIELD Picture }" }
field construction where each pair of Field Delimiters { } inserted by the use of Ctrl+F9
If the path is always the same, you could just have the filenames such as Jones.jpg in the picture field and then you would use the following field construction
{ INCLUDEPICTURE "C:\Documents and Settings\ProfileName\My Documents\My Pictures\RésuméPhotos\{ MERGEFIELD Picture }" }
or if you want to be more adventurous, you could just have the persons name in the picture field and then use:
{ INCLUDEPICTURE "C:\Documents and Settings\ProfileName\My Documents\My Pictures\RésuméPhotos\{ MERGEFIELD Picture }.jpg" }
which would be handy if you already have a data source that includes say a last name field (and there were no duplicates) and the filenames of the pictures corresponded to the last name as in that case, you would not need to modify the datasource as the field could then be
{ INCLUDEPICTURE "C:\Documents and Settings\ProfileName\My Documents\My Pictures\RésuméPhotos\{ MERGEFIELD LastName }.jpg" }
I am not sure why Suzanne turned you off the information on Cindy's website as it is does explain how to do it.
Thanks both Suzanne and Doug,
Yea, Doug, I didn't understand much on the link you provided. Suzanne has me pegged as someone who needs more handholding. So, yea, here's where I show more of my lack of understanding.... :-0
Suzanne,
OK - breaking down what you said, so in the data source, I have a column called "picture" and for each recipient I was assuming that there was the place I needed to enter the string
{ INCLUDEPICTURE "C:\Documents and Settings\ProfileName\My Documents\My
Pictures\RésuméPhotos\Jones.jpg" \d }
Is that a correct assumption?
I'm not even going to ask any other questions as maybe, if I can get on track with this answer, then the rest will fall into place for me. I love a challenge but hate the looking stupid part.....
After I master this task, I've got another one in the wings. Oh boy. Thanks.
With respect, Doug, I think geegolly might have a better chance of following the directions in my previous post than those in Cindy's succinct article, which assume even a higher level of expertise.
The rest of my post specified how to create the field for the photo. It assumes that you don't have the actual photo in your mail merge data source but just the filename of the photo (or part of the filename). The rest of the path is inserted in the mail merge main document; the mergefield supplies just the name that is in your mail merge data source.
So if you have a folder full of photos with names such as Brown.jpg, Smith.jpg, Jones.jpg, and so on, you insert one (with the \d switch) to get an IncludePicture field with the correct path, then substitute your mergefield for the part of the path that will be different for each photo (the Brown, Smith, Jones) part.