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


Hi.
Just a suggestion on a where to look. Nabble will allow you to search this list back if you don't have it in your email for a long time. I have some vague recollection of a discussion where you can insert something that is like a next record instruction. The layout you want is straight forward in Writer, merging from a sheet as a data source and a next record token will allow multiple records on a page. some stuff here https://forum.openoffice.org/en/forum/viewtopic.php?f=30&t=36229
steve
On 2014-08-20 01:38, dave boland wrote:
All,

Thanks for the replies - I think.  First, you can't do this with cut and
paste because the formatting is just columns.  This is (hint) like a
database report where the comment field is placed under the description
field (see below).  The fields in the spreadsheet are: Date, Sender,
Subject, Description, Comment.  What I want is to have all records
printed on one page (or two if needed), not one record per page like
mail merge typically does.

Writer has data sources, and you can select fields, I just have not
figured out how to fill the fields so they are printed like below (one
record after the other).

However, I believe it is possible to use Base to create the report I
want.  I'll investigate that approach later today.  Any other helpful
suggestions welcome.

Dave,

On Mon, Aug 18, 2014, at 11:17 AM, dave boland wrote:
All,

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?

The data is actually: Date, Sender, Subject, Description, Comment.  Waht
I want to do is something like this:

Date     Sender     Subject       Description/Comment
1/15/14  Mr. Black  Order Conf.   Confirmed the order.
                                   Will be able to ship by 2/1/14

1/16/14  (me)       Ship date     Shipping date 1/30, UPS

2/1/14   Mr. Black  Order Rec'd.  Order was delivered.
                                   Customer called to thnak us!

Dave,
--
   dave boland
   dboland9@fastmail.fm

--
http://www.fastmail.fm - Send your email first class


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



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