mmcompact
asked on
Email template with variation in subject and attachment
I need to send some emails everyday with almost the same format:
To: someone1@gmail.com
CC: someone2@gmail.com, someone3@gmail.com
Content:
"some text..."
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.
To: someone1@gmail.com
CC: someone2@gmail.com, someone3@gmail.com
Content:
"some text..."
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.
ASKER
BlueDevilFan:
Thanks. The HTMLbody is actually a quite long html file. Can I still copy and paste the content there or I need to link to the actual file?
Thanks. The HTMLbody is actually a quite long html file. Can I still copy and paste the content there or I need to link to the actual file?
I can add code that reads in from the file or you can copy and paste. You're choice.
ASKER
Read from file will be better. thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This should do it.
Open in new window