Excel Template With Macro For Sending Mails And Attachment Through Outlook

[burzum]

Thank you bakerman, this script is exactly what I'm looking for.

I'm having a problem though in that if I copy a range of cells from another sheet to a blank row, the script triggers regardless of whether or not "OK" is in the targeted cell in the column. How can I modify the script to ONLY trigger when "OK" is typed into the targeted cells?

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=326972#p326972
https://eileenslounge.com/viewtopic.php?p=326853#p326853
https://eileenslounge.com/viewtopic.php?p=326446#p326446
https://eileenslounge.com/viewtopic.php?f=27&t=41986
https://eileenslounge.com/viewtopic.php?p=325610#p325610
https://eileenslounge.com/viewtopic.php?p=325609#p325609
https://eileenslounge.com/viewtopic.php?p=325605#p325605
https://eileenslounge.com/viewtopic.php?p=325548#p325548
https://eileenslounge.com/viewtopic.php?p=316441#p316441
https://eileenslounge.com/viewtopic.php?p=324736#p324736
https://eileenslounge.com/viewtopic.php?p=324990#p324990
https://eileenslounge.com/viewtopic.php?f=27&t=41937&p=325485#p325485
https://eileenslounge.com/viewtopic.php?p=325609#p325609
https://eileenslounge.com/viewtopic.php?p=325610#p325610
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGADdPM65i9PG
https://www.youtube.com/watch?v=3t8Mk4URi6g&lc=UgzoakhRXOsCaoRm_Nd4AaABAg. 8xzeMdC8IOGADdPQHFk_zm
http://www.eileenslounge.com/viewtopic.php?p=324457#p324457
http://www.eileenslounge.com/viewtopic.php?p=324064#p324064
http://www.eileenslounge.com/viewtopic.php?p=323960#p323960
https://www.youtube.com/watch?v=7VwD9KuyMk4&lc=UgyZCnNfnZRfgwzDlQF4AaABAg
https://www.youtube.com/watch?v=7VwD9KuyMk4&lc=UgyZCnNfnZRfgwzDlQF4AaABAg. ADd4m2zp_xDADd6Nnotj1C
s://www.youtube.com/watch?v=7VwD9KuyMk4&lc=UgySdtXqcaA27wQLd1t4AaABAg
http://www.eileenslounge.com/viewtopic.php?p=323959#p323959
http://www.eileenslounge.com/viewtopic.php?f=30&t=41784
http://www.eileenslounge.com/viewtopic.php?p=323966#p323966
http://www.eileenslounge.com/viewtopic.php?p=323959#p323959
http://www.eileenslounge.com/viewtopic.php?p=323960#p323960
http://www.eileenslounge.com/viewtopic.php?p=323894#p323894
http://www.eileenslounge.com/viewtopic.php?p=323843#p323843
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[bakerman]

Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Target.Column = 9 Then
        If UCase(Target.Value) = "OK" Then
            With CreateObject("Outlook.Application").CreateItem(0)
                .To = Cells(Target.Row, 8).Value
                .Subject = Cells(Target.Row, 4).Value
                .Body = "Dear " & Cells(Target.Row, 3).Value & " " & Cells(Target.Row, 2) & "," & vbLf & vbLf & _
                    "The attachment provided is my final consultation report." & vbLf & vbLf & _
                    "Sincerely yours" & vbLf & vbLf & _
                    "Burzum"
                .Attachments.Add Cells(Target.Row, 7).Value
                .Display '.Send
            End With
        End If
    End If
    
End Sub

[Excel Fox]

Did you try http://www.excelfox.com/forum/f18/se...email-ids-304/

[bandus]

No, I did not, and thanks for this really cool macro! However another question came up, but I posted it in this thread you linked me.

Thank you again!

[girapas]

This is an superb macro and I've regularly used it. Sometimes, I need to send more than one, and up to three, attachments. Is it possible to make it running the macro once?
Thanks in advance.

[Excel Fox]

Will have a look at that and get back.

[amitsmarttel]

HELLO ALL,

macro for emails sending work perfectly but now i have other problem, i have one fix table to send in all email on mail body this table is full of color.

can please share macro that perfectly work for this kind of requirement, also attach email body in image format for your review.


thanks in advance.