Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Fri, 4 Jul 2008 08:16:37 -0700 (PDT),    group: microsoft.public.access.reports        back       


mailto: in access report   
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.
date: Fri, 4 Jul 2008 08:16:37 -0700 (PDT)   author:   paulmitchell507

Re: mailto: in access report   
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.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"paulmitchell507"  wrote in message 
news:08ce129f-c95e-4f20-8ce5-13df6b60d491@m44g2000hsc.googlegroups.com...
>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.
date: Fri, 4 Jul 2008 17:10:03 -0400   author:   Douglas J. Steele

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us