PDA

View Full Version : Linking e-mail address from database to outlook


Jack_S_123
03-25-2009, 08:51 PM
Hi
I was wondering if anyone could help me with this problem, I think it’s easy to solve as im half way there.
I have a database and one field in a table is called “Contact” and contains a list of email addresses. I want to link these email addresses in Dreamweaver so they’re a link and when clicked, outlook opens with the “To” part already filled out with the email address they clicked.
So I’ve created a recordset with contact in and dragged that to my page. I’ve then clicked it and written in properties area in the link text field

mailto:{rsEmp_Accenture.Contact} (%7brsEmp_Accenture.Contact%7d)

rsEmp_Accenture being the name of my recordset and contact the name of the field.

And now when you preview it and click it, outlook does open! Get in. However, in the “To” area is {rsEmp_Accenture.Contact} (%7brsEmp_Accenture.Contact%7d) not the data stored in the field in the database.

I have no idea how to fix this and my google searching has found nothing. I’d be really grateful if you know how to fix this, it’s an asp page by the way.

Thanks a lot