Runtime error 287. Sending Emails through Outlook using VBA in Access

by

Well this is something I have never come across before, however, I have found a solution.

The error message itself got me wondering why the send command wasn’t recognising the defined application. I questioned whether the code was running too fast. (I don’t know where this light bulb moment came from but it has fixed the issue).

I have simply inserted a loop to force a delay before the send operation. I did this because Access doesn’t recognise application.wait.

Testing so far seems successful!

Dim T1 As Variant
Dim T2 As Variant

T1 = Now()
T2 = DateAdd("s", 1, T1)

Do Until T2 <= T1
    T1 = Now()
Loop
oMail.Send

This procedure will not be run very often, maybe 5 times in a day max. So I am not worried about the one second delay causing any real-time issues.

More Related Contents:

  1. How to add default signature in Outlook
  2. MS Access VBA: Sending an email through Outlook [closed]
  3. ms access vba code for update records through form
  4. Get reference to additional Inbox
  5. Combine rows / concatenate rows
  6. Outlook VBA – Run a code every half an hour
  7. Is it possible to pass parameters programmatically in a Microsoft Access update query?
  8. Can I iterate through all Outlook emails in a folder including sub-folders?
  9. Download attachment from Outlook and Open in Excel
  10. Embed picture in outlook mail body excel vba
  11. Too few parameters Expected 1, recordset issue
  12. How to move each emails from inbox to a sub-folder [duplicate]
  13. Save attachments to a folder and rename them
  14. How do I display a messagebox with unicode characters in VBA?
  15. MS Access VBA Error: Run time error ’70’ Permission Denied
  16. Outlook Reply or ReplyAll to an Email
  17. Automatically generating handling of issues
  18. Is it better to use ADO or DAO in Access 2007?
  19. VBA Search in Outlook
  20. Distinguish visible and invisible attachments with Outlook VBA
  21. Check for the senderEmailAddress
  22. Removing a string that includes CRLF characters from body of e-mail
  23. How do I open an outlook .msg file from my harddrive that is NOT in outlook?
  24. Is there an equivalent to Thread.Sleep() in VBA
  25. Exporting MS Access Forms and Class / Modules Recursively to text files?
  26. Switching the FROM Inbox
  27. How to get logged-in user’s name in Access vba? [duplicate]
  28. Iterate all email items in a specific Outlook folder
  29. Insert multiple records with a date range in MS Access
  30. SendKeys is messing with my NumLock key via VBA code in Access form

Leave a Comment