How can I change case in an email (lower to title)

[Chalkster]

This probably sounds so simple but I've been trying all day and cant work it out.

basically I have used the sendmail script to build myself a mail message... and overall it works... the text is there, field are in the right place etc... I have one problem remaining

Some fields eg first and last name were originally entered in the database as lower case... I want them to appear in the mail as titlecase... can i do this?

eg my message starts "Dear " &client::name& the name john graham appears as originally entered in FM... all in lowercase. What I want is for it to read Dear John Graham. I know I can do it all in upper or lower but is there anyway to have it in titlecase?

I have tried a lot of things..... replacing the field values with titlecase, I tried using the AddTextstyle function etc but I'm stuck - or am i just missing something here?

Any ideas??

[Vaughan]

"Dear " & Proper(client::name) & ...