Looping through Filter and then copying the data so I can paste or put into outlook body

HI JOSH,

Thanks a lot........... codes shared by you is working fine BUT I DON'T WANT PAST DATA ON MAIL BODY INSTEAD OF IT I WANT TO ATTACHE IT AS EXCEL FILE WITH MAIL. Plz guide if possible ,for your help I will be indebted to you forever.