+ 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
    3,002
    Thank Post
    265
    Thanked 795 Times in 602 Posts
    Rep Power
    289
    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,460
    Thank Post
    646
    Thanked 1,614 Times in 1,444 Posts
    Rep Power
    419
    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,218
    Thank Post
    597
    Thanked 158 Times in 143 Posts
    Blog Entries
    78
    Rep Power
    80
    Nice script! Cheers, may nab this myself!

  8. #7


    Join Date
    Feb 2007
    Location
    51.403651, -0.515458
    Posts
    8,878
    Thank Post
    226
    Thanked 2,669 Times in 1,968 Posts
    Rep Power
    786
    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 "
    $emailTo = "test@example.net"
     
    $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)

  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
  •