Results 1 to 2 of 2
  1. #1
    floyd is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    66

    Add Outlook Signature to Email - CODE

    Enclosed is the code which will input the Outlook Signature line in your outgoing email.



    ENJOY!

    Code:
    Private Sub SecondEmail_Click()
    
    'open Outlook, attach zip folder or file, send e-mail
    Dim appOutLook As OutLook.Application
    Dim MailOutLook As OutLook.MailItem, SaveSig As String
    Set appOutLook = CreateObject("Outlook.Application")
    Set MailOutLook = appOutLook.CreateItem(olMailItem)
    MailOutLook.Display
    SaveSig = MailOutLook.HTMLBody
    With MailOutLook
        .BodyFormat = olFormatRichText
        .To = ""
        ''.cc = ""
        ''.bcc = ""
        .Subject = Me.EmailSubjectField
        .HTMLBody = Me.EmailMessageField & SaveSig
        '.Attachments.Add ("path\filename")
        ''.DeleteAfterSubmit = True 'This would let Outlook send the note without storing it in your sent bin
        .Display
        '.Send
    End With
    End Sub

  2. #2
    drunkenneo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    199
    Thats nice...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Outlook batch email PDF
    By Ruegen in forum Reports
    Replies: 43
    Last Post: 12-12-2013, 10:55 PM
  2. Replies: 7
    Last Post: 11-27-2013, 08:37 AM
  3. adding signature to the email sendobject
    By webisti in forum Access
    Replies: 3
    Last Post: 07-10-2012, 03:08 PM
  4. Email and Outlook
    By Douglas Post in forum Programming
    Replies: 1
    Last Post: 02-13-2012, 02:57 PM
  5. FORMATTING Outlook Email in BODY of Access code
    By taimysho0 in forum Programming
    Replies: 7
    Last Post: 11-28-2011, 11:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums