How do I MailMerge a photo from a DB

[David D.]

I am using Publisher 2000 (from Office 2000 Pro) under W2K.

I am creating membership cards via Mail Merge with data from an Access 2000
DB. One of the fields is an ID photo (OLE Object jpg image).

I have not been able to figure out how to merge the ID photo onto the
membership card. "Insert" creates the same photo on all cards. "Mail
Merge" => "Insert Field" does not list the field that contains the photo.

- David D.

 

[Brian Kvalheim - [MSFT MVP]]

Hi David D. ([email protected]),
in the newsgroups
you posted:

|| I am using Publisher 2000 (from Office 2000 Pro) under W2K.
||
|| I am creating membership cards via Mail Merge with data from an
|| Access 2000 DB. One of the fields is an ID photo (OLE Object jpg
|| image).
||
|| I have not been able to figure out how to merge the ID photo onto the
|| membership card. "Insert" creates the same photo on all cards.
|| "Mail Merge" => "Insert Field" does not list the field that contains
|| the photo.

David, this wasn't introduced until Publisher 2003. Publisher 2003 allows
you to merge photos from a path in a database. So if you had an excel
database of paths to pictures, where the path would be for example C:\My
Documents\My Pictures\dog.jpg.
--
Brian Kvalheim
Microsoft Publisher MVP
http://www.mvps.org/publisher
~pay it foward~

This posting is provided "AS IS" with no warranties, and
confers no rights.

 

[Mac Townsend]

As Brian said, this merge feature started with Pub 2003


HOWEVER it will not take the photo itself from the database.

It will only take the name of the file from the database. The photo itself
must be external to the database and accessible but Publisher (i.e. not on a
CD or something where it is not available to Publisher).

There may be some issues getting the path to the photo correct as well.

Brian mentioned this but I thought you'd not notice the significance.

 

[David D.]

Thanks. I got it working on a computer that has Pub 2003. It appears
that if the photos are in the datasource directory, then no filepath is
needed. (or it may simply be that the path does not display in the Excel
cell, but it works anyway).

- David