Re: [libreoffice-users] Mail merge formatting
Hi Steve, Steve Edmonds wrote (07-07-11 21:28) I am trying to perform a mail merge with numbers but can't seem to control the number format. I am merging with a .ods sheet with data. I have formatted the numbers in the sheet but in writer the formatting changes. 3.0012 prints as 3, 0.497 prints as 0.50 and 423.56 prints as 423.56. How do I control the formatting on a merge, do I need to convert numbers to text. The properties of the mail merge field (can be accessed via the context menu when the cursor is just in front) allows to set this. Regards, -- - Cor - http://nl.libreoffice.org -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail merge formatting
On 8/07/11 7:35 AM, Cor Nouws wrote: Hi Steve, Steve Edmonds wrote (07-07-11 21:28) I am trying to perform a mail merge with numbers but can't seem to control the number format. I am merging with a .ods sheet with data. I have formatted the numbers in the sheet but in writer the formatting changes. 3.0012 prints as 3, 0.497 prints as 0.50 and 423.56 prints as 423.56. How do I control the formatting on a merge, do I need to convert numbers to text. The properties of the mail merge field (can be accessed via the context menu when the cursor is just in front) allows to set this. Regards, Thanks. I didn't see this the first time I looked. I may have had the cursor in the wrong place. The mail merge is working well and pleasantly easy to use. steve -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail merge formatting
Steve Edmonds steve.edmo...@ptglobal.com writes: Hi. I am trying to perform a mail merge with numbers but can't seem to control the number format. The mailmerge tool is too buggy to be used. -- html messages are obsolete -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail merge formatting
Hi Lee, lee wrote (07-07-11 23:06) Steve Edmondssteve.edmo...@ptglobal.com writes: I am trying to perform a mail merge with numbers but can't seem to control the number format. As you may have seen, Steve is both helped and happy. The mailmerge tool is too buggy to be used. Hmm, such a comment does not seem so helpful ;-) But OK, I can understand some level of frustration. I work with mail merge for years, and oh so often had to file bugs when a new (beta) version of OpenOffice.org was made available. Luckily, many problems were solved fine, and I am able to do most of my work without problem. Obviously because I know how to find my way and have the attitude to work with clean documents and data. But OK, it works. ( Which does not mean that both in the OOo bugTracker and in that one of LibreOffice, there can be found quite some issues and RFE for MailMerge. ) HTH, Cor -- - Cor - http://nl.libreoffice.org -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail merge formatting
Cor On Thu, 2011-07-07 at 23:31 +0200, Cor Nouws wrote: Hi Lee, lee wrote (07-07-11 23:06) Steve Edmondssteve.edmo...@ptglobal.com writes: I am trying to perform a mail merge with numbers but can't seem to control the number format. As you may have seen, Steve is both helped and happy. The mailmerge tool is too buggy to be used. Hmm, such a comment does not seem so helpful ;-) But OK, I can understand some level of frustration. I work with mail merge for years, and oh so often had to file bugs when a new (beta) version of OpenOffice.org was made available. Luckily, many problems were solved fine, and I am able to do most of my work without problem. Obviously because I know how to find my way and have the attitude to work with clean documents and data. But OK, it works. ( Which does not mean that both in the OOo bugTracker and in that one of LibreOffice, there can be found quite some issues and RFE for MailMerge. ) HTH, Cor -- - Cor - http://nl.libreoffice.org To follow up on mail merge, it is a functionality I use just often enough to sort of know what I doing but can not remember the exact steps I need to do. Thus, I am always frustrated with a properly working functionality. It is always back to the documentation for me. -- Jay Lozier jsloz...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail merge formatting
Cor Nouws oo...@nouenoff.nl writes: Hi Lee, lee wrote (07-07-11 23:06) Steve Edmondssteve.edmo...@ptglobal.com writes: I am trying to perform a mail merge with numbers but can't seem to control the number format. As you may have seen, Steve is both helped and happy. Yes, and I'm happy when it works for him :) The mailmerge tool is too buggy to be used. Hmm, such a comment does not seem so helpful ;-) The idea behind the comment is that he might spend a lot of time to get it set up the way he needs it just to find out that the mailmerge tool doesn't work. So when he knows that it doesn't work, he might test it before wasting time, or find another way. But OK, I can understand some level of frustration. I work with mail merge for years, and oh so often had to file bugs when a new (beta) version of OpenOffice.org was made available. Luckily, many problems were solved fine, and I am able to do most of my work without problem. Obviously because I know how to find my way and have the attitude to work with clean documents and data. But OK, it works. Well, I tried it and found that it would sometimes send mails and sometimes not, that it messes up the PDF which is just fine when exported manually or by a macro and that modifying the Properties of the messages to be sent crashes LO. Besides that, some other bugs turned up so that I consider LO to be in some alpha stage. Some level of frustration isn't so crucial. Crucial is getting the results one needs. That bugs may be fixed some time in the future is a good thing, yet it doesn't help me much when I need the results now. I'm getting them with LaTeX now. The difference is that trying with LO lead to finding bugs and to things getting more and more difficult, while trying with LaTeX lead to progress, to things getting easier and to results. Both ways involved frustration, of course. Anyway, I'm surprised that mailmerge works for you. I could have used it if it worked. -- html messages are obsolete -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
