Auto Email and Send as Attachment

[Guitarfool5931]

I found a subject similar to this but it was a couple of years old and was wondering if there was a more efficient way of doing this with newer versions of Excel.

I am putting together a feedback sheet that I am emailing customers. Ideally i would like to include a Hyperlink on the top that says something like "Send Feedback". When it's pressed I would like it to email the same file as an attachment but with the newly entered feedback info to 1 or 2 email addresses. I would prefer that a copy is not permanently saved on their computer (don't want to bog down anyone's memory). I am unaware of how to do this without VB code but if anyone has any suggestions please feel free. I am not proficient in writing or activating macros so please include as much detail as you can.

Thanks so much!

 

[VoG]

This should get you started http://www.rondebruin.nl/sendmail.htm

 

[Guitarfool5931]

This worked great! Very easy to read and implement. Thanks for taking the time to respond quick too.