Here's the problem.
Every week i need to send a .xls file via email.
Using VB, can I create a macro or something to automatically email my excel report?
Thanks

I recommend that you should convert the funciton to run on the server as either a VBS batch file using Windows Scripting Host (see http://www.greggriffiths.org/webdev/wsh/ for more) or the Unix equiverlant depending on your host.

THanks a bunch

There is a VBA command that will email a spreadsheet, it however needs an input to allow the macro to send the email as security patches now block automatic email sends.

ActiveWorkbook.SendMail Recipients:="[email protected]", Subject:="Mileage report"

Roger Waters

uhm, where do i insert that code/?
forgive me. im a newbie