Hello Alexandro, I have spent a lot of time trying to get mail merge to put numbers on the raffle tickets I am trying to produce since my last e mail. Years ago I started to keep items from the Forum that I thought would be helpful to me. I thought today that I would go back and see what I could find there about mail merges and came across something from Apr 06 when someone asked for help in printing numbers on four raffle tickets to a page. It was written for OO 2.0 and went about it in a very different way to what I had been trying to make work. The instructions are at -
http://www.oooforum.org/forum/viewtopic.phtml?t=34641 I thought I would send this on in case it would be of help to anyone else who could not make more recent instructions work for them. Thank you for your help getting me onto using OpenOffice Writer. On Sun, Mar 29, 2015 at 3:14 PM, Jean Lear <meld...@gmail.com> wrote: > 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 >> > >
