How to add default signature in Outlook

by

The code below will create an outlook message & keep the auto signature

Dim OApp As Object, OMail As Object, signature As String

Set OApp = CreateObject("Outlook.Application")
Set OMail = OApp.CreateItem(0)

With OMail
    .Display
End With

signature = OMail.body

With OMail
    '.To = "[email protected]"
    '.Subject = "Type your email subject here"
    '.Attachments.Add
    .body = "Add body text here" & vbNewLine & signature
    '.Send
End With

Set OMail = Nothing
Set OApp = Nothing

More Related Contents:

  1. MS Access VBA: Sending an email through Outlook [closed]
  2. Runtime error 287. Sending Emails through Outlook using VBA in Access
  3. Get reference to additional Inbox
  4. How do I trigger a macro to run after a new mail is received in Outlook?
  5. For Each loop: Some items get skipped when looping through Outlook mailbox to delete items
  6. Getting Error 3340 Query ‘ ‘ is corrupt while executing queries DoCmd.RunSQL
  7. Show “Open File” Dialog
  8. Determining whether an object is a member of a collection in VBA
  9. Distinction between using .text and .value in VBA Access
  10. VBA – Folder Picker – set where to start [duplicate]
  11. How to do late binding in VBA?
  12. How to insert text into Outlook email editor using VBA
  13. MS Access: how to compact current database in VBA
  14. How do you extract email addresses from the ‘To’ field in outlook?
  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. Using visual basic to access subfolder in Inbox?
  18. When is a MailItem not a MailItem? [closed]
  19. FileDialog doesn’t work
  20. Working with Unicode file names in VBA (using Dir, FileSystemObject, etc.)
  21. Determine real cause of ODBC failure (error 3146) with ms-access?
  22. Search structured text in Outlook body
  23. How to add an embedded image to an HTML message in Outlook 2010
  24. Pass a parameter into an access report programmatically
  25. Restrict Outlook Items by Date
  26. finding latest file in a folder and opening it (vba access)
  27. VBA Outlook Mail .display, recording when/if sent manually
  28. SendKeys is messing with my NumLock key via VBA code in Access form
  29. Where does Outlook store the VBA code files?
  30. Debugging an Outlook 2007 script fired by a rule

Leave a Comment