sending a worksheet by email using vba

Hi all,
I have a workbook running with multiple sheets and on 1 sheet (called purchasing)
i need to be able to send it using outlook based on an email address i have in a cell

lets say cell a1 contains an address [email protected]
i want to press a button and send the sheet to that e mail address
i would like to be able to add a subject and message body text also
i have tried other examples that saved a copy of that sheet to a new workbook, sent it then close it without saving, but there was always a box that opened saying "warning an application is tyring to send mail blah blah blah" then you have to click yes to send the mail
it would be nice if possible if i could bypass this

any help would be greatly recieved

Hi,

If you are happy, can you please mark the Thread as Solved (see Rules for instructions)?

Thanks
Rob