Quote Originally Posted by AlphaFrog View Post
1) I got this syntax from recording my steps in a macro in MS-Word.
.Hyperlinks.Add .Range, "MailTo:" & inpCltNmePrincipalEmail, , , inpCltNmePrincipalEmail

2) I'm not sure what you're asking but use an If statment then set the font color red or not.
Thanks. Both remaining problems solved.