Send mail from Excel

[sithica]

Hi,
Able to send mail using VBA code from Excel sheet using outlool. But I want to send mail without opening the excel sheet, using scheduler.( Excel sheet contain code with validation)
How can I make it? kindly help

 

[Dan_W]

When you say you want to send the email without opening the spreadsheet, what about opening the Excel application (and not the workbook)? In any event, if you're going to be sending the emails by using Outlook, why not just use Outlook VBA? It would be nearly identical code (depending on your position about opening the Excel application).

Failing all of that, yes it is doable - you could always use VBScript, access the data in the spreadsheet with ADO (assuming it has to be saved in XLSX format and that you couldn't save it in CSV), and then send the emails through CDO. It all just depends on how involved the code will become. Let me know re: my questions above, and subject to any suggestions anyone else might have, I can give you a steer.