To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67843 Issue #|67843 Summary|Hiding an empty query set field in Mail merge does not | work Component|Word processor Version|OOo 2.0.3 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|mru Reported by|aguilr
------- Additional comments from [EMAIL PROTECTED] Thu Jul 27 08:58:27 -0700 2006 ------- Hello, I am printing out envelopes and am trying to hide "address2" if the entry does not have a sub-address. In: Tools -> Options -> Openoffice.org Base -> Databases I give the db a name database. Next, I created a query that I want to use for my mail merge and name it: names_and_addresses I then created a blank document, then went to Insert -> Envelope and setup the envelope with all the fields. >From here, I can see all the data from my query set filling in the envelope information in the format: <first_name> <last_name> <address1> <address2> <city>, <state> <zip> Now, I'd like to hide <address2> if it's blank, so in: Insert -> fields -> other -> functions I select "Hidden Paragraph" and set the condition to: database.names_and_addressses.address2 EQ "" But, that does not work. I always see a blank line. I'm pretty sure I followed the documentation properly. Any help is greatly appreciated! I will attach base and writer files shortly. Thanks! --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]