VBA code to copy data from current workbook to another workbook and send email

Hi Guys

I have written the code that copies data across Sheet1 of current workbook.

Now the next step is to store data from sheet1 of Thisworkbook to another workbook named TemplateWB and send that as an attachment in the email. The another workbook name "TemplateWB" is stored in the following folder: "C:\abc\templates"

Can anyone please help me in the VbA code?

Thanks

No there won't be any data already present in TemplateWB. So the data will be inserted in Sheet1 of TemplateWB and later on the sheet1 will be cleared after being sent as an email.

Thanks xlbiznes. It worked. Actually TemplateWB has extension .xls.

Now next bit is my manager wants me to store data from Activesheet to a copy of TemplateWB. So everytime when the data needs to be copied then it should be copied in the copy of TemplateWB and then that copy should be sent as an attachment in the email. Any help would be much appreciated.

Thanks

Can anyone please help me in this? Thanks

Ok. There is a combobox with all the email addresses in the userform. so the user will select any of the email addresses and then press button. And on the click event of that button , the code will run and all the above steps will be performed. Thanks

And also the steps are below:

1. Cope the data from Activesheet and paste the data in a copy of Template file.
2. Then send that copy as an email

SO we will be storing data in the copy of template file so we are not going to mess aroung with the actual master file. Thanks