Re: [libreoffice-users] Multi-source Mail Merge

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