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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven Reid - 04 Mar 2008 12:08 GMT

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

Reply to this Message

Graham Mayor - 05 Mar 2008 12:47 GMT

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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi All,
>
[quoted text clipped - 54 lines]
>
> Steven Reid

Reply to this Message

Steven Reid - 06 Mar 2008 10:54 GMT

Wow!

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

Thank you very much

Steve

> This sounds like a job for mail merge - see
> http://www.gmayor.com/mail_merge_graphics.htm
[quoted text clipped - 60 lines]
>>
>> Steven Reid

Reply to this Message

Rate this thread: