Copy a range of data then E-Mail
 

I prefer to copy a range of data ex. B4:H27 to the body of the message. Mix
of text and values. Copy values only. Then send to the same user each day.

Also we are using Office 2000 and XP both prompt repeatedly for user input
when using any Excel SendMail code. Is there a way around this? I need to
schedule this as a task each morning without any user intervention.

I don't want to buy any third party software just do this using Excel VBA or
VB6.

Any suggestions, samples etc. would be really appreciated.

Thanks,
Bob