Sending automatic email from Access using Outlook

[Jack]

Hi,
I have an Access application named sendemail. that sends automatic emails to
users based on database fields and criteria. I am using onclick freeware to
send from the dynamic list by using vba The application is using Outlook and
excahnge server account named sqladmin. However the email is being sent when
I logon to the server where the email application is. The email application
is always open. My question is how am I suposed to send automatic email
without loggin on to the server. The Outlook seems to send email if the list
exists only when I am logged on. Otherwise the email is not send. Any ideas?
Thanks.

 

[Ken Slovak - [MVP - Outlook]]

Either use an SMTP server to send, which is not an Outlook question, or use
the Outlook object model to send and do a send/receive. In that case
obviously Outlook must be running, or how else would it be able to send a
message?