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


On 11 May 2015 at 16:30, A <publicface@bak.rr.com> wrote:


On 05/11/2015 05:43 AM, T. R. Valentine wrote:

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


That's a really good idea in concept, however in practice I don't know how
it would work.  I presume you're saying that the master spreadsheet would
contain filenames of all the other spreadsheets? That's fine except I don't
see how that helps, as each file needs to be opened by the mail merge
function one at a time and there doesn't seem to be a way to automate that.

Unless you're saying that the master would contain just the needed cells
from the other spreadsheets?  That seems interesting... it would solve the
mail merge problem as then I'd only have one data source, but I'd have to
hand enter each file name, modifying each cell one at a time.  That doesn't
sound too appealing.

You copy from the cells in the various spreadsheets and do a Paste
Special to the 'master', selecting 'Link'. That way, any changes made
to the various spreadsheets is reflected in the 'master'. (Ranges can
be copied and linked with a single Paste Special — no need to copy and
re-enter one cell at a time.)

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

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.