Access 2000 Report, mailto

[paulmitchell507]

I run a access report that outputs employees names and email address's
from the database to the company intranet, the output format is MS-DOS
Text and file name is *.html. Just like the names, the email address
is harvested from a field in the database. How can I export the e-
mail address so when a use clicks on the relevant e-mail address on
the intranet page, their mail client opens ie. mailto.

I can recreate what I want manually using the following html:
<a href="mailto:[email protected]">[email protected]</a></font>
</td>

How can I include this in my access report where the text box
containing the email address field is called text47?

My current report outputs the e-mail address as regular text.

Regards,
Paul

 

[D. Crystal]

Paul, I don't know what you can do because I have never used that email
program before.
Reguards,
D. Crystal

 

[James]

I run a access report that outputs employees names and email address's
from the database to the company intranet, the output format is MS-DOS
Text and file name is *.html.  Just like the names, the email address
is harvested from a field in the database.  How can I export the e-
mail address so when a use clicks on the relevant e-mail address on
the intranet page, their mail client opens ie. mailto.

I can recreate what I want manually using the following html:
<a href="mailto:[email protected]">[email protected]</a></font>
        </td>

How can I include this in my access report where the text box
containing the email address field is called text47?

My current report outputs the e-mail address as regular text.

Regards,
Paul

Hi

You can use concatenation to build it up, how does depend on how you
are exporting it to the html file. An example would be something like:
"<a href="mailto:" & text47 & ">" & text47 & "</a></font>"

Regards

 

[paulmitchell507]

Hi

You can use concatenation to build it up, how does depend on how you
are exporting it to the html file. An example would be something like:
"<a href="mailto:" & text47 & ">" & text47 & "</a></font>"

Regards- Hide quoted text -

- Show quoted text -

It almost works.
when I use the example above and view the ouput, the email address's
are underlined as links, If I place the mouse over an address the
mailto is shown in the address bar (in the bottom left of screen), but
not the e-mail address. So when I double click the address, my mail
client opens, but there is no entry in the to field.

I am exporting the report via a macro action, Output.
Object type: report
Name: staff_html
Format MS-DOS Text
File c:\staff.html

Any further help would be appreciated.