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. 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. 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. On the first page of the wizard, select Use the current document and click Next.This is my first attempt at using OpenOffice, and naturally I'm trying something complex right out of the gate. To use the Mail Merge Wizard to send a previously-created Writer document: Create the document in Writer without using the Wizard, then use the Wizard to send it.See Chapter 11 (Using Mail Merge) of the Writer Guide for details. Use the Mail Merge Wizard to create the document and send it.You can use OOo’s mail merge to send e-mail in two ways: To e-mail a document to several recipients, you can use the features in your e-mail program or you can use OOo’s mail merge facilities to extract email addresses from an address book. PDF file attached.Į-mailing a document to several recipients Similarly, if you choose E-mail as PDF, OOo first creates a PDF using your default PDF settings (as when using the Export Directly as PDF toolbar button) and then opens your email program with the. If you choose E-mail as Microsoft, OOo first creates a file in one of those formats and then opens your e-mail program with the file attached.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |