![]() ![]() If your insurance is in the name of a parent company, please provide a breakdown of the companies covered from your insurer. ![]() "Please ensure that the above information is provided by your insurance broker, or your insurer, in the form of a standard letter or certificate. "Due for Period: " & "" & Format(Range("BE" & ActiveCell.Row), "dd" & " Mmmm " & "yyyy") & "" & " - " & "" & Format(Range("BE" & ActiveCell.Row) + 365, "dd" & " Mmmm " & "yyyy") & "" & vbNewLine & vbNewLine & _ 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 |