Back to Blog
Data merge multiple records per page5/30/2023 Insert “Conditional text” fields on all lines of your table: if Valid = 1 then (same for HOBBY) If the first line in a group is alway shown, set Valid = 1 We need a local variable to keep track, let’s call it Valid. The table has two columns, NAME and HOBBY and a number of lines it follows that these fields all have to be conditional, except possiby the first line.every instance you want to fill on every line in the table must be filled with entries in the text template.if your data source is a spreadsheet, you can include fields with forward and backward references.has no idea of what has passed and what is to come Mail merge handles only one record at a time, i.e.I’ll describe a table with a fixed number of lines but a variable number of entries, but the ideas do not require a table. It has always been possible, but the rules have changed multiple timesĪs of LO 62,3,2 the following seems to be true. This has been a real pain over the years. JD P* TP* Vx** | Mike Boone B | Jason Brown D | Manchester-based trio / Neal Blacka B | Chris Illingworth P | Rob Turner D | Rel Feb 9 2016ġ2 | The Touch Of Your Lips | 05:50 | Joey Defrancesco | (Ray Noble) Trip Mode | High Note | My research with things like inserting “Next Record” (Database Fields) hasn’t proved successful.īelow is an example of 3 records and how the merge comes out using Word/Excel – and what I’m trying to reproduce in LO on a single page, multiple records one below the other:ġ0 | How Dare You | 06:43 | St Germain | St Germain | Warner Bros Records |ĩ5 Boulevard / 99 From Detroit to St Germain / 2000 Tourist / 2015 St Germain album Tourist (2.8 million copies Ludovic Navarreġ1 | Raven | 04:58 | GoGo Penguin | A Humdrum Star | Blue Note | 2018 Typically with Word & Excel (which I’m trying to get away from) about 25 records can easily be merged onto 3 pages.Īppreciate any feedback, instructions, links to posts already answering exactly how to do this. In some records some fields may be blank in some records field length may be longer or shorter. Unfortunately, all I can find is information about printing labels, or creating personalized form letters where it makes sense to have one record per page/document. I am trying to create a Writer document where one page contains multiple records, and only when the page is full of records, is a second page started. The spreadsheet source data is actually coming out of iTunes (playlist data) … so the data is song titles, album names, song duration, comments, etc. The merge is automatically creating a new page for every record. PROBLEM – right now I can only get one record on each page. Hi! I’m trying to merge a LO Calc spreadsheet source file with a LO Writer document. Tried asking this a month ago - some looked but no one knew or was able to help out - trying again, maybe I’ll be luckier this time
0 Comments
Read More
Leave a Reply. |