Hi
I was just wondering (before I have a go at programming it myself)..if anyone has any code that will automatically send an email using sendmail and capture the value of cell C10...just as the count down timer reaches 1 sec before the start of the race..
The attached file is semi automatic...but you still need to click on the send button..any ideas on how to make this fully automatic??
Thanks in advance
regards
Peter
Email From Excel..
Hi Peter
do you use outlook or any other client, I know that with outlook it is possible to send an email automatically, however the security will ask for manual intervention.
but by adding a proceedure to outlook and calling it from vba then you can bypass the security and send mails programatically.
http://www.everythingaccess.com/tutoria ... ty-Warning
is probably the best explanation, but its on something that I run myself each day so if you need any help give me a shout
do you use outlook or any other client, I know that with outlook it is possible to send an email automatically, however the security will ask for manual intervention.
but by adding a proceedure to outlook and calling it from vba then you can bypass the security and send mails programatically.
http://www.everythingaccess.com/tutoria ... ty-Warning
is probably the best explanation, but its on something that I run myself each day so if you need any help give me a shout