Generate and populate an email from an Excel spreadsheet

Hi,

I have a spreadsheet that contains an email address (Each row will most likley have the same email address but there are occasions when it could be different). Ideally I want a button that when clicked will open up an email, popoulate it with the persons email (that is in a specific column and row), add a subject and some text to the main body of the email and then attach the spreadhseet itself.

I have looked at various web sites that provides answers to some of this but not all and being new to VBA I am struggling to piece it together! Perhaps it's the way I am going about it......

Any help would be greatly appreicated!

Thanks
MissDB

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

Yes, can you share the solution please?