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

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
Wed Mar 05 04:47:06 PST 2008

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

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


Steven Reid wrote:
> 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

Steven
Thu Mar 06 02:54:57 PST 2008

Wow!

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

Thank you very much

Steve

"Graham Mayor" <gmayor@REMOVETHISmvps.org> wrote in message
news:exRn97rfIHA.3632@TK2MSFTNGP06.phx.gbl...
> 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
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Steven Reid wrote:
>> 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
>
>