locked
send a file via email using a condition (Powershell Script) RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    as you show in the example below (CSVfile) i would like to send the PDF file using the path to the appropriate email, to 149 users automatically.
    I like to know how I can do it using a powershell script

    Email	                                  link
contoso1@***.com	           c:\\desktop\contoso1.pdf
contoso2@***.com	           c:\\desktop\contoso2.pdf

    Best Reagards

    Amir




    • Edited by Amir1989 Thursday, July 25, 2019 8:28 AM
    Thursday, July 25, 2019 7:40 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    How to post code in Technet Forums

    Please carefully review the following links to set your expectation for posting in technical forums.

    Learning to script properly with PowerShell

    What you should not do

    \_(ツ)_/


    • Edited by jrv Thursday, July 25, 2019 8:01 AM
    Thursday, July 25, 2019 8:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    1..147 | % {

    $file = "C:\desktop\contoso$($_).pdf"

    ....  your code to send e-mail using send-mailmessage cmdlet

    }

    Thursday, July 25, 2019 8:38 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    1..147 | % {

    $file = "C:\desktop\contoso$($_).pdf"

    ....  your code to send e-mail using send-mailmessage cmdlet

    }

    The CC field is how we send a message to multiple users. With Send-Message we can also us the "To" field for multiple users.

    help send-mailmessage -online

    \_(ツ)_/

    Thursday, July 25, 2019 8:43 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    yeah sure but i guess the OP wants to send different attachment to different email.. so.. your advice doesnt match this scenario imo
    Thursday, July 25, 2019 8:53 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    yeah sure but i guess the OP wants to send different attachment to different email.. so.. your advice doesnt match this scenario imo

    Nope. The CSV example is just odd because the user doesn't know about code, CSV files and email.  He thinks like mopst non-techs that you have to send separate messages to each users.  This is something that new techs are no trained in and that most users don't understand because tyhey think this is how the GUI does it.  The magic all happens on the SMTP server and not the client.

    \_(ツ)_/

    Thursday, July 25, 2019 9:02 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    thats what i mean exactly "send different attachment to different email"
    Thursday, July 25, 2019 9:08 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    thats what i mean exactly "send different attachment to different email"

    that isn't what you posted.

    You need to read the CSV in a loop and use the properties to address each message. I posted the CmdLet help.  Now get help on how to use loops.'

    Here is a basic tutorial on how to use PowerShell: https://channel9.msdn.com/Series/Getting-Started-with-Microsoft-PowerShell?l=r54IrOWy_2304984382

    \_(ツ)_/

    Thursday, July 25, 2019 9:23 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Please everybody. Stop being sorry and think. Computers ae about learning how to think about what you are doing. Think clearly. Understand your problem and explain it carefully and accurately.

    How to ask questions in a technical forum

    \_(ツ)_/

    Thursday, July 25, 2019 11:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Amir,

    you can use below script block to send email, just complete Send-MailMessage command:

    $csvInfo=import-csv <csv file path>
foreach($row in $csvInfo)
{
  $to_Email= $row.email
  $file_To_Be_Attached =$row.link
  #use above variables in your Send-MailMessage Command
  Send-MailMessage -Attachments $file_To_Be_Attached -To $to_Email #<and other required parameters>
}

    Thursday, July 25, 2019 2:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Was your issue resolved?

    If you resolved it using our solution, please "mark it as answer" to help other community members find the helpful reply quickly.

    If you resolve it using your own solution, please share your experience and solution here. It will be very beneficial for other community members who have similar questions.

    If no, please reply and tell us the current situation in order to provide further help.

    Best Regards,

    Lee

    Just do it.

    Wednesday, July 31, 2019 6:36 AM