Copy Range From Excel File in to Outlook with Signature

I'm not sure how to insert an Outlook signature from Excel vba, but my workaround uses code from Ron de Bruin's helpful website (link: https://www.rondebruin.nl/win/s1/outlook/bmail2.htm). I'm not sure if this can insert company logos, but it will at least insert the generic parts of the signature.

In the .HTMLBody = RangetoHTML(rng) line, you can insert more data after it by concatenating your signature. For example, you could enter:

Please Login or Register  to view this content.

Hi,
Thanks for your suggestion.

I have done it and also sharing below code if any one needs.

Please Login or Register  to view this content.