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

Hi :)
Not sure what happened there, some sort of "bad hair day" or something.  I
couldn't see any mention of copy&paste in the original question so i'm
guessing someone got their wires crossed.

There is a guide that covers "mail merge" and that might help;
Also the Faq might help;
And this hopefully shows how to use a Calc spreadsheet as the data-source;
(surely it's more accurate to say an ODF spreadsheet? or a spreadsheet in
Ods format? since such formats are not tied to specific programs)

Of course the question only gave a few rows but i can see how that could
easily grow into many more rows and that different types opf similar
reports might be needed.  For example 1 such Writer-report might be needed
to send to Mr Black, another to Mr White and another to Mr Orange.  Then
other combinations such as Mr Black and Mr White might be in the same
company and that company might want a report that covers all their people.
Another report might be to your own company and need to included everyone.

If you are likely to need different reports like that then it might be good
to eventually migrate to using a Base Query as the data-source.  Base could
use the spreadsheet as it's "external back-end".  Then set-up a Query to
pick out the relevant rows.  It's then a question of whether to use Base's
Forms or Reports or maybe to still use Writer to present the type of table
you want.  If some of those reports are needed more than just as "one offs"
then you might have a new set Query for each of those.  Since Queries don't
contain any data themselves they are extremely light so you can hae quite a
lot of them without slowing anything down.

For now though you probably do just need Writer to just use the Calc
spreadsheet directly and then maybe up-scale it sometime in the future.

Please let us know how this goes!  Hopefully someone here might be able to
give a better answer later but so far all i have is a kinda rtfm one!
Sorry about that!
Good luck and regards from
Tom :)

On 19 August 2014 03:48, Brian Barker <> wrote:

At 11:17 18/08/2014 -0400, Dave Boland wrote:

I have a small Calc file of information I want to put into Writer - like
mail merge, but the data is not address.  What is the best way to do this?

Copy and paste? In what sense is this "like mail merge"?

 The data is actually: ...
What I want to do is something like this: ...

You've given an extensive layout of some text, which doesn't help much.
You haven't said what you wish to do with this if simply copying and
pasting into a text document does not suffice. I could paste your material
into a text document in less time that it takes to write this.

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.