On 9 May 2015 at 13:40, A <publicf...@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+unsubscr...@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