Catalog Merge Question inserting images into publication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Veli Izzet - 25 Oct 2005 15:12 GMT

Hi all,

I want to insert .jpg images of items in a catalog merge publication.
The database the items are held are in access 2003.

The images are in a folder in the "slides" subdirectory of the current
folder.

The names of the images are in a field of the access database, such that
if the image is 123456.jpg, the ImageData field holds 123456.

The merge should look at the ImageData field, get the name add .jpg as a
suffix, and the path as a prefix, and fetch that image from the filesystem.

How do I get this doen by VB programming?

Thanks for any help.

Reply to this Message

Ed Bennett - 25 Oct 2005 16:14 GMT

Veli Izzet <veli.izzet@gmail.com> was very recently heard to utter:

> How do I get this doen by VB programming?

You could use VB programming, but it'd probably be a long way around.

You can just create a new MakeTable query in your database, which takes the
ImageData field, adds slides\ at the front and .jpg at the back.

Use the query to create a new table and merge against the new table instead
of the old one.

Signature

Ed Bennett - MVP Microsoft Publisher

Reply to this Message

Veli Izzet - 25 Oct 2005 16:20 GMT

Sorry Ed, but I am confused.

I do not want to print the location of the images. I want to print the
images themselves, and the images are not in the access db, but their
locations are.

How would I get the images from the filesystem onto the publication?

> Veli Izzet <veli.izzet@gmail.com> was very recently heard to utter:
>
[quoted text clipped - 7 lines]
> Use the query to create a new table and merge against the new table instead
> of the old one.

Reply to this Message

Ed Bennett - 25 Oct 2005 17:27 GMT

Veli Izzet <veli.izzet@gmail.com> was very recently heard to utter:

> How would I get the images from the filesystem onto the publication?

Using the Catalog Merge in Publisher 2003, and the Insert as Picture button
instead as the Insert as Text button (sorry, I'm not sure what those buttons
are called in Turkish Publisher 2003)

Signature

Ed Bennett - MVP Microsoft Publisher

Reply to this Message

Veli Izzet - 25 Oct 2005 17:36 GMT

I'm using the English version.:)

I will try..

Thanks..

> Veli Izzet <veli.izzet@gmail.com> was very recently heard to utter:
>
[quoted text clipped - 3 lines]
> instead as the Insert as Text button (sorry, I'm not sure what those buttons
> are called in Turkish Publisher 2003)

Reply to this Message