MS Access VBA: Sending an email through Outlook [closed]

by

Add a reference to the Outlook object model in the Visual Basic editor. Then you can use the code below to send an email using outlook.

Sub sendOutlookEmail()
Dim oApp As Outlook.Application
Dim oMail As MailItem
Set oApp = CreateObject("Outlook.application")

Set oMail = oApp.CreateItem(olMailItem)
oMail.Body = "Body of the email"
oMail.Subject = "Test Subject"
oMail.To = "[email protected]"
oMail.Send
Set oMail = Nothing
Set oApp = Nothing


End Sub

More Related Contents:

  1. How to add default signature in Outlook
  2. Runtime error 287. Sending Emails through Outlook using VBA in Access
  3. Combine rows / concatenate rows
  4. For Each loop: Some items get skipped when looping through Outlook mailbox to delete items
  5. Getting Error 3340 Query ‘ ‘ is corrupt while executing queries DoCmd.RunSQL
  6. How to move each emails from inbox to a sub-folder [duplicate]
  7. Show “Open File” Dialog
  8. Save attachments to a folder and rename them
  9. Determining whether an object is a member of a collection in VBA
  10. Distinction between using .text and .value in VBA Access
  11. Outlook Reply or ReplyAll to an Email
  12. Automatically generating handling of issues
  13. VBA – Folder Picker – set where to start [duplicate]
  14. How to do late binding in VBA?
  15. How to loop through all controls in a form, including controls in a subform – Access 2007
  16. Add a “CC recipient” to Outlook 2010 VBA
  17. When is a MailItem not a MailItem? [closed]
  18. FileDialog doesn’t work
  19. Working with Unicode file names in VBA (using Dir, FileSystemObject, etc.)
  20. Search structured text in Outlook body
  21. Switching the FROM Inbox
  22. How to add an embedded image to an HTML message in Outlook 2010
  23. Pass a parameter into an access report programmatically
  24. Iterate all email items in a specific Outlook folder
  25. Restrict Outlook Items by Date
  26. VBA Outlook Mail .display, recording when/if sent manually
  27. SendKeys is messing with my NumLock key via VBA code in Access form
  28. Where does Outlook store the VBA code files?
  29. Working with current open email
  30. Debugging an Outlook 2007 script fired by a rule

Leave a Comment