+ Reply to Thread
Results 1 to 1 of 1

Embed a picture as a signature in an Outlook email generated by VBA in Excel

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Cape Town, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    1

    Embed a picture as a signature in an Outlook email generated by VBA in Excel

    Hi.

    I am completely new to VBA and copied some code that automatically generates an email in Outlook.
    I would like to use a picture as a signature in these emails. It would be great if I can use a picture that I have pasted in a cell in the worksheet, example A1.
    Can anyone please assist?

    The code I used is:




    Option Explicit

    Public FormulaCell As Range


    Sub Mail_with_outlook2()
    Dim OutApp As Object
    Dim OutMail As Object
    Dim strto As String, strcc As String, strbcc As String
    Dim strsub As String, strbody As String

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    strto = Cells(FormulaCell.Row, "K").Value
    strcc = ""
    strbcc = ""
    strsub = "Subject"
    strbody = "Dear " & Cells(FormulaCell.Row, "A").Value & vbNewLine & vbNewLine & _
    "Just a friendly reminder that your " & Cells(FormulaCell.Row, "L").Value & " Items will need to be replaced in a months time." & _
    vbNewLine & vbNewLine & "We will contact you within the next two weeks to expedite delivery" & vbNewLine & vbNewLine & _
    vbNewLine & vbNewLine & "Thank you and kind Regards," & vbNewLine & vbNewLine & _
    "Sender"

    With OutMail
    .To = strto
    .CC = strcc
    .BCC = strbcc
    .Subject = strsub
    .Body = strbody
    .Display
    End With

    Set OutMail = Nothing
    Set OutApp = Nothing
    End Sub
    Last edited by zach.sauls; 11-06-2013 at 02:44 PM. Reason: Typo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel range in picture to outlook email using VBA??
    By jjin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2013, 01:32 AM
  2. [SOLVED] VBA - Save, and Embed in Email (Outlook)
    By jlo33 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-19-2013, 10:10 AM
  3. 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
  4. Email using Excel VBA and Keeping Outlook Signature on the Email
    By Shama in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2009, 07:39 PM
  5. Sending email with outlook signature
    By sexcel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-04-2008, 10:12 PM

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