email a report

[tomduvel]

Hello,

I am trying to email a report via this piece of code:

DoCmd.SendObject acSendReport, report_s, acFormatRTF, "tomme_maertens@hotmail.com", , , "test", "test", True

Everything is filled in (message text, message subject, ...), except the email address in the "To"-field. Can anybody help me please?

Thanks,
tomduvel

 

[GingerR]

hmm...i pasted it directly in a function, changed report_s to the name of an existing report in my db, and it worked just fine.........

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tomduvel]

Maybe it is because I am using Mozilla??

grtz,
tomduvel

 

[tomduvel]

Could this be the reason?

http://support.microsoft.com/kb/260819

grtz,
tomduvel

 

[tomduvel]

Indeed, it work just fine with Outlook Express. But can I get it working with Mozilla?

grtz,
tomduvel

 

[GingerR]

Hi. Sorry I don't know anything about Mozilla. I searched around and found this link. Go down to Kevin Chambers 11/03:

http://dbforums.com/t956376.html

Hope this helps--g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244