Sending automatic email from Access using Outlook

Status
Not open for further replies.
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.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
P Threat to being a spammer while sending automatic Emails through VBA Using Outlook 3
B How to automatic save Sending or replying contacts e-mails into contacts? Using Outlook 0
D Automatic respond for sending mail problem Exchange Server Administration 4
D Sending email from Office 365 alias in Outlook Using Outlook 4
E Change sending account depending on Subjectline Outlook VBA and Custom Forms 0
L unblocking attachments before sending Office 365 Advanced Protection Using Outlook 0
B Outlook 2003 email sending & receiving suddenly stopped working Using Outlook 3
R Warn before sending message Outlook VBA and Custom Forms 4
HarvMan Hotmail - Sending email is undeliverable Using Outlook 4
A Sending contact vcards sends older version instead of updated version Using Outlook 4
M McAllister Outlook stops Sending/Receiving/Synching after disconnecting remote desktop session Using Outlook 2
D Adding Enterprise Exchange Email Account to Outlook Prevents Sending via Outlook.com Account Using Outlook.com accounts in Outlook 10
B When sending an email, I am showing 2 of my address's Using Outlook 1
M Auto expand Distribution List Before Sending Email Outlook VBA and Custom Forms 1
A Check for words in subject header before sending email Outlook VBA and Custom Forms 4
O Run macro automatically at sending an email Using Outlook 11
W Sending To Wrong Account Using Outlook 15
H Select Specific Account When Sending Email, Based on Current Folder Outlook VBA and Custom Forms 1
M Help sending email but removing signature via VBA Outlook VBA and Custom Forms 5
M MsgBox when not sending from specified account Outlook VBA and Custom Forms 2
A Script to fetch data from mails in restricted collection and sending them to excel Using Outlook 1
R Sending emails via Outlook XP, from Windows 10 File Explorer Using Outlook 1
L Creating drafts when I thought I was sending Using Outlook 1
C address book "when sending email" bug? Using Outlook 0
H Custom autoforwarding, sending mail through outlook office 365 Using Outlook 1
R Sending email copy (*.msg file) of sent email if subject line contains specific string. Outlook VBA and Custom Forms 1
C replace subject line generated by converting a word document to PDF and sending it to an email Using Outlook 8
A Sending Emails Through Outlook From Multiple Email Addresses Using Outlook 1
P Outlook 365 sending intermittently Using Outlook 0
C How to avoid sending mail to the wrong contact person New Slipstick.com Articles 1
V iCloud Calendar invitations not sending Using Outlook 3
O Rules and Alerts for New Messages BEFORE sending Using Outlook 2
latitudeit Outlook for Android - Sending from an alias address Using Outlook 2
X Delay sending an email until the next working day (public holidays) Outlook VBA and Custom Forms 0
D Macro sending outlook template from Excel list Outlook VBA and Custom Forms 6
A How to get rid of "sending on behalf of" when sending from Outlook 2016 client Using Outlook 12
O Outlook 2013 Problems sending large mails Using Outlook 4
Diane Poremsky Automatically create a task when sending a message New Slipstick.com Articles 0
P Categorise emails on sending - macro not working in Preview mode Using Outlook 1
Diane Poremsky Outlook is sending winmail.dat attachments New Slipstick.com Articles 0
Diane Poremsky Select from a List of Subjects before Sending a Message New Slipstick.com Articles 0
P Outlook 2010 sending safe senders email to junk box Using Outlook 8
Diane Poremsky To delay sending a message in Outlook New Slipstick.com Articles 0
F Avoid sending duplicate using Outlook script Outlook VBA and Custom Forms 2
D Close Oulook after sending emails via vba without outbox getting stuck. Outlook VBA and Custom Forms 1
M godaddy says my outlook's sending spam. Using Outlook 4
Diane Poremsky Check for missing attachments before sending a message New Slipstick.com Articles 1
Diane Poremsky Warn before sending messages to the wrong email address New Slipstick.com Articles 1
J Add-in for sending mass emails Using Outlook 14
Dilshad VBA editor opens when sending an email Using Outlook 2
Similar threads


















































Top