As Registrar for a science-fiction convention (), I want to send a confirmation message to each of our members. The membership records are kept in Excel; I exported the list from Excel and imported it into the TB! address book, using some of the address-book fields to hold some special values in the spreadsheet. Generally, the template comes out pretty well, but I'm having trouble with a part of it:
------------------------
You are%IF:"%ABToBusFax"<>"":"":" not" registered for the Writing Master Class.
You are%IF:"%ABToBusPager"<>"":"":" not" registered for the Writers' Workshop.
%IF:'&ABToCompany'='':"%-":"
You are registered with a Dealer-room table in
the name of %ABToCompany.
"
-------------------------------
The first couple of lines ("You are/are not registered...") come out fine--if the respective fields are blank, the "not" prints, if not, not.
The part about the Dealer-room table, however, always prints, even if %ABToCompany is blank. I've tried various combinations of single and double quotes, ="" and <>"", including a blank like before the final quote mark and not, using "%-" and not; "You are registered with a Dealer-room table in the name of " always prints, with a name when %ABToCompany is non-blank, and empty when it is.
Can anyone tell me what I'm doing wrong here, or give me some pointers on how to do it right? I simply want to print that "You are registered..." paragraph, and the following blank line, if and only if %ABToCompany is non-blank. (Even better would be if I could get the line to wrap correctly, ignoring the space taken up by the macro stuff, which causes wrapping in the template. But that's minor.) Many thanks. --Howard
------------------------
You are%IF:"%ABToBusFax"<>"":"":" not" registered for the Writing Master Class.
You are%IF:"%ABToBusPager"<>"":"":" not" registered for the Writers' Workshop.
%IF:'&ABToCompany'='':"%-":"
You are registered with a Dealer-room table in
the name of %ABToCompany.
"
-------------------------------
The first couple of lines ("You are/are not registered...") come out fine--if the respective fields are blank, the "not" prints, if not, not.
The part about the Dealer-room table, however, always prints, even if %ABToCompany is blank. I've tried various combinations of single and double quotes, ="" and <>"", including a blank like before the final quote mark and not, using "%-" and not; "You are registered with a Dealer-room table in the name of " always prints, with a name when %ABToCompany is non-blank, and empty when it is.
Can anyone tell me what I'm doing wrong here, or give me some pointers on how to do it right? I simply want to print that "You are registered..." paragraph, and the following blank line, if and only if %ABToCompany is non-blank. (Even better would be if I could get the line to wrap correctly, ignoring the space taken up by the macro stuff, which causes wrapping in the template. But that's minor.) Many thanks. --Howard