Sending automatic email from Access using Outlook
 

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.

Sending automatic email from Access using 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?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Jack" wrote in message
...
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.