Skip navigation
Marcy325
Marcy325 Calculating status...
Currently Being Moderated

Trouble with mergin data...

Apr 18, 2012 8:47 AM

I've posted this question somewhere else here, but can't find it now...

 

Good morning, and thanks for being here to help.  A few months ago I made an employee directory in InDesign.  I used data merge and an Excel spreadsheet to hold the data.  The merge went perfectly and I don’t believe anything since then has been changed on the spreadsheet or location of the photo files. Here’s my problem: I’m about to edit the spreadsheet by adding the names and photos of new employees.  I haven’t added the names yet. I did a trial run to see if what I have already will merge correctly. Everything merges except the photos. Last time, I had a problem with getting the photos to merge. Apparently the path was too long, so I moved the photos to a new folder and the file names look like this: C:\Photos\smithjohn.psd

 

In the spreadsheet, the title on the column above the photo files is this: @photos.

 

Any ideas?

196 Views   1 Reply   Latest reply: SRiegel, Apr 18, 2012 8:52 AM
 
Replies
  • SRiegel
    Currently Being Moderated
    1. SRiegel,
    Apr 18, 2012 8:52 AM   in reply to Marcy325
    Report

    In the spreadsheet, rename that column as  '@photos

    the apostrophe keeps excel from seeing the @ as an operator.

     

    If you are still having trouble, try using just the photo names in the spreadsheet, and move the data source file into the same folder with the images.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points