Sending email using SMTP server from Access

[Guest]

Hi,

Is there anybody having experience sending email to SMTP server from access
(VBA) ?
I want to be able to send an email to client which is the data stored in
access and the message was the query result.
I can not using Lotus Notes mail server due to the server was shut down for
backup every night. Then the administrator advice me to send the email
directly to our SMTP server. But unfortunately I don't have any idea how to
do this from access.

TIA
Gabriel

 

[miTch]

Look at this, it works very well
http://www.ostrosoft.com/smtp_component/smtp_vba.asp

rh