Save As & email via Outlook with VBA???
Posted by Tom Urtis on June 12, 2001 7:16 PM
Hello fellow Excel-ites:
In Excel 2000 I maintain a template file with a macro that manipulates the day's business transactions, to ultimately display a snappy summary report.
This template file must then be Saved As in the file name syntax "mm-dd-yyyy Report" (today's report is called "06/12/2001 Report"), and emailed via Outlook to the bosses, which I have been doing manually.
Three questions regarding possibly adding VBA code at the end of my data manipulation macro:
(1) What VBA code (if any) would Save As the template file in this syntax, considering that the current date would be part of the Saved As file name.
(2) Could such code specify the drive & folder where the Saved As file should be placed? I place these saved as files in J:\Transactions\Reports.
(3) That Saved As file is then emailed internally via Outlook to John Doe, copy to Dewey Cheatem and Mae Onayz. Could VBA handle that task?
Any direction would be greatly appreciated. TIA.