+ Reply to Thread
Results 1 to 2 of 2

Send Email With Message Autosig and Chart

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-25-2012
    Location
    Ventura, united States
    MS-Off Ver
    Excel 2010
    Posts
    346

    Send Email With Message Autosig and Chart

    I recently had some luck sending emails with a body and still keeping my auto signature. It used to erase the signature whenever I wrote anything in the body. But this does the trick:

    
    strbody = "Whatever I want to say in the email."
    .HTMLBody = strbody & "<br>" & .HTMLBody
    But now I also want to insert a chart. The email will let me insert a workbook range into the subject line, but I haven't had any luck with the email body.

    Sub Send_Email()
    
        Dim OutApp As Object
        Dim OutMail As Object
        Dim strbody As String
        
    
        Set OutApp = CreateObject("Outlook.Application")
        Set OutMail = OutApp.CreateItem(0)
        Chart = Sheets("Buttons").Range("B5:F12").Value
       
        strbody = "The following records have been updated or created and are ready for audit."
    
        On Error Resume Next
    
        With OutMail
            .Display
            .To = ""
            .CC = ""
            .BCC = ""
            .Subject = "EQ QA Task Pull   " & Sheets("Buttons").Range("H2")
            .HTMLBody = strbody & "<br>" & .HTMLBody
            
            '.Send
        End With
    
        On Error GoTo 0
        Set OutMail = Nothing
        Set OutApp = Nothing
    
    
    
    End Sub

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Send Email With Message Autosig and Chart

    See if you can find help on these pages.
    David
    (*) Reputation points appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1