Excel Template With Macro For Sending Mails And Attachment Through Outlook

[burzum]

Thanks for this VB script. It is very close to what I'm looking to do.

My question is: How can I apply this script on a row by row basis?

I would like to be able to send a single or a few emails at a time. For example, if I want to send the email with the attachment and the values are stored in row 6 of the current sheet, is there a way to set the macro to prompt me to enter the row(s) I want it to process for recipient, subject attachment, body, etc?