![]() ![]() Please can you provide us with these details for the following insurance as soon as possible, in order to remain active on our systems:" & vbNewLine & vbNewLine & _ "Our records show that your insurance is due to expire on: " & "" & Format(Range("BE" & ActiveCell.Row), "dd" & " Mmmm " & "yyyy") & "." & "" & " To ensure that you remain active on our systems as an approved Hewden Stuart Ltd Supplier, it is important that you provide us with the details of your renewed insurance policy. "" & "This is an urgent update on the status of your account." & "" & vbNewLine & _ Strbody = "" & "Dear Sirs," & "" & vbNewLine & vbNewLine & _ ![]() Set OutApp = CreateObject("Outlook.Application") If Target.Row > 7 And Target.Value = "Take Action" Then If Target.Column = Range("BL1").Column Then How could I amend my code to put this in? Private Sub Worksheet_SelectionChange(ByVal Target As Range) I want to add a signature, with an image, to my email body. I use this VBA code to send an email when a user clicks a cell in a row. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |