VBA code support

Hi Community,

I have attached one file it is an email sender. It works fine with outlook however I needed some addition in it. It will be a great help for me. Thanking everyone well in advance.

Additions required

1. Receiver's Name

2. ID

3. Sender's name

4. Records Sheet - Need to collect all the records from send email sheet along with date and time( date and time should have its own column)

Thanks again.