MS ACCESS - EMAIL ?

[Ahuot]

Is it possible,to e-mail a report page from ACCESS using MS Outlook Express?

All I can do is e-mail the fields in a report, I want to send additional text I have included in the report [sig][/sig]

 

[Robertd]

Hi Ahuot,

absolutly,... but the formatting doesn't always come out 100%

try this

Dim stDocName As String

stDocName = "CustInvoiceType1"
DoCmd.SendObject acReport, stDocName

where CustInvoiceType1 is a report that i want to email RTF seems to work the best.

HTH
[sig]<p>Robert Dwyer<br><a href=mailto:rdwyer@orion-online.com.au>rdwyer@orion-online.com.au</a><br>[/sig]

 

[BanditWk]

I've tried this, and for some reason, it doesn't work... I was instructed by my MIS Manager that I need to somehow specify SMTP - I have about 150 users that may be using this. Advice?

Roy McCafferty
aka BanditWk

Las Vegas, NV

&quot;I do this because I know I can and I'm bored at work - no need to send flowers, wine, dinner, or coffee... Just send me a smile to show me that I've helped.&quot; ~ Roy McCafferty, seen on a corn