To copy data of one excel to another and add one column in the copied excel and send

[Bill Crawley]

In that case, I'm not going to re-invent the wheel. There are lots of examples out there. To get you started google using ado.net with excel This will gove you lots of start points. http://support.microsoft.com/kb/316934 is a good start point