I'm trying to create a hyperlink on the homepage that opens up outlook and prepopulates email addresses from one of the fields in one of my tables. I've been able to do this when listing out the email addresses individually, but there are about 50 email addresses at issue and they change often, so I want to refer to the field instead of listing each out. I created two different text versions of the email field, one that ends in a semi colon and one that ends in a double backslash. A couple versions of my html for the hyperlink is below. Something appears to be missing. Outlook opens, but the email addresses do not populate.
<a href="MailTo:" & URLRoot() & "db/bi999999 "&ToText([Emailbackslash_ProjLead]) ?subject= Message"><span style="color: #008000;">Project Leads</span></a>
Or, I also tried it with the semi colon.
<a href="MailTo:" & URLRoot() & "db/bi999999"&ToText([EmailSemiColon_ProjLead]) ?subject=Message"><span style="color: #008000;">Project Leads</span></a>
Can you tell me what is missing? Any suggestions would be greatly appreciated.