Peter Hillier-Brook wrote:
CarlP wrote:
Peter Hillier-Brook wrote:
CarlP wrote:
OK, I've been here before, with OO 1. OO 2.0.2 on WinXP. I'm
trying to do a mail merge but STILL can't get rid of blank lines. I
have a data source registered and can get the data to merge with the
letter. I insert a hidden paragraph (in the form of "not (<FIELD
NAME>)") with the field name copied directly from the merge document
so I know it's correct.
But when I merge, I either get the blank lines showing up, or I get
suppression of all of the lines with that field, whether or not any
one record has data there.
So, for example, I have:
Name
Address1
Address2
City, State Zip
Address 1 has data for some people, not for others. I insert a
hidden paragraph for Address1 (before the field name on the same
line). Then merge the data. If I select Show hidden paragraphs,
all lines display and print, whether there is data or not (blank
lines show up). But when I de-select the View Hidden Paragraphs,
all of the lines with the hidden paragraph function disappear,
whether there is data or not.
This is the same behavior as under v.1, and I thought it was
supposed to be fixed in 2.0.2. Am I doing something wrong?
It's possible that you are doing something wrong, most likely in the
condition field of the Hidden Paragraph(s). The form of the condition
should be as follows:
![AddressBook.Sheet1.Title] AND ![AddressBook.Sheet1.Initials] AND
![AddressBook.Sheet1.Name
![AddressBook.Sheet1.Address]
Please note:
1) "Title", "Initials" and "Name" are all on one line and have
wrapped into two in my (and probably your) mail client, that's why I
have inserted a blank line to differentiate between the two lines.
2) The Hidden Paragraph field should be on the end of the line, not
at the beginning before the field name: that's probably why all your
lines are hidden.
3) "AddressBook" is my data source name. You should substitute this
with your name.
If this doesn't solve your problem, please come back with more detail.
Regards
Peter HB
Thanks, Peter. I've tried your suggestion but it makes no difference.
I'm being careful about the syntax of the condition and I've tried it
with and without "<" and">", with and without "(" instead of "[", with
just the field name and with the entire data source path. I've tried
it in the form of "not (FieldName)" "! (FieldName)" "(FieldName) EQ
""" and more. I've even put the Hidden Paragraph back in front of the
field on the line (as the manuals and guides all say to do), and then
re-tried all of the combinations of conditions. Nothing works.
The syntax I specified works! I haven't any idea if any, or all your
variations do anything useful, but they are a red herring. If you want
to send me your merge document off-list I'll be happy to take a look.
Regards
Peter HB
Thanks, Peter. After trashing the document I was first working on and
starting from scratch, I was able to get it to work if I removed the "\"
character from the field names before creating the document. I don't
know why the original document wouldn't work after I changed the field
names in the data source, but there you have it.
By the way, in my case, I have the Hidden Paragraph function BEFORE the
field on the line and it works fine. It can go before or after, and
what's more, !, not, EQ "" and perhaps other syntax work fine too. I
needed to test them out for my own sake just to make sure I understood
the finer points and tried every option I could think of.
Carl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
