ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Powershell output in Email is Possible

    IT Discussion
    powershell send-mailmessage windows scripting
    5
    21
    3.5k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • L
      Lakshmana
      last edited by scottalanmiller

      I am getting the Date output in powershell is possible to come in Email(Outlook) through .bat ?

      1 Reply Last reply Reply Quote 1
      • L
        Lakshmana
        last edited by

        This is to automate the mail automatically and click the link from the site.Can anyone help on the same

        1 Reply Last reply Reply Quote 0
        • M
          Mike Davis
          last edited by

          I'm a little confused. You want a batch file to call a powershell script that generates an email with the date inserted in to it?

          L 1 Reply Last reply Reply Quote 1
          • S
            scottalanmiller
            last edited by

            But not skip the .bat and just use PowerShell?

            1 Reply Last reply Reply Quote 0
            • S
              scottalanmiller
              last edited by

              You can use the Send-Mailmessage command to do this in PS.

              1 Reply Last reply Reply Quote 1
              • L
                Lakshmana @Mike Davis
                last edited by

                @mike-davis said in Powershell output in Email is Possible:

                I'm a little confused. You want a batch file to call a powershell script that generates an email with the date inserted in to it?

                My idea is to call the powershell from .bat to which the output should be inserted in the mail.And then going to internal site to download the excel file automatically!

                S 1 Reply Last reply Reply Quote 0
                • S
                  scottalanmiller @Lakshmana
                  last edited by

                  @lakshmana said in Powershell output in Email is Possible:

                  @mike-davis said in Powershell output in Email is Possible:

                  I'm a little confused. You want a batch file to call a powershell script that generates an email with the date inserted in to it?

                  My idea is to call the powershell from .bat to which the output should be inserted in the mail.And then going to internal site to download the excel file automatically!

                  But why, once you have PowerShell, you never need to use .bat files again. Why use two languages when you can use just one?

                  1 Reply Last reply Reply Quote 1
                  • M
                    Mike Davis
                    last edited by

                    What would be calling the script? As Scott says, just call the .ps1 and forget about using a .bat

                    1 Reply Last reply Reply Quote 1
                    • O
                      Obsolesce
                      last edited by Obsolesce

                      I do that in a few places. A .bat file that calls a .ps1. And within that .ps1, I use this to send an email:

                      # Gets date:
                      $emailDate = Get-Date
                      
                      # -------------------- Specify Email Variables Below ------------------------- #
                      
                      # Specifies who the notification email goes to:
                      $emailTo = "you@domain.com"
                      
                      # Specifies who the notification email comes from:
                      $emailFrom = "Server Alert <serveralert@domain.com>"
                      
                      # Specifies the Subject of the notification email:
                      $emailSubject = "Your email subject"
                      
                      # Specifies the Body of the notification email:
                      $emailBody = "Body content in HTML format... how about an $emailDate.<br><br>Attached is a copy of the attachment.<br><br>More text:<br><br><font face='tahoma' size='5'>$servList</font>"
                      
                      # Specifies the attachment to include in the notification email:
                      $emailAttachment = "$dir\$latestBUErrorLog"
                      
                      # Specifies the name of the SMTP Server to use:
                      $emailSMTPServer = "smtpServer"
                      
                      # Specifies the SMTP Server Port to use:
                      $emailSMTPServerPort = "25"
                      
                      # ------------------- End Email Variables ------------------------------------ #
                      
                      Send-MailMessage -To "$emailTo" -From "$emailFrom" -Subject "$emailSubject" -Body "$emailBody" -BodyAsHtml -Attachments "$emailAttachment" -SmtpServer "$emailSMTPServer" -Port "$emailSMTPServerPort"
                      

                      And of course, you'll need to define those variables in the script before that line.

                      Edit: I'm including the variable definitions so Jared doesn't yell at me.

                      L 1 Reply Last reply Reply Quote 2
                      • L
                        Lakshmana @Obsolesce
                        last edited by

                        @tim_g This script in Powershell is good.How to call this from .Bat ?
                        I am in start command but the powershell closes automatically! Any suggestion here

                        S 1 Reply Last reply Reply Quote 0
                        • L
                          Lakshmana
                          last edited by

                          I need .bat because i will schedule this job in Windows Scheduler

                          S 1 Reply Last reply Reply Quote 0
                          • N
                            NerdyDad
                            last edited by

                            If you are using Task Scheduler, then you call powershell.exe and run the ps1 script as an option of the command. Just make sure you run it as an administrator.

                            1 Reply Last reply Reply Quote 2
                            • S
                              scottalanmiller @Lakshmana
                              last edited by

                              @lakshmana said in Powershell output in Email is Possible:

                              I need .bat because i will schedule this job in Windows Scheduler

                              You don't need BAT for that.

                              1 Reply Last reply Reply Quote 0
                              • S
                                scottalanmiller @Lakshmana
                                last edited by

                                @lakshmana said in Powershell output in Email is Possible:

                                @tim_g This script in Powershell is good.How to call this from .Bat ?
                                I am in start command but the powershell closes automatically! Any suggestion here

                                Batch files are "deprecated", don't use an old approach to do new things.

                                1 Reply Last reply Reply Quote 0
                                • L
                                  Lakshmana
                                  last edited by

                                  Then need to save this file and how to run this powershell command automatically ?any suggeations?

                                  S N 2 Replies Last reply Reply Quote 0
                                  • S
                                    scottalanmiller @Lakshmana
                                    last edited by

                                    @lakshmana said in Powershell output in Email is Possible:

                                    Then need to save this file and how to run this powershell command automatically ?any suggeations?

                                    I'm confused. What's the question? Just use PowerShell instead of BATCH. This is the purpose of PowerShell.

                                    L 1 Reply Last reply Reply Quote 0
                                    • L
                                      Lakshmana @scottalanmiller
                                      last edited by

                                      @scottalanmiller How to automate this powershell according some time interval in the machine ?

                                      S 1 Reply Last reply Reply Quote 0
                                      • S
                                        scottalanmiller @Lakshmana
                                        last edited by

                                        @lakshmana said in Powershell output in Email is Possible:

                                        @scottalanmiller How to automate this powershell according some time interval in the machine ?

                                        With the Task Scheduler.

                                        https://technet.microsoft.com/en-us/library/cc748993(v=ws.11).aspx

                                        1 Reply Last reply Reply Quote 2
                                        • L
                                          Lakshmana
                                          last edited by

                                          Ok Thanks

                                          1 Reply Last reply Reply Quote 0
                                          • N
                                            NerdyDad @Lakshmana
                                            last edited by

                                            @nerdydad said in Powershell output in Email is Possible:

                                            If you are using Task Scheduler, then you call powershell.exe and run the ps1 script as an option of the command. Just make sure you run it as an administrator.

                                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

                                            @lakshmana said in Powershell output in Email is Possible:

                                            Then need to save this file and how to run this powershell command automatically ?any suggeations?

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 2 / 2
                                            • First post
                                              Last post