Automating weekly email to staff?

[reggiep]

A suggestion that has been made to me is to send out a form weekly to staff asking them if they have any IT requests for the week such as booking a photographer for an event, a projector in the gym, microphones in the hall etc.

 

As I am inherently lazy I don't want to have to get in every Monday and send the email, I want to automate this instead BUT I don't think outlook will do this without an add on.

 

Can anyone suggest how I can automate this?

 

Thanks

[pcstru]

Use a scheduled task to trigger a powershell script.

 

example script.

[plexer]

What!!!!!! hell no

 

Ben

[reggiep]

Use a scheduled task to trigger a powershell script.

 

example script.

 

Thanks, that works a treat. I just don't use powershell enough!

[reggiep]

What!!!!!! hell no

 

Ben

 

Hell yes!

[TheScarfedOne]

Nice script! Cheers, may nab this myself!

[Arthur]

Also worth mentioning is that if your SMTP server requires authentication and TLS (e.g. Gmail) you will need to use a slightly different Powershell script.

 

$emailSmtpServer = "smtp.gmail.com"
$emailSmtpServerPort = "587"
$emailSmtpUser = "[email protected]"
$emailSmtpPass = "password"

$emailFrom = "Reggie "
$emailTo = "[email protected]"

$emailMessage = New-Object System.Net.Mail.MailMessage($emailFrom, $emailTo)
$emailMessage.Subject = "Test e-mail"
$emailMessage.IsBodyHtml = $true
$emailMessage.Body = @"

This message is HTML formatted.
"@

$SMTPClient = New-Object System.Net.Mail.SmtpClient($emailSmtpServer, $emailSmtpServerPort)
$SMTPClient.EnableSSL = $true
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential($emailSmtpUser, $emailSmtpPass);

$SMTPClient.Send($emailMessage)