Thanks Alex!!
I think this will do the trick nicely. Unfortunately, it looks like I can't
access my images by way of the Google Drive folder I have them stored in.
However, when I tried using a generic picture over at the National
Geographic website, it loaded just fine.
Now I just have to come up with a proper Badge formatted .odt file so the
pictures fall where they need to fall!!
For anyone looking to resolve this, here is a detailed outline of what I did
to accomplish what I wanted:
I - Create document with final layout
A: LibreOffice Text document format (.odt)
II - Create spreadsheet with information to be merged (.ods)
A: Create column headers in first row
B: Anny photographs need to be {{FILENAME}}
III - Create databae from spreadsheet information (.odb)
A: Connect to existing database
B: Select Spreadsheet
C: Make sure to select YES to register the database
D: Save database
E: Confirm info has been added to database
i: Click on Tables
ii: Double-Click on Sheet
IV - Open layout document (.odt)
A: Select "View" --> "Data Sources" (shortcut: f4)
B: Choose database created in Step III
C: Select Tables
D: Select Sheet1 (database records will appear to immediate right of
data
sources
E: Drag column header to place in layout document (.odt) where you want
it
inserted
G: Save layout document after inserting remaining column headers
V - Create a merged document
A: Select "File" --> "Print"
A: Select YES when asked if you want to print as a Form Letter
B: Select Output into a File
C: Select Save as Single Document
D: Save merged document
i: Use different name so you don't overwrite original
ii: Can change to .pdf format if not inserting any photographs
VI - Insert photographs into document
A: Open newly saved document (.odt)
B: Select "Tools" --> "Extension Manager" --> "Text2pic"
i: If Text2pic extension is not installed, download it from:
http://extensions.services.openoffice.org/fr/project/text2pic
C: Select "Options"
i: Set Root folder or URL to root folder of where images are
stored
a: If set to blank, image column entries needs to be
the full path in
spreadsheet
ii: Set front and back delimeter to what was used in spreadsheet
iii: Checkmark "Resize inserted images"
a: Select proper Resize Mode
b: Set height and/or width parameters
iv: Click on "Default Picture"
a: Select image to display for broken photo links
D: Click OK
E: Click CLOSE
F: Select "Tools" --> "Add-Ons" --> "Convert Text to Picture"
G: Save merged document
i: Use different name so you don't overwrite original
Alexander Thurgood wrote
> ...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...
>
> ...the following extension... seems to be almost identical to what
> you want :
>
> http://extensions.services.openoffice.org/fr/project/text2pic
--
View this message in context:
http://nabble.documentfoundation.org/Using-photos-within-a-Mail-Merge-setup-tp4011420p4011635.html
Sent from the Users mailing list archive at Nabble.com.
--
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
