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

On 9 May 2015 at 13:40, A <publicface@bak.rr.com> 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.

Would it be possible to create a 'master' spreadsheet, linked to the
various single spreadsheets and then do the mail merge from the
'master'?


-- 
T. R. Valentine
A rich heart may be under a poor coat.

-- 
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