Results 1 to 2 of 2

How to add signature to the email through VBA excel

Threaded View

  1. #1
    Registered User
    Join Date
    12-25-2008
    Location
    hyderabad
    Posts
    2

    How to add signature to the email through VBA excel

    Hi,

    Body of the mail is missing when using the below code. Please let me know how to add signature and the body of the mail should not be missed.

    SigString = "C:\Documents and Settings\" & Environ("username") & _
                    "\Application Data\Microsoft\Signatures\sign.htm"
                    
                    If Dir(SigString) <> "" Then
            Signature = GetBoiler(SigString)
        Else
            Signature = ""
        End If
     
      
        On Error Resume Next
        With OutMail
            .To = Range("g6").Value
            .CC = Range("g9").Value
            .BCC = ""
            .Subject = Range("g11").Value
            .HTMLBody = strbody & "<br><br>" & Signature
            .Display
        End With
        On Error GoTo 0
     
        Set OutMail = Nothing
        Set OutApp = Nothing
    End Sub
    Last edited by davesexcel; 12-25-2008 at 11:50 AM.

Thread Information

Users Browsing this Thread

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

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