Le 05/10/2012 23:45, robertjm a écrit :
Hi Robert, > While I understand how to insert the name and ages text from a Calc > spreadsheet, I'm not clear on how to automate the photo insert. > > Is it as simple as adding a URL link into a cell within Calc (i.e.: > "John","Smith","c:\files\JohnSmith.jpg") and then add a pointer to that data > within the Text document? > No that won't work on its own because you're attempting to define a secondary data source (i.e. for the images) "by reference" to the underlying file system and LO doesn't know how to process that kind of information, which in essence is saying something like : "take this character string, consider it to be a file, open the file and parse (stream) its contents so that it gets interpreted and displayed as an image". At the moment, the only way to directly display images from a datasource are through Forms or Reports, and these are not tied into the mailmerge capabilities, otherwise you need a macro to do the lifting work for you. Below are links to information on the subject : http://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=31109 http://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=33396 http://www.oooforum.org/forum/viewtopic.phtml?t=89804 http://www.oooforum.org/forum/viewtopic.phtml?t=73329 And the following extension, which seems to be almost identical to what you want : http://extensions.services.openoffice.org/fr/project/text2pic As you will no doubt understand after having read the various posts, a request for this functionality, i.e. being able to mailmerge image files and have them display and print properly in a merged document is a feature that has been requested since at least 2003, for OpenOffice.org, and was never implemented. https://issues.apache.org/ooo/show_bug.cgi?id=18651 Alex -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
