Re: Mail merge from spreadsheet
A pisałeś na adres: To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org pon., 25 gru 2023, 05:20 użytkownik gerdab...@bigpond.com.INVALID napisał: > Please unsubscribe me from any further mail! > > I have tried to unsubscribe several times before, but without sucess! I > still keep getting them every day! > Please acknowledge you have received, and stopped further mail. > > Regards > Gerda > > From: Dick Groskamp > Sent: Sunday, December 24, 2023 8:56 AM > To: users@openoffice.apache.org > Subject: Re: Mail merge from spreadsheet > > Or visit the wiki: > > https://wiki.openoffice.org/wiki/Documentation/How_Tos/Creating_Mail_Merge_Documents_From_Text/CSV_or_Spreadsheets > > On 2023/12/23 23:50:32 David wrote: > > Originally posted by kshan...@twcny.rr.com in a different context. > > > > > I'm not the original poster for this subject and I apologize if I'm > > > doing this wrong. > > > > > > I Have Open Office 4.1.14 and I'm having problems following the > directions below. Might be I am trying to do this starting from the wrong > place. I have a file "addresses.ods" where I have saved about 70+ > addresses. I was hoping that I could use this file to print out address > labels in the Avery 8160 format. > > > > > > First question might be is it possible to print these out using an ODS > file? > > > > > > Years ago I used Excell to keep service records at the heavy equipment > shop where I worked and had pretty good luck doing that and putting > formulas in to flag when something was due for service. > > > > Yes, you are doing it wrong; proper way would be to start a new topic. > > I've done that for you. > > > > See > > > https://www.openoffice.org/documentation/HOW_TO/word_processing/writer2_EN.html > > > > - > > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > > For additional commands, e-mail: users-h...@openoffice.apache.org > > > > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
Re: Mail merge from spreadsheet
Please unsubscribe me from any further mail! I have tried to unsubscribe several times before, but without sucess! I still keep getting them every day! Please acknowledge you have received, and stopped further mail. Regards Gerda From: Dick Groskamp Sent: Sunday, December 24, 2023 8:56 AM To: users@openoffice.apache.org Subject: Re: Mail merge from spreadsheet Or visit the wiki: https://wiki.openoffice.org/wiki/Documentation/How_Tos/Creating_Mail_Merge_Documents_From_Text/CSV_or_Spreadsheets On 2023/12/23 23:50:32 David wrote: > Originally posted by kshan...@twcny.rr.com in a different context. > > > I'm not the original poster for this subject and I apologize if I'm > > doing this wrong. > > > > I Have Open Office 4.1.14 and I'm having problems following the directions > > below. Might be I am trying to do this starting from the wrong place. I > > have a file "addresses.ods" where I have saved about 70+ addresses. I was > > hoping that I could use this file to print out address labels in the Avery > > 8160 format. > > > > First question might be is it possible to print these out using an ODS file? > > > > Years ago I used Excell to keep service records at the heavy equipment shop > > where I worked and had pretty good luck doing that and putting formulas in > > to flag when something was due for service. > > Yes, you are doing it wrong; proper way would be to start a new topic. > I've done that for you. > > See > https://www.openoffice.org/documentation/HOW_TO/word_processing/writer2_EN.html > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Mail merge from spreadsheet
Or visit the wiki: https://wiki.openoffice.org/wiki/Documentation/How_Tos/Creating_Mail_Merge_Documents_From_Text/CSV_or_Spreadsheets On 2023/12/23 23:50:32 David wrote: > Originally posted by kshan...@twcny.rr.com in a different context. > > > I'm not the original poster for this subject and I apologize if I'm > > doing this wrong. > > > > I Have Open Office 4.1.14 and I'm having problems following the directions > > below. Might be I am trying to do this starting from the wrong place. I > > have a file "addresses.ods" where I have saved about 70+ addresses. I was > > hoping that I could use this file to print out address labels in the Avery > > 8160 format. > > > > First question might be is it possible to print these out using an ODS file? > > > > Years ago I used Excell to keep service records at the heavy equipment shop > > where I worked and had pretty good luck doing that and putting formulas in > > to flag when something was due for service. > > Yes, you are doing it wrong; proper way would be to start a new topic. > I've done that for you. > > See > https://www.openoffice.org/documentation/HOW_TO/word_processing/writer2_EN.html > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Mail merge from spreadsheet
Originally posted by kshan...@twcny.rr.com in a different context. I'm not the original poster for this subject and I apologize if I'm doing this wrong. I Have Open Office 4.1.14 and I'm having problems following the directions below. Might be I am trying to do this starting from the wrong place. I have a file "addresses.ods" where I have saved about 70+ addresses. I was hoping that I could use this file to print out address labels in the Avery 8160 format. First question might be is it possible to print these out using an ODS file? Years ago I used Excell to keep service records at the heavy equipment shop where I worked and had pretty good luck doing that and putting formulas in to flag when something was due for service. Yes, you are doing it wrong; proper way would be to start a new topic. I've done that for you. See https://www.openoffice.org/documentation/HOW_TO/word_processing/writer2_EN.html - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AVERY 8160 mail merge template
I'm not the original poster for this subject and I apologize if I'm doing this wrong. I Have Open Office 4.1.14 and I'm having problems following the directions below. Might be I am trying to do this starting from the wrong place. I have a file "addresses.ods" where I have saved about 70+ addresses. I was hoping that I could use this file to print out address labels in the Avery 8160 format. First question might be is it possible to print these out using an ODS file? Years ago I used Excell to keep service records at the heavy equipment shop where I worked and had pretty good luck doing that and putting formulas in to flag when something was due for service. On 12/23/2023 5:42 PM, David wrote: Choose File | New | Labels. On the dialog that appears, there is a dropdown list for label selection; at the bottom of the dialog under Format select radio button for Sheet and under Brand, select Avery Letter Size. Then scroll down the selections in Type to find 8160. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AVERY 8160 mail merge template
richard dyke wrote: Hello: Can anyone give me some help to install AVERY 8160 label template to Apache Openoffice 4? Thanks much. Rich There is an Avery label 8160 already defined in OpenOffice Writer. Choose File | New | Labels. On the dialog that appears, there is a dropdown list for label selection; at the bottom of the dialog under Format select radio button for Sheet and under Brand, select Avery Letter Size. Then scroll down the selections in Type to find 8160. Since you are not subscribed to this list you may not see all the replies to your query. To subscribe to Apache OpenOffice mailing lists go to http://openoffice.apache.org/mailing-lists.html As a courtesy I have forwarded a copy of this reply to you as well as to the mailing list. Do Not reply to me personally but just to the list at - replies to my personal email address will be ignored. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
AVERY 8160 mail merge template
Hello: Can anyone give me some help to install AVERY 8160 label template to Apache Openoffice 4? Thanks much. Rich
RE: mail merge not working
Jonathan, the problem seems to be the two columns A and B which are hidden and empty !. They contain no data and seem to confuse AOO Base. Show the two columns again and fill one of them with an incrementing ID Remove (if possible, the remaining empty column from the spreadsheet) No need to "convert" to .odb if you choose the option "Connect to existing database" Select "Spreadsheet" in the dropdown, which opens a fileselector, so you can browse to your spreadsheet. After naming the new database it should work and you should see the table Sheet1 __ DiGro Scanned with Ziggo Safe Online (F-Secure) Windows 10 and Apache OpenOffice 4.1.7 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: mail merge not working
This is beyond frustrating. I have watched every tutorial possible. I have uninstalled open office multiple times to no avail. All I am trying to do is a mail merge where I print out labels. Every time I try this I take my open office spread sheet convert it into a open office database file but no matter what I do it does not recognize the tables and I can not do anything with the data. WHY IS THIS? Attached is the file I am trying to use. Jonathan "BJ" Hayes Realtor "THE NET ZERO ENERGY GUY" Greenergy Realty Treasure Coast Direct 772-801-9550 Unfortunately I missed your call the fastest way to contact me is at my mobile office http://bjhayes.comhttp://bjhayes.comhttp://bjhayes.com; - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
mail merge not working
This is beyond frustrating. I have watched every tutorial possible. I have uninstalled open office multiple times to no avail. All I am trying to do is a mail merge where I print out labels. Every time I try this I take my open office spread sheet convert it into a open office database file but no matter what I do it does not recognize the tables and I can not do anything with the data. WHY IS THIS? Attached is the file I am trying to use. Jonathan "BJ" Hayes Realtor "THE NET ZERO ENERGY GUY" Greenergy Realty Treasure Coast Direct 772-801-9550 Unfortunately I missed your call the fastest way to contact me is at my mobile office http://bjhayes.com<http://bjhayes.com><http://bjhayes.com> ND4.odb Description: ND4.odb psl southbend vacant lots 07232020.ods Description: psl southbend vacant lots 07232020.ods - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Mail Merge
I had this problem with mail merges until I found that when I was ready to print the merged documents and opened the Print window there are a number of tabs at the top - General - OpenOffice Writer - Page Layout - Options. Go to the OpenOffice Writer and the last item on this sheet is Page - with a tick box for Print automatic inserted blank pages. If there is a tick in the tick box remove it and this should solve the problem. I know there are hundreds of different printers and various operating systems but I always see the same window come up for both Canon and Brother printers I have. I have been using various versions of Windows from 95 to 10. The earlier versions I cannot speak for but know this has been the same in 7 and 10. Hope this helps. On Thu, Aug 23, 2018 at 4:29 AM Leora Berns < outlook_d084b1d5dc526...@outlook.com> wrote: > I have a lot of experience using Mail Merge with Windows. > > The past few times I have used Mail Merge in Apache Open Office I get the > following problem: After each page of print, a blank page is spit out of > the computer. So if I have 98 records, I get 196 pages. Every other one is > blank. > > When I look at the document I’m printing from, I only see the original 98 > records. But when I scroll through it, the first record is 1/196, the > second page is 3/196, the third is 5/196, etc. > > Obviously I’ve formatted something but I don’t know where. > > Any suggestions? > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > >
Mail Merge
I have a lot of experience using Mail Merge with Windows. The past few times I have used Mail Merge in Apache Open Office I get the following problem: After each page of print, a blank page is spit out of the computer. So if I have 98 records, I get 196 pages. Every other one is blank. When I look at the document I’m printing from, I only see the original 98 records. But when I scroll through it, the first record is 1/196, the second page is 3/196, the third is 5/196, etc. Obviously I’ve formatted something but I don’t know where. Any suggestions? Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
mail merge - how to detach data after mail merge when printing to file
Hello, I have set up my mail merge correctly so that I merge data to a letter from a spreadsheet. I print them to individual files. However, the data is then still attached to the spreadsheet and I can’t seem to disconnect it. Sometimes I need to format the information after it’s inputted, but I can’t. Not only that, when I send the files to other people, they can’t see the information. Please help! Thank you, Patty
Re: Mail Merge - Missing Sheet in Data Base
At 15:41 29/07/2016 -0400, Liliane Sklenarik wrote: I have Open Office 4.1.2 and I use Windows 7. I have been trying to use Mail Merge. I get to the point where I have registered my data base (an Excel Spread Sheet). Under the data base file it should show all the sheets in the file to choose one. I only have 2 sheets. The active addresses and a Blank sheet I use to print out and hand write in new addresses when I hold a class. The only sheet that will show up is the Blank sheet. This sheet shows all the fields (but, of course, the information in the columns is blank). I can not get the active sheet with the addresses on it to show up so I can select it. I have deleted the Blank sheet - then I don't get any sheets to show up. I have saved the spread sheet as a .xls and as a .ods file. This has been very frustrating and I have tried to do this for years. Don't know what to do about it. Please help. I know little about this, but a little experimentation suggests that sheets of a spreadsheet will not be recognised by the Address Data Source... wizard or the database registration process if they do not appear to be in a suitable format. If, for example, I displace valid data across or down the sheet by preceding it with blank rows or columns, the sheet will be disregarded and not appear as a candidate for data - as you describe. Have you perhaps arranged your sheet of addresses with titling and spacing designed to appear as you wish on a printout? Is it that which has confused the data sources facility into not seeing your data sheet as a valid table? The Mail Merge facility will generally be expecting your data source to be simply that: field names in row 1 starting in column A and data in rows 2 onward. If this is your problem, you may wish to consider this: o Construct sheets 1 and 2 as you already have - as the two to be printed. o Select just the actual address data on sheet1, copy it, and paste it into sheet 3 but using Paste Special instead of ordinary Paste and ticking the Link option. This will create a copy of the address data on sheet 3 which will automatically update as you edit sheet 1. o Add column headings as field names to sheet 3 if necessary. o Construct print ranges to include both sheets 1 and 2 (but not 3). Now if you print your document, only sheet 1 and 2 will print. When using Mail Merge, harvest your data from the new sheet 3. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Mail Merge - Missing Sheet in Data Base
Hello, I have Open Office 4.1.2 and I use Windows 7. I have been trying to use Mail Merge. I get to the point where I have registered my data base (an Excel Spread Sheet). Under the data base file it should show all the sheets in the file to choose one. I only have 2 sheets. The active addresses and a Blank sheet I use to print out and hand write in new addresses when I hold a class. The only sheet that will show up is the Blank sheet. This sheet shows all the fields (but, of course, the information in the columns is blank). I can not get the active sheet with the addresses on it to show up so I can select it. I have deleted the Blank sheet - then I don't get any sheets to show up. I have saved the spread sheet as a .xls and as a .ods file. This has been very frustrating and I have tried to do this for years. Don't know what to do about it. Please help. Liliane Sklenarik -- KaleidoQuilt "Connecting Colors" Quilt Art by Liliane Sklenarik www.KaleidoQuilt.com "Afraid of a little COLOR?" Can't commit to painting the whole room? Quilt Art is versatile and can add a "POP" of Color. I could NEVER make THAT...YES YOU CAN! Classes include machines, tools and hand holding.
Re: MAIL MERGE TO AN OPENOFFICE CALC DOCUMENT
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 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
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: MAIL MERGE TO AN OPENOFFICE CALC DOCUMENT
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 signature.asc Description: This is a digitally signed message part.
MAIL MERGE TO AN OPENOFFICE CALC DOCUMENT
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. 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 Problem
On Jan 19, 2015, at 16:48, sueabb...@yahoo.com.INVALID wrote: I have been trying to practice Mail Merge in order to help a friend with some office work. When I click on Mail Merge Wizard, I am unable to scroll down to the bottom of the page in order to click on next. There is no scroll bar, nor can I use my up and down arrows or Page Up or Page Down. I It’s almost like the box that opened up is too big for my screen, and I see no was to make it smaller. Please help. Thank you, Sue Abbiss I've also had problems with mail merge - in particular when I want to create a label with some constant material and some material inserted from the data file. Short version; I gave up and want to Excel which was not much easier to config, but at least worked. — jt - j...@jt-mj.net Just look at it this way...not matter how bad Linux can get, it's still better than a 'stable' version of Windows 7. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Mail Merge Problem
I have been trying to practice Mail Merge in order to help a friend with some office work. When I click on Mail Merge Wizard, I am unable to scroll down to the bottom of the page in order to click on next. There is no scroll bar, nor can I use my up and down arrows or Page Up or Page Down. I It’s almost like the box that opened up is too big for my screen, and I see no was to make it smaller. Please help. Thank you, Sue Abbiss
About the Mail Merge Wizard... tool
Hello, My pleasure to contact you!!! Well, I would like to know about OpenOffice tool called Mail Merge Wizard. I created a new file by the OpenOfice Writer, created two or more columns for page, clicked in Tools, clicked in Mail Merge Wizard..., selected a document type like a Letter, selected an Address List, included an address block, uncreated a salutation..., selected Save merged document, selected Save as single document... My questions are: Is it correct a white page for each page created by tool? (without salutation) Is it correct only the first column filled by tool? Thx, Givaldo. PS: Sorry, by my poor english.
Re: About the Mail Merge Wizard... tool
There are simple or complex ways to do it, the complex way allows you more granularity of the merge: http://openoffice.blogs.com/openoffice/2007/01/mail_merge_in_o.html On 10/6/14, julio...@ibest.com.br julio...@ibest.com.br wrote: Hello, My pleasure to contact you!!! Well, I would like to know about OpenOffice tool called Mail Merge Wizard. I created a new file by the OpenOfice Writer, created two or more columns for page, clicked in Tools, clicked in Mail Merge Wizard..., selected a document type like a Letter, selected an Address List, included an address block, uncreated a salutation..., selected Save merged document, selected Save as single document... My questions are: Is it correct a white page for each page created by tool? (without salutation) Is it correct only the first column filled by tool? Thx, Givaldo. PS: Sorry, by my poor english. -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Mail Merge and Email
Hello: I've used Open office for a long time but the help forums...I cannot get what I want to do to work Sending a single email or multiple emails/single document from MailMerge... It keeps telling me to set an association. No matter what Ive tried that message block pops up and Open Office crashes. I have version 4.1 Got any Ideas.. I know your busy but I might get it better with a phone call 603-361-3349 Garry Haworth Manchester NH USA --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
Re: Mail Merge and Email
As you are not subscribed I have copied you. Make sure you subscribe in order to see all answers. On 16-8-2014 22:35, garry + pauline haworth wrote: Hello: I've used Open office for a long time but the help forums...I cannot get what I want to do to work Sending a single email or multiple emails/single document from MailMerge... It keeps telling me to set an association. Under Windows set your default mail program in Control Panel ... Default Programs No matter what Ive tried that message block pops up and Open Office crashes. No matter what you have tried is not the same as telling us what you have tried. Please be more specific. I have version 4.1 Got any Ideas.. I know your busy but I might get it better with a phone call 603-361-3349 Garry Haworth Manchester NH USA --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: mail merge help
Yes, it is possible. OpenOffice has programming ability and can do automation. The grammar of the programming language is similar to BASIC. 2014-06-29 11:08 GMT+08:00 Julian Thomas j...@jt-mj.net: I have a template with fixed graphics and text and a text box frame to make up some labels. It is a table with two columns and 5 rows; each cell is identical [until I enter text in the text box] Is there any way that I can make this template into labels and use it in a mail merge? -- -- -- jt http://jt-mj.net A 2 year old's answer to everything: No! You can learn a lot from a 2 year old - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Empty fields in mail merge/labels.
A client asked me a question I am unable to answer, or find definite information about. I suspect the answer will be not possible, but wanted to check with you folks first. In mail merge and labels there is a work-around to skip empty lines, but is there a hack to skip empty fields within an otherwise populated line? The data file includes: Title, Firstname, Joint, Partner, Surname, Label, Address1, Address2, Suburb, State, Postcode. Assuming a label design: Title, Firstname, Joint, Partner, Surname, Address1 Address2 Suburb, State Postcode. Some recipients have partners and some do not. The field Joint inserts and Mrs. Some have house or property names which go in Address1. Fully populated fields result in: Mr Alpha and Mrs Bravo Smith The Place 1 High Street Somewhere Here 1234 But empty Joint, Partner Address1 fields for single people results in: Mr Alpha (space) (space) (space) Smith 1 High Street Somewhere Here 1234 FWIW. I am told (not been able to check) that in MS Works all empty fields are skipped. The solution I put forward was to put the partner name on a separate line, left blank when not needed, but this does not satisfy the client's requirements. Any other thoughts, suggestions or pointers to a solution would be welcome. TIA Dave --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Empty fields in mail merge/labels.
You need Conditional text for each field that could be empty. When you have an empty field you also need to make the space between the words conditional. For empty paragraphs an Hidden Paragraph (don't forget to deselect the View Hidden Paragraph). The fields and conditions are shown below, for readability I have each field on separate lines. *Title* *Firstname* Conditional text Insert Function Conditional text Condition: /{your doc}.{your sheet}.Joint EQ / Then: // Else: /and / *Joint* Conditional text Insert Function Conditional text Condition: /{your doc}.{your sheet}.Joint EQ / Then: // Else: / / Conditional text Insert Function Conditional text Condition: /{your doc}.{your sheet}.Partnert EQ / Then: // Else: / / *Partner* Conditional text Insert Function Conditional text Condition: /{your doc}.{your sheet}.Partnert EQ / Then: Else: *Surname* *Address1* Conditional text Insert Function Hidden Paragraph Condition: /{your doc}.{your sheet}.Address2 EQ / *Address2* *Suburb* *State* *Postcode* On 23-4-2014 2:24, Dave Barton wrote: A client asked me a question I am unable to answer, or find definite information about. I suspect the answer will be not possible, but wanted to check with you folks first. In mail merge and labels there is a work-around to skip empty lines, but is there a hack to skip empty fields within an otherwise populated line? The data file includes: Title, Firstname, Joint, Partner, Surname, Label, Address1, Address2, Suburb, State, Postcode. Assuming a label design: Title, Firstname, Joint, Partner, Surname, Address1 Address2 Suburb, State Postcode. Some recipients have partners and some do not. The field Joint inserts and Mrs. Some have house or property names which go in Address1. Fully populated fields result in: Mr Alpha and Mrs Bravo Smith The Place 1 High Street Somewhere Here 1234 But empty Joint, Partner Address1 fields for single people results in: Mr Alpha (space) (space) (space) Smith 1 High Street Somewhere Here 1234 FWIW. I am told (not been able to check) that in MS Works all empty fields are skipped. The solution I put forward was to put the partner name on a separate line, left blank when not needed, but this does not satisfy the client's requirements. Any other thoughts, suggestions or pointers to a solution would be welcome. TIA Dave --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Mail Merge Problems with Printing
Hello Andrea, Thank you very much. I have read the quoted bug report and have done a test of highlighting all the names in the data base file and have watched it go from 1 to 83 in the numbers at the bottom of the list of names. As I do not want to print these all again now I changed it to print to file. I was able to see that it saved all 83. I will get the mail merge printing done in half the time next month. Once again thank you very much. Regards, Jean On Mon, Mar 3, 2014 at 2:40 AM, Andrea Pescetti pesce...@apache.org wrote: On 25/02/2014 Jean Lear wrote: The most recent merge was set up to print out eighty three insert sheets. ... Things go well until about forty inserts are printed when the printer stops. Could it be related to this known bug? https://issues.apache.org/ooo/show_bug.cgi?id=22831 Regards, Andrea.
Re: Mail Merge Problems with Printing
On 25/02/2014 Jean Lear wrote: The most recent merge was set up to print out eighty three insert sheets. ... Things go well until about forty inserts are printed when the printer stops. Could it be related to this known bug? https://issues.apache.org/ooo/show_bug.cgi?id=22831 Regards, Andrea. --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Java Troubles When Trying to Use Mail Merge ODD CLAIMS!!!
On 11/14/2013 02:51 PM, Dr Donald Zarlengo wrote: Comment based on years of running NASA Top Security and Networked Supercomputer to desktop Experiences. WE HAD A 20 TO ONE FAILURE RATE OF WINDOWS COMPUTER VS MACINTOSH - BUT THE PROBLEMS ON THE MACS WHERE ALMOST ALWAYS NOT SERIOUS. JUST A USER NEEDING SOME ASSISTANCE. That is likely true but does neither belong to the original thread nor at this mailing list. Again, please stop OT discussions. Usually this results in subscribers, who solely interested in the main topic of the ML, leaving. Thanks Peter Plus Higher Ed Experience with the same performance from MS. If you do not want to hear the truth. You can not read my comments. CONFIDENTIALITY NOTICE: This e-mail message (including attachments) is covered by the Electronic Communications Privacy Act, 18 U. S. C. 2510-2521 and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any unauthorized review, use, disclosure, dissemination, copying, forwarding or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are the intended recipient but do not wish to receive communication through this medium, please so advise the sender immediately. On Nov 13, 2013, at 9:20 PM, Andrew Douglas Pitonyak and...@pitonyak.org wrote: Despite Dr. Zarlenga's odd claims, I do believe that it is possible to run Java on Windows. I happen to use Linux, so anything that I say is of course suspect. A few questions for you. 1. What version of AOO are you using? 4.x? For version 3.x, you need Java 6, for AOO 4, you can use 7. 2. What vesrion of Java. Note that I believe that AOO can only use a 32-bit version of Java, not a 64-bit version. 3. Somewhere under Tools Options you can tell AOO where your Java is installed. This must be set I believe. I cannot check the actual path at the moment (since I don't have AOO installed on the machine I am using now). There are some comments here: http://www.openoffice.org/development/releases/4.0.0.html On 11/13/2013 07:35 PM, jjb i.e. Just Jeff Butler wrote: Hello! I've used Open Office for some time now and LOVE IT! I haven't tried using the Mail Merge Wizard feature until today and it kept telling me that I needed Java to run it. I had previously removed Java from my computer because of the problems with it. Anyway, I reinstalled it to try and get Mail Merge to work. Unfortunately, I still can't complete the merge. It can't seem to find Java. I am using Windows 7, 64-bit. Thank you in advance for anything you can do for me. Jeff B. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Java Troubles When Trying to Use Mail Merge ODD CLAIMS!!!
This is an user mailing list for Apache OpenOffice where we like to communicate about user experiences / issues with this application. Your comments are much appreciated as long as they are relevant for Apache OpenOffice. On 14-11-2013 17:51, Dr Donald Zarlengo wrote: Comment based on years of running NASA Top Security and Networked Supercomputer to desktop Experiences. WE HAD A 20 TO ONE FAILURE RATE OF WINDOWS COMPUTER VS MACINTOSH - BUT THE PROBLEMS ON THE MACS WHERE ALMOST ALWAYS NOT SERIOUS. JUST A USER NEEDING SOME ASSISTANCE. Plus Higher Ed Experience with the same performance from MS. If you do not want to hear the truth. You can not read my comments. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Java Troubles When Trying to Use Mail Merge ODD CLAIMS!!!
Peter Junge: Again, please stop OT discussions. Why do you discuss with the obviously mental person? Just ignore him. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Java Troubles When Trying to Use Mail Merge ODD CLAIMS!!!
On 11/14/2013 05:31 PM, Urmas wrote: Peter Junge: Again, please stop OT discussions. Why do you discuss with the obviously mental person? Just ignore him. It's my job to not ignore this because I'm one of the moderators of his list hence I need to send reminders to comply with the scope of the list. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Java Troubles When Trying to Use Mail Merge ODD CLAIMS!!!
All I can surmise, is that one of you is interested in having inter-operability of files, and file structures with OpenOffice. Donald Zarlenga Ph.D. CONFIDENTIALITY NOTICE: This e-mail message (including attachments) is covered by the Electronic Communications Privacy Act, 18 U. S. C. 2510-2521 and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any unauthorized review, use, disclosure, dissemination, copying, forwarding or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are the intended recipient but do not wish to receive communication through this medium, please so advise the sender immediately. On Nov 14, 2013, at 1:29 AM, Martin Groenescheij mar...@groenescheij.com wrote: This is an user mailing list for Apache OpenOffice where we like to communicate about user experiences / issues with this application. Your comments are much appreciated as long as they are relevant for Apache OpenOffice. On 14-11-2013 17:51, Dr Donald Zarlengo wrote: Comment based on years of running NASA Top Security and Networked Supercomputer to desktop Experiences. WE HAD A 20 TO ONE FAILURE RATE OF WINDOWS COMPUTER VS MACINTOSH - BUT THE PROBLEMS ON THE MACS WHERE ALMOST ALWAYS NOT SERIOUS. JUST A USER NEEDING SOME ASSISTANCE. Plus Higher Ed Experience with the same performance from MS. If you do not want to hear the truth. You can not read my comments. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Java Troubles When Trying to Use Mail Merge
On Thu, 14 Nov 2013 00:35:43 -, jjb i.e. Just Jeff Butler justje...@yahoo.com wrote: I've used Open Office for some time now and LOVE IT! I haven't tried using the Mail Merge Wizard feature until today and it kept telling me that I needed Java to run it. I had previously removed Java from my computer because of the problems with it. Anyway, I reinstalled it to try and get Mail Merge to work. Unfortunately, I still can't complete the merge. It can't seem to find Java. I am using Windows 7, 64-bit. java 7 seems to depend on visual c++ redistributable 2010, so you may need to download and install it if it has not been installed yet. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Java Troubles When Trying to Use Mail Merge
Windows is your problem! When have we ever observed MS to make major jumps in technology? As did Steve Jobs did with Apple. MS makes small increments, thus dragging along problems that resides in their code. I have not heard anything that says they have changed their mode in technology. Don Donald Zarlenga Ph.D. zarle...@me.com CONFIDENTIALITY NOTICE: This e-mail message (including attachments) is covered by the Electronic Communications Privacy Act, 18 U. S. C. 2510-2521 and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any unauthorized review, use, disclosure, dissemination, copying, forwarding or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are the intended recipient but do not wish to receive communication through this medium, please so advise the sender immediately. On Nov 13, 2013, at 4:35 PM, jjb i.e. Just Jeff Butler justje...@yahoo.com wrote: Hello! I've used Open Office for some time now and LOVE IT! I haven't tried using the Mail Merge Wizard feature until today and it kept telling me that I needed Java to run it. I had previously removed Java from my computer because of the problems with it. Anyway, I reinstalled it to try and get Mail Merge to work. Unfortunately, I still can't complete the merge. It can't seem to find Java. I am using Windows 7, 64-bit. Thank you in advance for anything you can do for me. Jeff B.
Re: Java Troubles When Trying to Use Mail Merge
Despite Dr. Zarlenga's odd claims, I do believe that it is possible to run Java on Windows. I happen to use Linux, so anything that I say is of course suspect. A few questions for you. 1. What version of AOO are you using? 4.x? For version 3.x, you need Java 6, for AOO 4, you can use 7. 2. What vesrion of Java. Note that I believe that AOO can only use a 32-bit version of Java, not a 64-bit version. 3. Somewhere under Tools Options you can tell AOO where your Java is installed. This must be set I believe. I cannot check the actual path at the moment (since I don't have AOO installed on the machine I am using now). There are some comments here: http://www.openoffice.org/development/releases/4.0.0.html On 11/13/2013 07:35 PM, jjb i.e. Just Jeff Butler wrote: Hello! I've used Open Office for some time now and LOVE IT! I haven't tried using the Mail Merge Wizard feature until today and it kept telling me that I needed Java to run it. I had previously removed Java from my computer because of the problems with it. Anyway, I reinstalled it to try and get Mail Merge to work. Unfortunately, I still can't complete the merge. It can't seem to find Java. I am using Windows 7, 64-bit. Thank you in advance for anything you can do for me. Jeff B. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Java Troubles When Trying to Use Mail Merge ODD CLAIMS!!!
Comment based on years of running NASA Top Security and Networked Supercomputer to desktop Experiences. WE HAD A 20 TO ONE FAILURE RATE OF WINDOWS COMPUTER VS MACINTOSH - BUT THE PROBLEMS ON THE MACS WHERE ALMOST ALWAYS NOT SERIOUS. JUST A USER NEEDING SOME ASSISTANCE. Plus Higher Ed Experience with the same performance from MS. If you do not want to hear the truth. You can not read my comments. CONFIDENTIALITY NOTICE: This e-mail message (including attachments) is covered by the Electronic Communications Privacy Act, 18 U. S. C. 2510-2521 and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any unauthorized review, use, disclosure, dissemination, copying, forwarding or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are the intended recipient but do not wish to receive communication through this medium, please so advise the sender immediately. On Nov 13, 2013, at 9:20 PM, Andrew Douglas Pitonyak and...@pitonyak.org wrote: Despite Dr. Zarlenga's odd claims, I do believe that it is possible to run Java on Windows. I happen to use Linux, so anything that I say is of course suspect. A few questions for you. 1. What version of AOO are you using? 4.x? For version 3.x, you need Java 6, for AOO 4, you can use 7. 2. What vesrion of Java. Note that I believe that AOO can only use a 32-bit version of Java, not a 64-bit version. 3. Somewhere under Tools Options you can tell AOO where your Java is installed. This must be set I believe. I cannot check the actual path at the moment (since I don't have AOO installed on the machine I am using now). There are some comments here: http://www.openoffice.org/development/releases/4.0.0.html On 11/13/2013 07:35 PM, jjb i.e. Just Jeff Butler wrote: Hello! I've used Open Office for some time now and LOVE IT! I haven't tried using the Mail Merge Wizard feature until today and it kept telling me that I needed Java to run it. I had previously removed Java from my computer because of the problems with it. Anyway, I reinstalled it to try and get Mail Merge to work. Unfortunately, I still can't complete the merge. It can't seem to find Java. I am using Windows 7, 64-bit. Thank you in advance for anything you can do for me. Jeff B. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org