Powershell - Outlook - 向电子邮件添加多个附件

Question

我想在一封电子邮件中添加多个附件。一个没有问题，但是如果您尝试添加两个或更多，则会出错

我的代码

$file_patch=Get-ChildItem 'C:OUTLOOK' | Sort {$_.LastWriteTime} | select -last 1 | % { $_.FullName }
$name=Select-String -Path $file_patch -pattern name
$email=Select-String -Path $file_patch -pattern email
$subject=Select-String -Path $file_patch -pattern subject
$attachment=Select-String -Path $file_patch -pattern attachment
$Signature = Get-Content ($env:USERPROFILE + "AppDataRoamingMicrosoftSignatures*.htm")
$rname = $name -replace ".*:"
$remail = $email -replace ".*:"
$rsubject = $subject -replace ".*:"
$rattachment = $attachment -replace ".*attachment:"
$sname = $rname -split ";"
$semail = $remail -split ";"
$ssubject = $rsubject -split ";"
$sattachment = $rattachment -split ";"
$body=Get-Content C:OUTLOOKBODY$sname.txt
$Signature = Get-Content ($env:USERPROFILE + "AppDataRoamingMicrosoftSignatures*.htm")
$sRecipientAddr = $semail
$sMsgSubject = $ssubject
$oOutlook = New-Object -ComObject Outlook.Application 
$oMapiNs = $oOutlook.GetNameSpace("MAPI")
$oMailMsg = $oOutlook.CreateItem(0)
$oMailMsg.GetInspector.Activate()
$sSignature = $oMailMsg.HTMLBody
[Void]$oMailMsg.Recipients.Add($sRecipientAddr)
$oMailMsg.Attachments.Add($sattachment)
$oMailMsg.Subject = $sMsgSubject
$oMailMsg.HTMLBody = $body + $sSignature

我的文件

名称：展望
电子邮件：[e-mail];[e-mail];[e-mail]
主题：你很棒
附件："C：\outlook\attachment\sell.txt";"C：\展望\附件\输出.txt">

错误：

PS > Value does not fall within the expected range.
+ $oMailMsg.Attachments.Add($sattachment)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: (:) [], A
+ FullyQualifiedErrorId : System.ArgumentException

可能出了什么问题

Answer 1

您正在尝试将数组直接传递到.attachments.add() 中。此处的页面包含Add方法的用法。

因此，我认为如果您以稍微不同的方式添加附件，您应该会成功：

...
$sSignature = $oMailMsg.HTMLBody
[Void]$oMailMsg.Recipients.Add($sRecipientAddr)
$sattachment | ForEach-Object { $oMailMsg.Attachments.Add($_) }
$oMailMsg.Subject = $sMsgSubject
$oMailMsg.HTMLBody = $body + $sSignature

假设$sattachment = $rattachment -split ";"确实返回了一个字符串数组，则可以使用 ForEach-Object cmdlet 循环访问它。然后，将为每个数组元素调用 .Add() 方法，该元素由块中的$_表示。