I need to creat 1 excel invoice sheet in which the invoice number should automatically change and the file to save to a folder (d:\invoice )and the total amount should automatically transfer to sheet 2 and from there the daily total invoice amount should send to my email. in a single click of a command button. ihave created the invoice. can any one help with the code in vba for this plzz