Sending automatic email from Access using Outlook

S

SmFjaw

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.
 
K

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?

"Jack" <Jack> wrote in message

news:6F510E93-A774-4BBA-BCCE-02C43AF6ABDF@microsoft.com...
> 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.
 

Similar threads

Top