SendObject Only Working Once

M

MDW

I'm trying to use DoCmd.SendObject to send Excel copies of tables in my
Access 2000 database. However, there seems to be a limitation in the number
of emails that can be sent.

I have a single line of code behind the click event of a button on a form:

DoCmd.SendObject acSendTable, "ACCOUNTS", acFormatXLS,
"(e-mail address removed)", , , "Test Message", "This message was automatically
generated my MS Access.", False

The first time I click the button, it works. However, every subsequent time
I click the button nothing happens. I need to close the database and reopen
it before I can send another e-mail.

In addition, if I put this code behind the button:

DoCmd.SendObject acSendTable, "ACCOUNTS", acFormatXLS,
"(e-mail address removed)", , , "Test Message", "This message was automatically
generated my MS Access.", False
DoCmd.SendObject acSendTable, "ACCOUNTS", acFormatXLS,
"(e-mail address removed)", , , "Test Message", "This second message was
automatically generated my MS Access.", False

only the first of the two e-mails get sent.

In either case, it does not seem to matter whether I have my e-mail client
(Outlook 2003) open or closed. I am only able to send a single e-mail.

Does anyone have any ideas as to what could be happening?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Can't email a table 2
Send an Query output with a Email using "sendObject" function 1
Attachments from query into mail 2
SendObject to specify Excel version 1
Multiple DoCmd.SendObject only sending first e-mail 1
Use DoCmd.SendObject to send Select Query 0
E-mail query to recipients in table - performance and security 1

Top