this is my plan,
workbook 1.xls : contains data for the day. on button click it will be emailed via outlook.
the receiver will merge (append) it with workbook2.xls for the data recieved.
any idea how i could do this?