Does anyone know of a utility that will automatically pull a number out of an Excel spreadsheet and mail it to someone everyday? I want to report a daily account balance to someone but want to automate it as much as possible. Perhaps I can do this with Visual Basic?
You can do this pretty easily from VB, CDO and using the exposed Excel objects. Start here: Intro to CDO on MSDN site edit: I'm 99% sure you will have to have the SMTP service running on your OS for this to work. It is part of IIS.