If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I MailMerge a photo from a DB
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. |
#2
|
|||
|
|||
How do I MailMerge a photo from a DB
Hi David D. ),
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. |
#3
|
|||
|
|||
How do I MailMerge a photo from a DB
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. |
#4
|
|||
|
|||
How do I MailMerge a photo from a DB
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 "Mac Townsend" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|