Re: [libreoffice-users] More mailmerge woes
Herr Säger, you may have hit the nail on the head, thank you. Yes, even though my query was correctly displayed as the driving data for the document (of course, since I'm using mailmerge, this is a Writer document that has the problem), when I went through the "Change datasource" dialogue/wizard, it showed a different database as the source, weird! And that is a *fabulous* feature in Writer, just dragging the column onto the page, fabulous. However, there was still one problem remaining which I have fixed by changing the field name "Company" to "Co". Whether I allowed MySQL to produce the fieldname or explicitly speciifed it with an alias, Base would insert the field as "company" (lowercase first letter), and it would therefore display the fieldname not the field contents, because the query wasn't producing a field with that name! "Company" is a reserved word somehow? Surely not! Many thanx Mark Stanton One small step for mankind... -- 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] More mailmerge woes
> The File / Print menu will ask if you want to print a mail merge. Just > say yes then enjoy the olde OOo v1 wizard. So it does! That's cute. Unfortunately it only lists tables as data sources, and mine is a query :-( Mark Stanton One small step for mankind... -- 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] More mailmerge woes
Le 16/03/2012 20:15, Mark Stanton a écrit : The only wizard I've used on this is the mailmerge wizard, which I can't avoid (can I?) Yes, you can ;-) The File / Print menu will ask if you want to print a mail merge. Just say yes then enjoy the olde OOo v1 wizard. -- Jean-Francois Nifenecker, Bordeaux -- 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] More mailmerge woes
And to cover the other points not in my reply below, no there are no special characters in the field names. I'm not certain if fields from queries could be the cause, but it seems unlikely since the first line works. Great ideas, thanks! Mark Stanton One small step for mankind... -- 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] More mailmerge woes
Thanks for all of this. The only wizard I've used on this is the mailmerge wizard, which I can't avoid (can I?) Is that the only "manual", or is there a way to edit the file more manually than that, presumably not through Writer. Is it just xml? Yes, every line has a conditional paragraph field at the beginning of it. A couple of them probably don't need it, every address label will almost ceratinly have some kind of person's name for example, but I put it there anyway. They seem to be in the right place (before the database field) and contain the right conditions. I could see them when I turned on "view field names", and that let me look at their properties more easily. These problems show up without an expert to pdf, I see them just at the "Edit document" stage of the mailmerge wizard, although I also went to the next stage, and they do appear there too. Mark Stanton One small step for mankind... -- 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] More mailmerge woes
Mark Stanton wrote (16-03-12 14:19) The problem I'm having is that the person's name is the only line that is printed with the contents of the fields! All the other The wizard places new lines (Sht-Enter) after each field, so effectively more of your fields are in the line with the condition. Editing the label manually and use Enter will help :-) Cheers, -- - Cor - http://nl.libreoffice.org -- 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] More mailmerge woes
On Friday 16 March 2012, 13:19:42 Mark Stanton wrote: > [field name shown instead of content] > > Any ideas? 1) Did you try to edit the field properties and change its source by editing it manually instead of clicking? (If I remember correctly, there has been a similar bug in OOo middle age, that db fields entered by drag&drop from the db browser did not work after saving the file and opening it again. They had to be edited manually to stay permanent). 2) are there any special characters in table/query names? 3) Maybe, fields from queries cause problems while table fields do not? (just some ideas from earlier work, I have no actual experience) BTW, which LibO version do you use? On what platform? Nino -- 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