Thank you for your post.
If you use Apple Mail, replace the "¶" character with ";" (semicolon). This will then work in either Tiger or Leopard.
If you are using a value list to generate your carriage return separated list of addresses, you can use the substitute function to turn "¶" into ";"
Hi, if I replace the ¶ with ; in the "Send Mail" Options To: field
membership::t_Adult1Email & ; & membership::t_Adult2Email
I get a FM error "A number, text constant, field name or "(" is expected here."
Hi if I place quotes around the semicolon
membership::t_Adult1Email & ";" & membership::t_Adult2Email
FM gives no error, but Mail in Leopard gives the warning
"Warning “” does not appear to be a valid email address. Please check the address and try again."
No error in Tiger Mail.
Put quotes arround each ;
table::field1 & ";" & tablefield2 & ";" ...
Hi, As my post states, I did that, but the problem with the warning in Mail.app persists.
Sorry, I should read more carefully.
Perhaps one of the fields is empty?
Yes, there is always one or more empty ones.
There are up to 8 addresses, but I don't think there's a case of all 8 being populated. There's always less than 8.
Are you implying that I need to use If,then arguments in the TO FIELD?
I'm just wondering if ";;" might cause the problem.
I haven't tried it so I can't tell you one way or another. Modifying your expression to exclude any blank fields would be one way to test this.
But even if your suspicion is correct, if empty fields are ignored wouldn't the semicolons all still be present?
Yes, I meant to modify your expression to leave out the extra semicolons.
You might be able to use Substitute(<Your expression>, ";;", ";")
I've never used that function . . . would it go like this?
Substitute (membership::t_Adult1Email & ";" & membership::t_Adult2Email & ";" & membership::t_JuniorHeadEmail & ";" & membership::t_Adult3Email & ";" & membership::t_Junior1Email & ";" & membership::t_Junior2Email & ";" & membership::t_Junior3Email & ";" & membership::t_Junior4Email ; [";;" ; ";"] ; [";;;" ; ";"] ; [";;;;" ; ";"] ; [";;;;;" ; ";"] ; [";;;;;;" ; ";"] ; [";;;;;;;" ; ";"] )
I'll have to see if it works with Leopard tonight. It continues to work with Tiger
Duh... (while banging head on keyboard :smileywink: )
I totally failed to consider that you might have more than one empty field adjacent to each other. Scratch that whole idea. Sorry about that.
I think I'd load the entire expression into a variable one field at a time, skipping the blanks and then use the variable as my email address line.
Set Variable [$Emails, If (not isempty(membership::t_Adult1Email), membership::t_Adult1Email & ";")]
Set variable [$Emails, $Emails & If(not isempty....
I'd also consider putting all these different email addresses in separate records, but you may have good reasons not to do that.
Thanks for the clue. Since I have used If,then statements before I decided to try that.
So this worked if you have all 3, but if you didn't have the first email then it would have an extra semicolon and give the warning. Bummer.
If (membership::t_Adult1Email>0; membership::t_Adult1Email) & If (membership::t_Adult2Email>0; ";" & membership::t_Adult2Email) & If (membership::t_Adult3Email>0; ";" & membership::t_Adult3Email)
So I spent some time trying various schemes and logic to never have an extra ; . . . BUT no luck.
Eventually I somehow remembered that Apple Mail instructions for multiple email addresses are to separate them with a COMMA.
So This works no matter which addresses are present
membership::t_Adult1Email & "," & membership::t_Adult2Email & "," & membership::t_Adult3Email