A very long shot...

[Phil_rose]

Hi all, I am laying out this book with 320 live band images as per the attached shot. Each one has to have its filename (exc .jpg) as a title added. I don't suppose there's any way to have Publisher source file names and slap them on the images as in the in the attached image? Like I say, long shot. Obviously I could then rotate all the names to make them punk rock and wonky!

As I say, long shot but thought I'd ask. 

Thanks!

Phil

[David in Яuislip]

You should be able to do that with data merge
Use the spreadsheet to strip the file extension
Column B formula is =MID(A2,1,C2)
Column C formula is =FIND(".",A2)-1

[thomaso]

26 minutes ago, Phil_rose said:

as in the in the attached image? Like I say, long shot.

Is this the "long shot"? (ps: how about a horizontal signature, less long?)

Possibly you can use Data Merge to place images together with text.

[Phil_rose]

I am a fool. Here's the image.

[Phil_rose]

Thi

1 hour ago, David in Яuislip said:

You should be able to do that with data merge
Use the spreadsheet to strip the file extension
Column B formula is =MID(A2,1,C2)
Column C formula is =FIND(".",A2)-1

This looks right but I don't understand how to do it! Can you explain what is going on here? 

Thanks so much!

[R C-R]

4 hours ago, thomaso said:

(ps: how about a horizontal signature, less long?)

Yes, please consider this because it will reduce the amount of scrolling needed to see all of your posts. For me, it is annoying enough to have to do that that I often just skip to the next topic.

[David in Яuislip]

The Help re. data merge is pretty good. I have shown how to strip the file extension
If the OP can reply with particular problems with Publisher data merge then they can be addressed but the signature needs to be fixed first