Calculating email address

[Brudderman]

I'm having trouble calculating the proper form of an email address for use in the Send Mail options dialog. I'm using the SMTP server option.

If, for example, I have a person named John Doe (found in Name field) whose email address is [email protected] (found in Email field) and point the TO section of the Send Mail options dialog to the Email field only, all works well. The email sends properly.

But I'd like to send using both the person's name and email address, not the email address alone. In my email client I would simply type John Doe , and that would work. But I can't get a calculation configured to do the same thing. I've tried a couple of things:

Name & " <" & Email & ">" -- Trying to create what I would type

""" & Name & "" <" & Email & ">" -- Trying to enclose Name in quotes in case that makes any difference

After setting the results of a calculation to a variable (which I use in the Send Options dialog), I've looked at the results of both of these in the data viewer and they both look OK but neither works. So I must be leaving something

out but don't know what. I'd appreciate any suggestions.

Thanks!

James

www.james-mc.com

[comment]

I think the real question here is: does the mail client (in this case, Filemaker) accept addresses in the "John Doe " format*? I haven't tried the SMTP feature yet, but from what you say it seems the answer is no. A better test would be to enter such address into a field and try to send mail using that field.

---

(*) which needs to be unquoted (as per your first example) - based on what works with an external mail client.

[Brudderman]

I think the real question here is: does the mail client (in this case, Filemaker) accept addresses in the "John Doe " format?

Thanks for defining this more clearly. I tried typing the address in directly, and it doesn't send. But in this case, I do get an error message dialog: "Email(s) could not be sent successfully." In the case of setting the address by variable or by calculation, there is no error message dialog. There may be an error generated, but I haven't tried to trap it.

So for now it looks like I need to use the email address without the name.

I appreciate the help.

James

www.james-mc.com