Insert pictures in word document - search and replace with a picture

[Steven Reid]

Hi All,

I am trying to create a macro for Word 2003 that will loop through a
document and insert a book cover picture from a file directory based on the
a code in the document

At the moment we have a table with the following:
Isbn
Fmt
Image
Title
Author
Was
Now

07121654654

Additup
Book Title 1
Mor
26.95
7.99

0146543078

Addkeki
Book Title 2
Padraic
29.95
7.99

9780755464
B
BDUFIJO
Book Title 3
BISSETTI
24.99
7.99

9780399564
B
CDUJOBO
Book Title 4
LEHM
24.99
7.99




I want to be able to run a macro that will, based on the code in the image
column, go into c:\pictures\a or c:\pictures\b or whatever based on the
first letter.
I would like to be able to also resize the graphic to a standard size e.g.
95 w x 120 h (for example)

Any Ideas?

Thanks in advance

Steven Reid

 

[Graham Mayor]

This sounds like a job for mail merge - see
http://www.gmayor.com/mail_merge_graphics.htm
If you want all the images to be the same size, insert them into table cells
with a fixed width. The images will then adapt to the width of that cell.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Steven Reid]

Wow!

Very impressive. I will have a look at that option.

Thank you very much

Steve