Macros & Publisher

[craigcarter]

Hi all,

I have a publisher document and it has 67 pages that is created using
a catalog merge.

On each of the pages, I have number that is pulled from the database
and displayed on the page. I would like to know if it is possible to
write a macro to find this number and replace it with an image. For
example the number appears as "3" I would like to make it "3.jpg".

I would appreciate if someone could point me in the right direction,
and whether or not this is doable.

Craig

 

[Ed Bennett]

I have a publisher document and it has 67 pages that is created using
a catalog merge.

On each of the pages, I have number that is pulled from the database
and displayed on the page. I would like to know if it is possible to
write a macro to find this number and replace it with an image. For
example the number appears as "3" I would like to make it "3.jpg".

I would appreciate if someone could point me in the right direction,
and whether or not this is doable.

This is certainly possible; however, you'll have to do some VBA data
access. See (for instance)
http://www.microsoft.com/technet/prodtechnol/office/office2000/solution/part3/ch14.mspx?mfr=true
for some VBA data access information.