Results 1 to 11 of 11

Trying to add a default signature into an email from VBA

Threaded View

murp5972 Trying to add a default... 07-10-2015, 09:12 AM
Arkadi Re: Trying to add a default... 07-10-2015, 09:15 AM
Arkadi Re: Trying to add a default... 07-10-2015, 09:21 AM
murp5972 Re: Trying to add a default... 07-10-2015, 10:29 AM
Arkadi Re: Trying to add a default... 07-10-2015, 10:48 AM
murp5972 Re: Trying to add a default... 07-10-2015, 11:10 AM
Arkadi Re: Trying to add a default... 07-10-2015, 11:13 AM
murp5972 Re: Trying to add a default... 07-10-2015, 11:28 AM
murp5972 Re: Trying to add a default... 07-10-2015, 01:31 PM
Arkadi Re: Trying to add a default... 07-10-2015, 02:01 PM
murp5972 Re: Trying to add a default... 07-13-2015, 09:33 AM
  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    St.Paul, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    37

    Trying to add a default signature into an email from VBA

    My email code currently works just fine, but I want to add a signature right after the "Sincerely," in the body text. The signature is saved as a JPEG and its uploaded into outlook as a default signature however it doesn't show up. I would prefer my code to include it automatically at the end of the body text. What would I have to add to my code to achieve this?Thanks so much!

    Heres the code:

    Sub Mail_workbook_Outlook_1()
        Dim OutApp As Object
        Dim OutMail As Outlook.MailItem
    
        EmailTo = Worksheets("E-mail Sheet").Range("B26")
        
        Dim Found As Range
        
        EmailTo = Worksheets("E-mail Sheet").Range("B26")
        
        Set Found = Sheets("Current Clients").Columns("C").Find(What:=Sheets("E-mail Sheet").Range("A26").Value, _
            LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)
                                                   
        If Not Found Is Nothing Then
            If IsEmpty(Found.Offset(, -2)) = False Then
                If MsgBox(Range("A26").Value & vbNewLine & vbNewLine & "An item request has  been sent on: " & Found.Offset(, -2).Value & vbNewLine & _
                "Items were recieved on: " & Found.Offset(, -1).Value & vbNewLine & vbNewLine & "See Current Clients page for more information" & vbNewLine & vbNewLine _
                & "Do you want to continue?", vbYesNo) = vbNo Then
                    Exit Sub ' stop macro if user selects No
                End If
            End If
        End If
    
        
        Set OutApp = CreateObject("Outlook.Application")
        Set OutMail = OutApp.CreateItem(0)
    
        On Error Resume Next
        With OutMail
            .To = Worksheets("E-mail Sheet").Range("B26")
            .CC = Worksheets("E-mail Sheet").Range("B19")
            .BCC = ""
            .Subject = "Updating Credit File - " & Worksheets("E-mail Sheet").Range("D26")
            .Body = "Dear " & Worksheets("E-mail Sheet").Range("C26") & "," & vbNewLine & vbNewLine & _
            "We are requesting the following information to bring your credit file up to date." & vbNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B2") _
            & Worksheets("E-mail Sheet").Range("C2") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B3") & Worksheets("E-mail Sheet").Range("C3") _
            & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B4") & Worksheets("E-mail Sheet").Range("C4") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B5") _
            & Worksheets("E-mail Sheet").Range("C5") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B6") _
            & Worksheets("E-mail Sheet").Range("C6") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B7") _
            & Worksheets("E-mail Sheet").Range("C7") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B8") _
            & Worksheets("E-mail Sheet").Range("C8") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B9") _
            & Worksheets("E-mail Sheet").Range("C9") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B10") _
            & Worksheets("E-mail Sheet").Range("C10") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B11") _
            & Worksheets("E-mail Sheet").Range("C11") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B12") _
            & Worksheets("E-mail Sheet").Range("C12") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B13") _
            & Worksheets("E-mail Sheet").Range("C13") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B14") _
            & Worksheets("E-mail Sheet").Range("C14") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B15") _
            & Worksheets("E-mail Sheet").Range("C15") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B16") _
            & Worksheets("E-mail Sheet").Range("C16") & vNewLine & vbNewLine & Worksheets("E-mail Sheet").Range("B17") _
            & Worksheets("E-mail Sheet").Range("C17") & vbNewLine & vbNewLine & "If possible please provide us this information by " & Worksheets("E-mail Sheet").Range("A2") _
            & vbNewLine & vbNewLine & "If you have any questions please contact " & Worksheets("E-mail Sheet").Range("A19") & "at " & Worksheets("E-mail Sheet").Range("C19") _
            & vbNewLine & vbNewLine & "Sincerely,"
            .SendUsingAccount = OutApp.Session.Accounts.Item(2)
    
        .Display
        End With
        On Error GoTo 0
    
        Set OutMail = Nothing
        Set OutApp = Nothing
    End Sub
    Last edited by murp5972; 07-10-2015 at 09:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] default email signature
    By bigfishprf in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-08-2015, 10:55 AM
  2. [SOLVED] Excel VBA code for saving PDF to file & adding default signature to Email
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2014, 01:54 AM
  3. generating automatic email with default signature and hyperlink
    By jerrydiaz in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2014, 11:55 AM
  4. send selected range in email with default outlook email signature included
    By mdsickler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 10:50 PM
  5. Unable to link default email signature to email
    By paxile2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2010, 06:52 PM

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