[libreoffice-users] Re: Need Help AGAIN with Mail Merge
Am 24.06.2012 23:21, Charles218 wrote: Tom, I checked the View - Fields command and it is not enabled. The view status of the place holders should not matter at all. It toggles between Field Name and Database.Table.Field Name. The latter lets you prove that each field is connected to the right source. I can not reproduce your problem with a plain text connected database and LibreOffice 3.5 under Linux. Here is a screen shot of what I see when using the F4 key. http://nabble.documentfoundation.org/file/n3992018/View_Using_F4.jpg And here is what I get when using the print dialog. http://nabble.documentfoundation.org/file/n3992018/View_Using_Print_Dialog.jpg From that screen you call the print command (Ctrl+P) Then you are prompted if you are going to print a serial letter which should be confirmed. Then you see a huge dialog with another instance of the data source window on top, a section where you choose the selection mode for the records (All displayed records | selected | from...to) and the output medium (printer, document or one document per record). Some of these options suffer from the same old bugs since years, but printing _all_displayed_records_ into a _single_document_ should always work. If your table has only one record or when you want to print only one record out of many records, you can - switch the fields to show the names (ViewField Names) - Click the row selector (grey box in front of each record) in order to select the record in the data source window. - Click the data-to-fields button in the data source window. Now the fields display the actual data of the selected record. - Print (Ctrl+P) - Do not confirm the serial print. Just print the document as shown. The placeholders are never replaced with the data from the source file. I can follow through and either print or save the document, but the data never appears in the print or the saved file. Before someone drops in with some absurd assumptions about Java: All this works without any Java. Hope this helps, A.S. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Need Help AGAIN with Mail Merge
Andreas, In going through the print procedure again, this time following your step by step directions, I believe that the problem is solved. There are two ways to get to the mail merge area, one is by using the Print command and responding yes to the do you want to print a form letter dialog. The second way is by simply clicking on the F4 function key. If I use the print command and then select the data source, the Data to Fields icon is greyed out. When using the F4 key and then selecting the data source, the Data to Fields option works. That was probably the case all along though I missed it. Problem Solved! Now that this is solved, and I something to work with for awhile, I will begin to work on the ODBC solution. Thanks again for taking the time to help!!! Charles -- View this message in context: http://nabble.documentfoundation.org/Need-Help-AGAIN-with-Mail-Merge-tp3992012p3992194.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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] Re: Need Help AGAIN with Mail Merge
Thank you to all of you who answered Charles' question, I asked more or less the same some weeks ago, got many useful answers (thank you Andreas) but it was only today that I discovered the F4 button, which works great. Another query about the same functionality, does anyone know why you end up, once your merging is finished, with a wrong count of pages. If you create, say 5 letters to 5 different persons, the page count will show 10 instead of 5 and if you print the document a blank page will be inserted between each page with data. Thank you for your answers, G. Siche -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Need Help AGAIN with Mail Merge
Am 25.06.2012 21:49, Gilles SICHE wrote: Thank you to all of you who answered Charles' question, I asked more or less the same some weeks ago, got many useful answers (thank you Andreas) but it was only today that I discovered the F4 button, which works great. Another query about the same functionality, does anyone know why you end up, once your merging is finished, with a wrong count of pages. If you create, say 5 letters to 5 different persons, the page count will show 10 instead of 5 and if you print the document a blank page will be inserted between each page with data. Thank you for your answers, G. Siche This has something to do with the layout of left pages (even page numbers) and right pages (odd page numbers). I'm not entirely sure about the right setup but I think you have to set the page style to right page only. Greetings, A.S. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Need Help AGAIN with Mail Merge
Turn off View---Field names. It sounds like you have this toggled on. - Tom K. -- View this message in context: http://nabble.documentfoundation.org/Need-Help-AGAIN-with-Mail-Merge-tp3992012p3992015.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
[libreoffice-users] Re: Need Help AGAIN with Mail Merge
Tom, I checked the View - Fields command and it is not enabled. Here is a screen shot of what I see when using the F4 key. http://nabble.documentfoundation.org/file/n3992018/View_Using_F4.jpg And here is what I get when using the print dialog. http://nabble.documentfoundation.org/file/n3992018/View_Using_Print_Dialog.jpg The placeholders are never replaced with the data from the source file. I can follow through and either print or save the document, but the data never appears in the print or the saved file. Charles -- View this message in context: http://nabble.documentfoundation.org/Need-Help-AGAIN-with-Mail-Merge-tp3992012p3992018.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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