Fred A. Miller wrote:
On Saturday 31 December 2005 5:09 pm, Jean Hollis Weber wrote:
Fred A. Miller wrote:
I searched all the OO docs and can't find the solution to a mail merge
problem. I don't know if there is a solution, but hope so. In working
with Base, and then in writer with mail merge, I need to be able to
eliminate the space(s) created when there is an absence of data from a
database. For example, some records may have 2 address lines between the
name and city, yet most will only have 1 address line. If I have 2
defined fields for address 1 and address 2 there is an empty line created
in the mail merge. Is there a way in writer to keep from having an empty
line when there's no data to import from a database?
We had a long discussion about this a couple of weeks ago and
concluded that, due to a bug in OOo, using the "hidden paragraph"
Sorry, I seem to have missed that!
technique does not work (the line is always hidden, whether there
is data in it or not), but a "hidden section" does work. I'm
revising the mail merge chapter in the Writer Guide to cover
this. In the meanwhile, if my comment is too cryptic, so ask for
more info.
Yes, if you don't mind. I did use the insert section and hide, however, I
don't know what to enter as a condition so that text will be there if there
is an entry in the database, and the empty line won't appear in a mailmerge
if there's no data.
I was just doing this again, and can't get it to work properly,
even though I'm sure it was working before. The field is hidden
or displayed as it should be, based on the condition, but the
blank line remains if the field is hidden! I'm sure I've used a
hidden section used to remove the blank line as well as the
field, so I'm not sure what's going on... if it's me or 2.0.1 is
buggy, or what.
The condition that I was using was
"databasename.tablename.fieldname" EQ ""
(With the quotes included as shown because my fieldnames had
spaces in them, and I think I need the quotes in that case.)
If anyone else who has done this successfully in the past can
give this a test, I'm sure we'd all be grateful.
BTW, I'm using OOo2.0.1 on WinXP, SP2.
Cheers, Jean
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
