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. Volunteering to 'pay forward' to return help I've received in the Microsoft user community.I use this VBA code to send an email when a user clicks a cell in a row. It overwrites typed text in part to make it harder to copy.

When I insert a signature in Word, it is a png file with a transparent background. What happens when I send my document to someone else? Will Word mess up my formatting? Among other things, it makes it much more likely that what the recipient sees is what I sent. Unless I want the recipient to be able to edit what I send, I send as pdf. Note, saving as pdf does NOT prevent anyone from copying, but it does make it harder. Not only the signature, but your letterhead / watermarks or other identifying/authenticating features. into PDFįormat and then only send it out to the recipient as a safety precaution for the signature.

So, does this mean that after typing any letter with signature in MS Word doc. Just a further request for a clarification.

How to insert signature in word 2017