+ Post New Thread
Results 1 to 7 of 7
How do you do....it? Thread, Automating weekly email to staff? in Technical; A suggestion that has been made to me is to send out a form weekly to staff asking them if ...
  1. #1
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,548
    Thank Post
    517
    Thanked 56 Times in 50 Posts
    Rep Power
    29

    Automating weekly email to staff?

    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

  2. #2


    Join Date
    May 2009
    Posts
    2,947
    Thank Post
    259
    Thanked 779 Times in 592 Posts
    Rep Power
    285
    Use a scheduled task to trigger a powershell script.

    example script.

  3. Thanks to pcstru from:

    reggiep (3rd May 2013)

  4. #3

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,343
    Thank Post
    624
    Thanked 1,584 Times in 1,421 Posts
    Rep Power
    414
    What!!!!!! hell no

    Ben

  5. #4
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,548
    Thank Post
    517
    Thanked 56 Times in 50 Posts
    Rep Power
    29
    Quote Originally Posted by pcstru View Post
    Use a scheduled task to trigger a powershell script.

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

  6. #5
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,548
    Thank Post
    517
    Thanked 56 Times in 50 Posts
    Rep Power
    29
    Quote Originally Posted by plexer View Post
    What!!!!!! hell no

    Ben
    Hell yes!

  7. #6
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,173
    Thank Post
    569
    Thanked 153 Times in 139 Posts
    Blog Entries
    78
    Rep Power
    80
    Nice script! Cheers, may nab this myself!

  8. #7


    Join Date
    Feb 2007
    Location
    51.405546, -0.510212
    Posts
    8,769
    Thank Post
    222
    Thanked 2,630 Times in 1,938 Posts
    Rep Power
    779
    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.

    Code:
    $emailSmtpServer = "smtp.gmail.com"
    $emailSmtpServerPort = "587"
    $emailSmtpUser = "username@gmail.com"
    $emailSmtpPass = "password"
     
    $emailFrom = "Reggie <reggie@gmail.com>"
    $emailTo = "test@example.net"
     
    $emailMessage = New-Object System.Net.Mail.MailMessage($emailFrom, $emailTo)
    $emailMessage.Subject = "Test e-mail"
    $emailMessage.IsBodyHtml = $true
    $emailMessage.Body = @"
    <p>This message is <strong>HTML formatted</strong>.</p>
    "@
     
    $SMTPClient = New-Object System.Net.Mail.SmtpClient($emailSmtpServer, $emailSmtpServerPort)
    $SMTPClient.EnableSSL = $true
    $SMTPClient.Credentials = New-Object System.Net.NetworkCredential($emailSmtpUser, $emailSmtpPass);
    
    $SMTPClient.Send($emailMessage)

  9. Thanks to Arthur from:

    reggiep (8th May 2013)

SHARE:
+ Post New Thread

Similar Threads

  1. Migrating staff email to office 365
    By tj2419 in forum Cloud Services
    Replies: 16
    Last Post: 6th October 2012, 03:25 AM
  2. Send email to one address only
    By rhyds in forum Windows
    Replies: 8
    Last Post: 3rd March 2008, 01:56 PM
  3. Replies: 5
    Last Post: 28th February 2008, 04:57 PM
  4. Replies: 2
    Last Post: 10th October 2007, 07:57 AM
  5. Outlook 2007 sending emails to @local
    By Mintsoft in forum Windows
    Replies: 0
    Last Post: 7th July 2006, 11:52 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •