Hello Alexandro, I got another helpful hint from one of the references you gave and have now turned on the View>Fields>Shading 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 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614 >
