Merging from an Excel file with graphics

Jun 16, 2022
Reaction score

Not sure if this should be in the Word forum or the Excel forums, but here goes:

I've been given a letter doc and an Excel file to merge to it.

The Excel file has a list of name/addresses with a map graphic alongside each row. I've been asked to merge the map into the letter along with the name/address.

I can look at Shapes objects in Excel, but the pictures are not in order - ie the first cell could have image 1.jpg, the next could have image 4.jpg, then the next could have image 3.jpg etc - so I don't think I could tie them to each record.

The only solution I've come up with for this so far is to click on each graphic, get the filename, then paste this into a cell in a new column. In this way I can use INCLUDEPICTURE in Word and merge the graphic files directly.

Obviously this is not practical to do for a large database, so I need a better solution if it's even possible - I don't see how it could be done as the graphics are floating over the cells - I can upset the order just br dragging one away from it's record.

Any advice welcome - even a flat 'this can't be done!' comment would be useful.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question