Be Excellent To Each Other

And, you know, party on. Dude.

All times are UTC [ DST ]




Reply to topic  [ 9 posts ] 
Author Message
 Post subject: Send E-mail Automagically
PostPosted: Thu Sep 01, 2011 8:29 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12337
I'm trying to automate the final processes of my dying company, and need some help.
I have a process that polls store orders, imports into databases yadda yadda and creates a text file.
The only manual process left in this procedure is to e-mail the file to someone.

I need to create a script that can run at the same time every day (so something using Scheduled Tasks calling a batch file I guess) that picks up the same text file, and sends it to the same address.

This is literally to save me having to click New E-mail in Outlook every day at 12:15 and attach a file before clicking send.

Things to know:
I've tried a script called sendemail.exe that had a load of parameters set and it executes but doesn't seem to send a mail.
My PC that the file is sent from can be left on 24/7 with Outlook running.
I can send from gmail instead if it can be automated.

Does anyone have any ideas? I've Googled for similar ideas such as sending out the same weekly reports on a schedule which led me to the sendmail with batch file idea, but so far I'm still drawing a blank.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Send E-mail Automagically
PostPosted: Thu Sep 01, 2011 9:09 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49244
I'm assuming you have an SMTP relay server that you can use? If sendmail isn't working, it's possible that either:

The ISP you're using (if you're going over the internet) is blocking outbound SMTP connections. Lots of them do this.

Your Antivirus is blocking outbound SMTP connections. Lots of them do this.

To check, try to telnet to the SMTP server on port 25. If that fails, it's one of the above. If not, it's something else and we'll look again.

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Send E-mail Automagically
PostPosted: Thu Sep 01, 2011 9:19 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12337
I was testing using smtp.google.com but I can't get a connection to it so it must be work's outgoing firewall. Thank you anyway.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Send E-mail Automagically
PostPosted: Thu Sep 01, 2011 9:21 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49244
Yeah, your firewall is highly likely to not allow outbound SMTP. Find out from your mail team if they have an internal relay that you can use.

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Send E-mail Automagically
PostPosted: Thu Sep 01, 2011 9:22 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12337
Craster wrote:
Yeah, your firewall is highly likely to not allow outbound SMTP. Find out from your mail team if they have an internal relay that you can use.


Oh man, you're going to make me log a ticket and everything aren't you?

Thanks for the help though. Good to know I was on the right lines.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Send E-mail Automagically
PostPosted: Thu Sep 01, 2011 9:35 
User avatar
Unpossible!

Joined: 27th Jun, 2008
Posts: 38667
Mr Russell wrote:
Oh man, you're going to make me log a ticket and everything aren't you?

Logging jobs is the correct and proper thing to do. OBEY YOUR IT TEAM.


Top
 Profile  
 
 Post subject: Re: Send E-mail Automagically
PostPosted: Thu Sep 01, 2011 9:55 
User avatar
Master of dodgy spelling....

Joined: 25th Sep, 2008
Posts: 22646
Location: shropshire, uk
I just tryied to log a ticket as I could not access sharepoint with out it crashing..

WHen I submitted the ticket it crashed and lost the info... >:(

_________________
MetalAngel wrote:
Kovacs: From 'unresponsive' to 'kebab' in 3.5 seconds


Top
 Profile  
 
 Post subject: Re: Send E-mail Automagically
PostPosted: Thu Sep 01, 2011 10:12 
User avatar
ugvm'er at heart...

Joined: 4th Mar, 2010
Posts: 22396
DavPaz wrote:
Mr Russell wrote:
Oh man, you're going to make me log a ticket and everything aren't you?

Logging jobs is the correct and proper thing to do. OBEY YOUR IT TEAM.


Yeah, it's much easier to ignore if it is in the system. :D


Top
 Profile  
 
 Post subject: Re: Send E-mail Automagically
PostPosted: Thu Sep 08, 2011 6:37 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12337
Exciting update:

Got this working last week, and am very pleased with the results. Cheers for your help, all.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
Display posts from previous:  Sort by  
Reply to topic  [ 9 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: Majestic-12 [Bot] and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search within this thread:
You are using the 'Ted' forum. Bill doesn't really exist any more. Bogus!
Want to help out with the hosting / advertising costs? That's very nice of you.
Are you on a mobile phone? Try http://beex.co.uk/m/
RIP, Owen. RIP, MrC. RIP, Dimmers.

Powered by a very Grim... version of phpBB © 2000, 2002, 2005, 2007 phpBB Group.