+ Reply to Thread
Results 1 to 1 of 1

Send chart with attachment to multiple receipt's vba

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Send chart with attachment to multiple receipt's vba

    Dear expert

    i want run macro to send charts through from list of precipitant in excel vba

    i have 5 charts in sheet1 i want view the chart in body of text in outlook to particular mail id's

    please find the attachment of sendchart

    and desire result file also


    Check this code where can i assign this task ?
    Sub Preview()

    I = Cells(2, "B").Value ' dynamising startrownumber to user fed value at cell B2

    Do ' start the action ,buddy!!!!


    Subj = Cells(I, "A").Value
    Filepath = Cells(I, "B").Value
    EmailTo = Cells(I, "C").Value
    CCto = Cells(I, "D").Value
    msg = Cells(I, "E").Value


    Application.DisplayAlerts = False

    Dim OutApp As Object
    Dim OutMail As Object
    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)
    On Error Resume Next
    With OutMail
    .To = EmailTo
    .CC = CCto
    .BCC = ""
    .Subject = Subj
    .body = msg
    .Attachments.Add Filepath
    .display


    End With
    On Error GoTo 0
    Set OutMail = Nothing
    Set OutApp = Nothing

    Application.DisplayAlerts = True

    I = I + 1

    Cells(1, "A").Value = "Outlook sent Time,Dynamic msg preview count =" & I - 3

    Loop Until Cells(I, "C").Value = ""


    End Sub
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by breadwinner; 06-27-2013 at 10:02 PM. Reason: post vba code

+ 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