Sending email from a selected row with body text from multiple cells

[Excel_Test_21]

Hello,
I need help creating a code to generate an email when I select a specific row.

For example: if my cursor is cell C4, I want specific cells in that row to populate in the email body as a reference and subject line
if I put the mouse cursor in C2 or C3 i would want the results from that row as followed.

subject would be A4 - B4 C4 - D4 - E4
body would be in separate lines

A4
B4 C4
D4
E4
F4
G4

I found a way to create this ribbon button and just need to active it with a code

 

[Nai Robi]

After several searches I found this post and it was exactly what I was looking for. I also needed to include a link to a file located on a server. Perfect for my use case and in this case so much better than the =Hyperlink() function.

 

[mumps]

Hello and welcome to the Forum. Please start your own new thread and paste a link to this thread if you found it useful.

 

[pksunil1969]

This code is working fine.

I want to attach file to the email. Path for this file is added in separate column, (Column H), Can you help me for the same.