I need to send some emails everyday with almost the same format:
CC: email@example.com, firstname.lastname@example.org
The only difference are:
Subject: Company Report 03-11
Attachment: 2011-03-11 Company Report.xls
Both of the dates will be today's date, and the excel file is already in the same folder "H:\Reports" with correct name
How can I use some VBA to do this automatically? I don't need to send it right away, have to edit something before sending.