Creating a Document of Images from a List of Products

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gilley - 14 Jan 2005 20:53 GMT

I am going to try my best to explain what I am trying to do.

1. A list of our current products. Either in a table or list separated by
paragraph markers.
2. A directory on the network with 100s of images.
3. Create a document based on the list of products, locate the image in a
specified directory, and insert the picture into the Word doc.

I am looking at several different approaches. Populate the final document
with the product names using a mail merge? Build an array using the list of
current products then use the array to locate the images and insert them into
the document?

There are some things which might make this easier that I seem to be making
it!

The name of the product is in the name of the image file. For example, a
product may be called CH1 and the image file name is CH1( ICON).jpg. This
remains constant throughout the process.

All of the image files are located in a single directory on our network.
There will be no searching for the images. Just point Word to the correct
location.

I am hoping someone can point me in the right direction.

Warmest regards,

Gilley

Reply to this Message

Doug Robbins - 15 Jan 2005 00:16 GMT

See the "Graphics from data base" item under the "Special merges" section of
fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am going to try my best to explain what I am trying to do.
>
[quoted text clipped - 29 lines]
>
> Gilley

Reply to this Message

Gilley - 17 Jan 2005 14:01 GMT

Doug,

Thanks for the quick response.

I have read Cindi's reference that you provided, but maybe I am not
understanding properly or have something wrong in my merge field statement.

Here is what I have:

A Word document which contains two columns. The first column contains the
product name, the second the file name.
A second Word document which contains my mail merge fields.

{ mergefield productname }
{ include picture "d:\\newproducts\\{ mergefield filename \* upper }" }

My image files are located in the d:\newproducts directory. When I merge to
a new document, the product names are working fine. They are just a simple
mail merge. However, the images are not displaying. Instead I receive:

{ includepicture "d:\\newproducts\\" }

Not sure where I have gone wrong!

Any insight would be appreciated.

Regards,
Gilley

> See the "Graphics from data base" item under the "Special merges" section of
> fellow MVP Cindy Meister's website at
[quoted text clipped - 34 lines]
> >
> > Gilley

Reply to this Message

Rate this thread: