SQL 2000

Hi there
Can anyone tell me how to do the following

I have a stored proccedure in sql 2000 to send an email on a scheduled job I want to run, however I want to have the output of the job added into the email,I have used the BCP command in my batch job and the output is exported to excel, can this sheet be attached to the auto email? does anyone know how to do this?

Also, what is the code for todays date – 2 days, i.e 2 days ago?