Hi all,
OK, so here is my code.
Code:
="Home Phone " & [HomePhone] & Chr(13)+Chr(10) & "Mobile Phone " & [MobileNumber] & Chr(13)+Chr(10) & "Email Address " & [ClientEmailAddress]
So far so good. It brings it all in. Problem I'm having is with the display of the email address. It has that annoying 'mailto:'. What would be ideal would be the ability to display the hyperlink, whether email or web, as a hyperlink instead of just plain text. Is this possible using the above code? Must be a way to do this. I'm going to be adjusting the code to include the iif statements to cover myself for information that is not entered.
Hope you geniuses out there can help!