[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[libreoffice-users] Re: Using photos within a Mail Merge setup??


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: users+help@global.libreoffice.org
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

Follow-Ups:
[libreoffice-users] Re: Using photos within a Mail Merge setup??robertjm <robertjm@hockeyhockeyhockey.com>
[libreoffice-users] Re: Using photos within a Mail Merge setup??robertjm <robertjm@hockeyhockeyhockey.com>
References:
[libreoffice-users] Using photos within a Mail Merge setup??robertjm <robertjm@hockeyhockeyhockey.com>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.