Welcome To Signs101.com: Largest Forum for Signmaking Professionals

Signs101.com: Largest Forum for Signmaking Professionals is the LARGEST online community & discussion forum for professional sign-makers and graphic designers.


  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Variable data photo path question

Discussion in 'General Signmaking Topics' started by john1, Jun 14, 2012.

  1. john1

    john1 Guest

    I have a customer who is setting up the variable data file in excel for a large label run i am doing for them.

    I have everything set up in colums and the labels will have different photos on each along with text, My question is how can i have the customer put the file path to the photos on their computer and have it show up fine on my computer when they send me a zip folder with the photos?

    C:\Users\John\Desktop\Photos\Jellyfish.jpg is a example on my computer

    Their file path would be different beings they are using their own computer, which would throw the variable data off on the photos

    Any help?
  2. boxerbay

    boxerbay Active Member

    Nov 25, 2010
    Darkside of the Moon
    have them set it up in a folder on their desktop. receive there zip. copy photos to your desktop. look at their path and compare to your path. then do a find and replace in excel to update your file. find theircomputer/images/ replace with yourcomputer/images/

    we usually do our vdp in indesign. it will output a pdf ready for print.
  3. Mike F

    Mike F Active Member

    May 11, 2011
    Use a relative path, have them just set the path as "Photos\jellyfish.jpg", then just stick that folder in the same folder as your print files.
  4. MikeD

    MikeD Active Member

    Oct 25, 2011
    find and replace/ copy and paste: the part of the path relative to your pc, would be fastest for a 1 time job. Send a template for the rest that's relatively easy for them to populate, and send it to them on a cheap thumb drive that they send back to you.
  5. john1

    john1 Guest

    Found a solution, Thanks guys.

    I had a friend help me write a line of formula who is a master at excel that will allow me to put the photo path once the photo folders on my computer into each line with a simple click and drag down.

Share This Page