Re: MAIL MERGE TO AN OPENOFFICE CALC DOCUMENT
Thank you Alexandro for the suggestion of using tables. That works with a bit of fiddling to fit to an A4 page althouh for one who has relied on Calc for years to set out work it was a bit of a learning curve. I have now encountered a separate problem with the numbering of the tickets. I have read and re read so many things about getting the next record to work but so far have only managed to number tickets 1 and 2. No other numbers appear when I do a preview to printing. If I can do it to get a number 2 to show on a ticket why can I not get other numbers to follow I ask myself? This is the reason for the delay in acknowledging the help you gave with your suggestion. I was hoping to reply saying that everything is working in Writer with tables the way I wanted it to be. On Thu, Mar 26, 2015 at 1:31 AM, Alexandro Colorado j...@oooes.org wrote: On Wednesday, March 25, 2015 03:35:21 PM Jean Lear wrote: I need to print Raffle tickets with Butt and Ticket four to an A4 page. I have registered an OpenOffice Calc document containing numbers from one to seven hundred with columns for Butt and Ticket numbers as a Registered Data Base. I am able to do a mail merge from this OpenOffice Calc to a blank Writer document (with fiddling to get them in the right places), but am unable to do a merge from the same OpenOffice Calc Registered Data Base to an Open Office Calc document set up for the tickets or a Writer document set up for the tickets in sections and columns. I cannot see how to make up the Raffle tickets on a Writer to have them four to a page other than in sections and two columns. Why not just do a table inside a writer document? Is there any additional calculation you depend on calc for this? Writer has some basic formulas too like SUM and AVERAGE. As a last resort I had thought of printing the tickets from the Calc document and then using the writer document with the merged numbers to run the tickets through the printer a second time. I have used Calc for the tickets as I find I can use that to more precisely produce four raffle tickets to an A4 sheet with a butt and a ticket. I use Calc to produce work that other members may use writer for as I find it easier to work with. Can someone offer any suggestions or advice on how to merge the numbers into the Calc document please - if this can be done. I am using Apache OpenOffice 4.1.1 on a computer with Windows 7 Professional 64 Bit. Thank you. Jean
Re: MAIL MERGE TO AN OPENOFFICE CALC DOCUMENT
I see, I am sorry is giving you troubles. I am not sure exactly how to reproduce the error and all I can do is forward you some tutorials. Basically the mailmerge has to do with fields, the Mailmerge Wizards is in fact a macro that assign these fields and automagically go ahead in a sequence. To debug these mailmerges you would need to go to the assigned field and see if there is something wrong being defined. Fields are very powerful and can have something more than just squence, but lso conditionals, randomizers, references, etc. We have a whole book on Fields[1] that you can learn from. But this is for your own education on the platform. To solve the issue I think you can re-build the mailmerge and go step by step (if you haven't have to). And pay close attention where the field in question is being created. Another strategy is to breakdown the merge and do the merging in sections, meaning that you would need to generate the mailmerge with only the fields that you think have issues and see if this is being repeated in isolation. If this works, then there might be some other field interrupting the process. PD: Sovleigh Haugland has an excellent tutorial on Mail Merge althought is a bit dated, it still works wonders. It explores and redescover the power of mailmerging. [2] [1]: https://wiki.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide/Working_with_Fields [2]: http://openoffice.blogs.com/openoffice/mail-merge-2009/ On Sat, Mar 28, 2015 at 7:22 PM, Jean Lear meld...@gmail.com wrote: Thank you Alexandro for the suggestion of using tables. That works with a bit of fiddling to fit to an A4 page althouh for one who has relied on Calc for years to set out work it was a bit of a learning curve. I have now encountered a separate problem with the numbering of the tickets. I have read and re read so many things about getting the next record to work but so far have only managed to number tickets 1 and 2. No other numbers appear when I do a preview to printing. If I can do it to get a number 2 to show on a ticket why can I not get other numbers to follow I ask myself? This is the reason for the delay in acknowledging the help you gave with your suggestion. I was hoping to reply saying that everything is working in Writer with tables the way I wanted it to be. On Thu, Mar 26, 2015 at 1:31 AM, Alexandro Colorado j...@oooes.org wrote: On Wednesday, March 25, 2015 03:35:21 PM Jean Lear wrote: I need to print Raffle tickets with Butt and Ticket four to an A4 page. I have registered an OpenOffice Calc document containing numbers from one to seven hundred with columns for Butt and Ticket numbers as a Registered Data Base. I am able to do a mail merge from this OpenOffice Calc to a blank Writer document (with fiddling to get them in the right places), but am unable to do a merge from the same OpenOffice Calc Registered Data Base to an Open Office Calc document set up for the tickets or a Writer document set up for the tickets in sections and columns. I cannot see how to make up the Raffle tickets on a Writer to have them four to a page other than in sections and two columns. Why not just do a table inside a writer document? Is there any additional calculation you depend on calc for this? Writer has some basic formulas too like SUM and AVERAGE. As a last resort I had thought of printing the tickets from the Calc document and then using the writer document with the merged numbers to run the tickets through the printer a second time. I have used Calc for the tickets as I find I can use that to more precisely produce four raffle tickets to an A4 sheet with a butt and a ticket. I use Calc to produce work that other members may use writer for as I find it easier to work with. Can someone offer any suggestions or advice on how to merge the numbers into the Calc document please - if this can be done. I am using Apache OpenOffice 4.1.1 on a computer with Windows 7 Professional 64 Bit. Thank you. Jean -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614
Re: MAIL MERGE TO AN OPENOFFICE CALC DOCUMENT
Hello Alexandro, I got another helpful hint from one of the references you gave and have now turned on the ViewFieldsShading which was turned off. I can now see the Next Record Bar with the fields I am inserting to know where I am up to with inserting the next record. I am very familiar with doing Mail Merges for addressing mail and writing letters but these are all one record to a page so I know I am missing one little thing somewhere along the line here with inserting four numbers to a page. I know I can ask someone next week to show me how to do it but I will try again before then to see if I can make it work. Thank you for your help. On Sun, Mar 29, 2015 at 11:03 AM, Alexandro Colorado j...@oooes.org wrote: I see, I am sorry is giving you troubles. I am not sure exactly how to reproduce the error and all I can do is forward you some tutorials. Basically the mailmerge has to do with fields, the Mailmerge Wizards is in fact a macro that assign these fields and automagically go ahead in a sequence. To debug these mailmerges you would need to go to the assigned field and see if there is something wrong being defined. Fields are very powerful and can have something more than just squence, but lso conditionals, randomizers, references, etc. We have a whole book on Fields[1] that you can learn from. But this is for your own education on the platform. To solve the issue I think you can re-build the mailmerge and go step by step (if you haven't have to). And pay close attention where the field in question is being created. Another strategy is to breakdown the merge and do the merging in sections, meaning that you would need to generate the mailmerge with only the fields that you think have issues and see if this is being repeated in isolation. If this works, then there might be some other field interrupting the process. PD: Sovleigh Haugland has an excellent tutorial on Mail Merge althought is a bit dated, it still works wonders. It explores and redescover the power of mailmerging. [2] [1]: https://wiki.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide/Working_with_Fields [2]: http://openoffice.blogs.com/openoffice/mail-merge-2009/ On Sat, Mar 28, 2015 at 7:22 PM, Jean Lear meld...@gmail.com wrote: Thank you Alexandro for the suggestion of using tables. That works with a bit of fiddling to fit to an A4 page althouh for one who has relied on Calc for years to set out work it was a bit of a learning curve. I have now encountered a separate problem with the numbering of the tickets. I have read and re read so many things about getting the next record to work but so far have only managed to number tickets 1 and 2. No other numbers appear when I do a preview to printing. If I can do it to get a number 2 to show on a ticket why can I not get other numbers to follow I ask myself? This is the reason for the delay in acknowledging the help you gave with your suggestion. I was hoping to reply saying that everything is working in Writer with tables the way I wanted it to be. On Thu, Mar 26, 2015 at 1:31 AM, Alexandro Colorado j...@oooes.org wrote: On Wednesday, March 25, 2015 03:35:21 PM Jean Lear wrote: I need to print Raffle tickets with Butt and Ticket four to an A4 page. I have registered an OpenOffice Calc document containing numbers from one to seven hundred with columns for Butt and Ticket numbers as a Registered Data Base. I am able to do a mail merge from this OpenOffice Calc to a blank Writer document (with fiddling to get them in the right places), but am unable to do a merge from the same OpenOffice Calc Registered Data Base to an Open Office Calc document set up for the tickets or a Writer document set up for the tickets in sections and columns. I cannot see how to make up the Raffle tickets on a Writer to have them four to a page other than in sections and two columns. Why not just do a table inside a writer document? Is there any additional calculation you depend on calc for this? Writer has some basic formulas too like SUM and AVERAGE. As a last resort I had thought of printing the tickets from the Calc document and then using the writer document with the merged numbers to run the tickets through the printer a second time. I have used Calc for the tickets as I find I can use that to more precisely produce four raffle tickets to an A4 sheet with a butt and a ticket. I use Calc to produce work that other members may use writer for as I find it easier to work with. Can someone offer any suggestions or advice on how to merge the numbers into the Calc document please - if this can be done. I am using Apache OpenOffice 4.1.1 on a computer with Windows 7 Professional 64 Bit. Thank you. Jean -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389
Re: Mystery messages
TNX. On 3/27/2015 4:42 PM, Dennis E. Hamilton wrote: Yes, the archive location does not appear in the footers added by the list server. All of that information, for each list, is at http://openoffice.apache.org/mailing-lists.html. - Dennis -Original Message- From: Vince B. [mailto:wa.two...@verizon.net] Sent: Friday, March 27, 2015 12:24 To: users@openoffice.apache.org Subject: Re: Mystery messages How do I get to the List Archive? I am list- registered, but have not come across Archive. Regards, Vince Sent from my iPad - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
