mailto: in access report

[paulmitchell507]

I have a Access 2000 report that I export to our intranet site, via a
macro. The output format is MS-DOS text, and the output file name is
staff.html. The report works fine but I want to add a field
containing e-mail address's to the report. I have created a text box
on the report containing the e-mail field and named it 'Text48".

Proceeding the text field 'Text48' I have the following

</td><td><font face="Arial, Helvetica" size="2"><a
href="mailto:Text48" & "Text48" &"</a></font">

My aim is to display the contents of the e-mail field in the report,
and when you double click the field the e-mail address populates the
'To' field of the users email client.

My example displays the e-mail address correctly, and when you double
click the address it populates the 'To' field of my mail client. The
problem is that it puts 'Text48' into the 'To' field.

If anybody could put the finishing touches to my report I would
appreciate it.

 

[Douglas J. Steele]

Can't be done, at least, not in Access 2003 or earlier (It may be possible
in Access 2007, but I'm not positive)

Reports are (were) passive. You can't (couldn't) interact with them.