Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


On 9-5-2015 20:40, A wrote:

I have multiple spreadsheet files that each represent one unique item.
As an analogy, think of the spreadsheet as a basket that contains a
variety of eggs (both calculated and hand-entered data). I have multiple
baskets each with multiple eggs.  Each basket (spreadsheet) is
associated with one person.  Each person can have multiple baskets
(although that's probably not relevant).

I also have a letter, with which I want to do a mail merge - against
each spreadsheet.  i.e. each letter needs to draw multiple pieces of
data (eggs) from each spreadsheet, one letter per spreadsheet.

Normally to do a mail merge you have one data source.  The problem of
course is that I don't have one data source, I have an unknown number -
each spreadsheet is a data source.  So I'm at a loss as to how to mail
merge against multiple data sources in an automated fashion.

Thank you in advance.




If one person has multiple baskets (=sheets), will this person receive one letter? or multiple letters?


This looks like (in SQL):
SELECT egg1, egg2, egg3 FROM basket1
UNION
SELECT egg2, egg3, egg4 FROM basket2
UNION
SELECT egg3, egg4, egg5 FROM basket3


How equal/similar are these eggs, and the number of eggs in a basket?



--
To unsubscribe e-mail to: users+unsubscribe@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

Context


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.