Database Reports - e-mail links

[dburnham]

I am using a database to generate a user report. I have been able to get the http: links to work but not the mailto: links. I have modified the settings in both FP and Access. So far the closest that I have come is to have the e-mail link jump to the actual host site.

I am sure the combination is out there.

Any and all help is appreciated.

Thank you,
David

 

[DeZiner]

It's a simple code adjustment surely. Please post code and advise what data exactly is being pulled from the Database. IE: database stores

http://www.mydomain.com

or

http://www.mydomain.com

or me@mydomain.com.

DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[dburnham]

Below is the code from FP2002. I have stored the DB info in several ways.

I have used:
mailto:dburnham4729@yahoo.com and
dburnham4729@yahoo.com

I have set the fields type in access to both text and to hyperlink with no difference in the outcome.

I appreciate your help.

David

<li><b>Email:</b> <!--webbot bot=&quot;DatabaseResultColumn&quot; s-
columnnames=&quot;WebdirectoryID,OrganizationName,Address,City,St
ate,PostalCode,WorkPhone,MobilePhone,FaxNumber,EmailAddress,
Notes,DateJoined,Catagory,DuesPaidDate,Logo,website,Remote_c
omputer_name,User_name,Browser_type,Timestamp,Logo1&quot; s-
column=&quot;EmailAddress&quot; b-tableformat=&quot;FALSE&quot; b-
hashtml=&quot;FALSE&quot; b-makelink=&quot;TRUE&quot; clientside b-MenuFormat
preview=&quot;<font size=&quot;-1&quot;>&lt;&lt;</font><a
href=&quot;.&quot;>EmailAddress</a><font size=&quot;-1&quot;>&gt;&gt;</font>&quot;
startspan --><%=&quot;<a href=&quot;&quot;&quot; & FP_FieldLink
(fp_rs,&quot;EmailAddress&quot & &quot;&quot;&quot;>&quot; & FP_FieldVal
(fp_rs,&quot;EmailAddress&quot & &quot;</a>&quot;%><!--webbot
bot=&quot;DatabaseResultColumn&quot; endspan i-checksum=&quot;55071&quot; --
><b>