Only get a red x after merging pictures

Anonymous
2010-04-14T02:24:00+00:00

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

Microsoft 365 and Office | Word | For home | Windows

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.

0 comments
Answer accepted by question author
Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
2010-04-14T05:38:23+00:00

What is in the PictureLocation field?

The filepath separators need to be duplicated \ or you need to use / as a separator.

Was this answer helpful?

0 comments

55 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Suzanne S Barnhill 279.4K Reputation points MVP Volunteer Moderator
    2010-07-02T02:46:35+00:00

    You said you had set up a field (column) for the picture names. It's up to you whether you put the entire file path or just the filename. My preference is for the filename minus the .jpg extension. 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.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-07-01T23:21:41+00:00

    Could you be specific about the proper way to enter the file names in the data source.  I think I followed the direction exactly so maybe there's something additional to add?  Where exactly does it belong?

    Was this answer helpful?

    0 comments
  3. Suzanne S Barnhill 279.4K Reputation points MVP Volunteer Moderator
    2010-06-30T22:17:58+00:00

    Insert the merge fields where they belong! I still don't know how you have entered the filenames in your mail merge data source, so I can't be specific there, but you need to get the non-photo merge fields out of the IncludePicture field and put the "picture" merge field where it belongs.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2010-06-30T21:21:39+00:00

    So what is the solution to that situation?

    Was this answer helpful?

    0 comments