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: Oldest
Most helpful Newest Oldest
  1. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2010-06-25T21:26:30+00:00

    The suggestion that Suzanne has made about linking to a picture has taken you off the track.

    Do you have picture files with the filenames of name1.jpeg, name2.jpeg?  You must have pictures with the filenames that you have included in the data source.

    What is the path to the folder that contains those pictures?

    In your mail merge main document, what do you see if you press Alt+F9 to toggle on the display of the field codes?

    In it, you should see { MERGEFIELD "First Name" }, { MERGEFIELD "Last Name" }and a field construction such as the following where you want the picture to appear:

    { INCLUDEPICTURE "DriveLetter\folderpath\{ MERGEFIELD Picture }" }

    where DriveLetter\folderpath\ will be something like C:\Users\username\Pictures\   (Note you can use either \ or / as the path separators)

    If you want the pictures to be all the same size, insert the above field construction into the cell of a one cell table with fixed cell dimensions.

    Note, that after you execute the merge to a new document, you will need to use Ctrl+A to select everything in the document and then press F9 to update the fields in the document for the correct picture to be displayed for each record.

    Was this answer helpful?

    0 comments
  2. Suzanne S Barnhill 279.4K Reputation points MVP Volunteer Moderator
    2010-06-25T22:54:26+00:00

    Sorry for all the red herrings. Go with Doug's advice from now on.

    Was this answer helpful?

    0 comments
  3. Suzanne S Barnhill 279.4K Reputation points MVP Volunteer Moderator
    2010-06-25T22:54:27+00:00

    I'm not sure WHY I thought this since I gave instructions explicitly for Word 2007. <sigh> Can I plead sleep deprivation?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2010-06-26T05:56:51+00:00

    Was this answer helpful?

    0 comments