- #OPEN OFFICE WRITER MAIL MERGE HOW TO#
- #OPEN OFFICE WRITER MAIL MERGE INSTALL#
- #OPEN OFFICE WRITER MAIL MERGE UPDATE#
- #OPEN OFFICE WRITER MAIL MERGE CODE#
I only added those 2 fields one time to the detail section of the report. In the detail section is where I put the fields that I want listed and grouped by author: song number and song title.
Most of my form letter was text, so I just created a bunch of label fields to put the text where I needed it.ĥ. The trick to putting text into the report is to add a label field and change the label instead of using a text field. The group header section is where I put the bulk of my letter as well as the field I am grouping by within that letter. This adds a group header to the report layout grid.Ĥ. The Group Header is present and I chose Whole Group in the Keep Together field. I opened the Sorting and Grouping window and I selected the field I want to group by in the first Field/Expression field. Then I created a report in ooBase (not using the wizard).ģ. I created a database to connect to the ooCalc spreadsheet I used to enter the songs.Ģ.
#OPEN OFFICE WRITER MAIL MERGE INSTALL#
I did install OO 3.4.1 because I saw info that said the Base extension is not supported in versions after that. Instead, I used ooBase and installed the Oracle Report Builder extension to handle the grouping. ooWriter/mail merge is not the way to go. In a nutshell, I built a list of songs that I wanted grouped by author into a form letter.
#OPEN OFFICE WRITER MAIL MERGE UPDATE#
I just wanted to update this post with the solution I've configured so that any other newbie out there might save a bit of time.
#OPEN OFFICE WRITER MAIL MERGE HOW TO#
If I could just figure out how to get the text in a text box to print in the Detail section instead of a 0, I would be all set. I've also taken acknak's suggestion and tried writing the form letter in Base using Oracle Report Builder. But if I were to put in the Condition box, what would it compare to?
Is there a way to use the Condition field before inserting Next Record to limit the next record to the same author as the record above it? I'm not a BASIC programmer, so the things I've tried to put in that field may not have been in the correct syntax to work properly. So if the user is printing 50 letters, she would have to spend a great deal of time adjusting the form letter which isn't practical. If I insert Next Record and add > after it, it will print 2 records per letter, whether those records belong to the same author or not. When I insert Next Record and put nothing after it, I still get one record per letter.
#OPEN OFFICE WRITER MAIL MERGE CODE#
Is it possible to make this happen? I'm not a C# or BASIC coder, so specific instructions including necessary code would be awesome. Worf should list only 201 Happy Birthday. Kirk should list both 200 Blue Suede Shoes and 202 Hokey Pokey and the page for Lt. I'd like the mail merge output in this example to print 2 pages: one for James T. Here's an example of what the Calc spreadsheet looks like: I know that in Microsoft Word I need to add code directly to the form letter itself to make this happen. I've tried writing a SQL group clause into a query in my SongDB, but that has no effect. I've seen other posts on the forum that suggest inserting a Next Record field, but this does solve my problem. I can print this just fine, but it prints one song per letter. I've created a form letter in Writer, and I've inserted the fields I need onto the letter. I created a data source on that speadsheet called SongDB. So here's what I've done so far: I've created a song list in Calc that I've called, oddly enough, SongList. I'd like to list all songs pertaining to each author on one letter. I'm creating a mail merge for my church to put the song number, song title and author on a copyright transfer form letter. This is my first attempt at using OpenOffice, and naturally I'm trying something complex right out of the gate.
0 kommentar(er)
