How To Parse Phone Fields For Emaill Address?

[computiv]

Can anyone offer a method to parse through several different fields and if an email address is found send an email address to the default client. This is very simple for one static field. I have found a challenge trying to accomplish this when one of five different selectable fields becomes an email address through a popup list.

i.e. A popup list of Work, Home, Fax, Mobile, Pager, Email is available for five different fields...Phone1, Phone2, Phone3, Phone4 and Phone5.

[Fitch]

Rather than scripting 5 If... Send Mail steps, it's probably easier to get the email address into a global field, then Send Mail:

Set Field (gTempEmail, Case (Popup1 = "Email", Phone1, Popup2 = "Email", Phone2, Popup3 = "Email", Phone3, Popup4 = "Email", Phone4, Popup5 = "Email", Phone5)

Send Mail (...to gTempEmail... )

Set Field (gTempEmail, "") -- clear it when you're done