automatic emailer

Discussion in 'Trading Software' started by Foz, Jan 28, 2003.

  1. Foz


    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?
  2. 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.