Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-10 Thread Paul D. Mirowsky
Might I suggest placement within a query based on database of stamp image. 1 for 1st class, otherwise 0. Then use query in form. On 2/5/2012 9:56 AM, Mark Stanton wrote: Ok, I've got mailmerge working, fairly well, ish. It seems a little unhelpful that the view field names overrides

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
Yup, same here. I found nice manuals, but all just basic ones (not Basic), and no macros. The forum post looks like it's got some useful ones, but no conditional pictures, unless I missed that. Regards, and thanks Mark Stanton One small step for mankind... -- For unsubscribe instructions

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Cor Nouws
drew wrote (08-02-12 17:41) There was also a fellow in Germany a couple years back who put together a Base system for managing a Dance School - this included a nice set of tools for doing mail merge IIRC - I'll root around a bit and see if I can come up with that link, in addition to what

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
The thing that started this thread though was my need for conditional pictures. Can that be done without macros? Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Fernand Vanrie
hallo Mark , The thing that started this thread though was my need for conditional pictures. Can that be done without macros? In theory we can use a WRITER DOC a FORM and a IMAGECONTROL, but even after i resolved the problem to store image-data in a database field, and pointed the

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Fernand Vanrie
Mark, me again, I did a bit more testing, now i can store en review a image in a database, using a Form and a image control, but there is still the problem that there is nothing like a imagefield to recall and show the stored image date when running a merge operation. Fernand hallo Mark

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Cor Nouws
Mark Stanton wrote (09-02-12 12:35) The thing that started this thread though was my need for conditional pictures. Can that be done without macros? Ah, did miss the start of the thread. Depends on the amount / size of pictures of course. With random pictures, as the data itself, I would not

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
Hi Fernand, I'm quite happy with the (idea of the) macro solution, I was just interested if there was another simpler/easier one. I really don't want to put images in a table, particularly in this case where the picture is either 'A' or 'B', although I s'pose if I can get it there as a result

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
In article 4f342906.5010...@nouenoff.nl, Cor Nouws wrote: If there are few available pictures to choose from, it could work with conditional hidden paragraphs. Only two pictures, a first class stamp or a second class stamp, according to whether the address is outside or inside the UK, so it's

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
In article jh1c19$53k$1...@dough.gmane.org, Alex Thurgood wrote: Agreed, but can you set it up to make the paragraph as invisible depending on whether or not you have a varchar string ? No, that's not quite my question. There will *always* be a picture, and it is either a picture of a first

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-08 Thread Cor Nouws
Hi Fernand, Fernand Vanrie wrote (06-02-12 09:08) For proper mailmerging, read personalysing your output, macro's are the only way to go a good start can be to google for a French tool (set of macro's) publipostage OpenOffice Hmm, do you have a proper link. I find a whole lot of stuf, but no

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-08 Thread drew
On Wed, 2012-02-08 at 12:03 +0100, Cor Nouws wrote: Hi Fernand, Fernand Vanrie wrote (06-02-12 09:08) For proper mailmerging, read personalysing your output, macro's are the only way to go a good start can be to google for a French tool (set of macro's) publipostage OpenOffice Hmm,

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-08 Thread Fernand Vanrie
Cor , Sorry publipostage was een beedtje breed :-) the basic code you will find here http://www.oooforum.org/forum/viewtopic.phtml?t=4957 When needed i can post more code (replacing pictures etc) based on the same principles Greetz Fernand Hi Fernand, Fernand Vanrie wrote

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-07 Thread Mark Stanton
Thanks Fernand, I'll go look. Regards Mark -- 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:

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-06 Thread Fernand Vanrie
Mark , For proper mailmerging, read personalysing your output, macro's are the only way to go a good start can be to google for a French tool (set of macro's) publipostage OpenOffice Hope it helps Fernand Ok, I've got mailmerge working, fairly well, ish. It seems a little unhelpful that

[libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-05 Thread Mark Stanton
Ok, I've got mailmerge working, fairly well, ish. It seems a little unhelpful that the view field names overrides conditional hidden paragraphs, completely nullifies their effect even on printing it seems. It cetainly should nullify their effect during edit, but not printing imnvho. Anyway,