|
Subject:
|
Sending an automated email
|
|
Posted By:
|
luxx
|
Post Date:
|
12/29/2003 3:26:02 PM
|
Here's the problem.
Every week i need to send a .xls file via email.
Using VB, can I create a macro or something to automatically email my excel report?
Thanks
|
|
Reply By:
|
Greg Griffiths
|
Reply Date:
|
12/30/2003 4:27:22 PM
|
I recommend that you should convert the funciton to run on the server as either a VBS batch file using Windows Scripting Host (see http://www.greggriffiths.org/webdev/wsh/ for more) or the Unix equiverlant depending on your host.
|
|
Reply By:
|
luxx
|
Reply Date:
|
1/2/2004 11:28:28 AM
|
THanks a bunch
|
|
Reply By:
|
RogerWaters
|
Reply Date:
|
1/2/2004 11:37:05 AM
|
There is a VBA command that will email a spreadsheet, it however needs an input to allow the macro to send the email as security patches now block automatic email sends.
ActiveWorkbook.SendMail Recipients:="person@test.co.uk", Subject:="Mileage report"
Roger Waters
|
|
Reply By:
|
luxx
|
Reply Date:
|
1/2/2004 4:00:53 PM
|
uhm, where do i insert that code/?
forgive me. im a newbie
|
