Help with Access sending an e-mail

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get Microsoft Access to send a report using SendObject in a
macro. I have the macro working and it sends the e-mail with the report to
Outlook, but Outlook does not send the e-mail. I have to manually open
Outlook, go the Outbox, double click the message and then click send. I tried
chaning the property Edit Message in the Access macro to YES and then
clicking SEND when the e-mail opens. It still does not send automatically.

Some background:
- This is a computer at work and it's sole purpose is for entering in data
for the database. So, I created an e-mail account solely to send e-mail. No
one will use the computer to send/receive e-mail other than for these reports.
- 2 of the 3 users are minimally computer literate. So extra steps are to be
avoided.
- I am willing to install a different e-mail client on the computer if
necessary.
Any suggestions?
 
Sneagle,

I don't know the reason for what is happening, but it sounds like to do
with the configuration of Outlook, regarding whether it sends emails
straight away, or holds them in the Outbox for a time, or whatever. You
may get a more sensible answer in an Outlook newsgroup.

SendObject in Access uses the default email client. Based on what you
have told us, it may be worth looking at a simpler email client, such as
Outlook Express.
 
Hi,
did you actually try to set the editmessage argument to FALSE since you do
not want to edit the message before it is send?
You might also be experiencing this because of security issues. Office 2003
will not let you send things without user interaction anyway (at least not
with sendobject). I would suggest you either look into a different client as
already mentioned, or use automation to create and send your message. It will
give you much more control then the sendobject method, which is very limited.
HTH
Good luck
 
My bet is that outlook has to already be open on your computer for it
to go into the send operation. If it is not open (it is outlook that is
doing the sending) Access saying to send only puts it in the outbox.

Remember that the newer security updates from MS will require you to ok
the sending of the email even if Outlook is up and willing to send the
message.

Because we operate here with outlook always open we never encounter the
comment 1 situation and always encounter the comment 2 situation.
 
Back
Top