Generating eMail with Access

[AndreasAuer]

Hi
my problem is, that I have to send a daily automatic email out of an access databse. This Database generates a text-file which has to be sent every weekday. I tried to make a mailto-hyperlink, but how can I add the attachment and send it? Is there a way to do this?

Please help

 

[junice]

Please refer to this website

http://www.visualbasicforum.com

and select VBA forum. There's a similiar question posted. Hope this help.

 

[andrewvanbeck]

You can email a Report, Form, Query, or Table as an attachment using the Docmd.Sendobject command, look this up on help for detailed instructions. This command is very easy to use.

Andrew.

 

[AndreasAuer]

Big Thx!!
at visualbasicforum.com i found a working code example

Andreas Auer