Sending a Report and/or Record Via Email (1 Viewer)

[rmacleod]

Anybody know of some code that could be used to send a report Via E-mail. without using Outlook. just via an smtp server.

I have a little Task database and we would like to be able to Email a task to the person it is assigned to by just clicking one button and that is it.

 

[naygl]

Try searching for SendObject in this forum or the Access help.

 

[rmacleod]

thanks..but SendOject uses outlook. I would like it to be able to send automatically through a specified SMTP server.

 

[keiths]

Sending email without using ms outlook, etc

I found a very handy dll that allows you to send email from within your ms access database (also ms excel). This allows you to send email without the use of ms outlook or other email clients.
The web site for the dll is:

http://www.ostrosoft.com/smtp_component.asp

The zip download includes a number of samples for different programming languages. What I liked about this smtp email dll is that I can set up a "monitor window" where I can see what is happening with the smtp server so I can see errors, etc.
The coding is fairly straight forward, and is easy to implement.

They also have a dll for reading emails. Have played with it a bit, and it also seems to work fine.