Table query returning email addresses

E

Eli the Iceman

Hi,

I would like to know if it is possible to force a queried record output of
an email to automatically add the value of the email address to the MailTo:?
Here is what I did,

Do While Not objRS.EOF
Response.Write "<TD>" & objRS("Analyst") & "</TD>"
Response.Write "<TD><B><font color=#000080><a href=mailto:>" &
objRS("Email") & "</B></font></TD>"
objRS.MoveNext
Loop

This code returns me the values of analysts and their associated email,
which is stored in the connected DB, but my problem is that although the
mailto: is working with a created link, once clicked, then send to is empty
in my Outlook. In other words, it does not capture the email address. What
I would like to do is to include the email in the send to, so people will not
have to type it in.

Thanks,
 
S

Stefan B Rusynko

Should be (below all on 1 line)
Response.Write "<TD><B><font color='#000080'><a href='mailto:" & objRS("Email") &"'>" & objRS("Email") & "</a></B></font></TD>"


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi,
|
| I would like to know if it is possible to force a queried record output of
| an email to automatically add the value of the email address to the MailTo:?
| Here is what I did,
|
| Do While Not objRS.EOF
| Response.Write "<TD>" & objRS("Analyst") & "</TD>"
| Response.Write "<TD><B><font color=#000080><a href=mailto:>" &
| objRS("Email") & "</B></font></TD>"
| objRS.MoveNext
| Loop
|
| This code returns me the values of analysts and their associated email,
| which is stored in the connected DB, but my problem is that although the
| mailto: is working with a created link, once clicked, then send to is empty
| in my Outlook. In other words, it does not capture the email address. What
| I would like to do is to include the email in the send to, so people will not
| have to type it in.
|
| Thanks,
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top