我正在写一个脚本tp自动发送一个pdf文件,当它已经写入到某个文件夹。它几乎可以工作,但如果我有一个附件,我得到一个语法错误,我把文件的名称作为常量放在代码中,它与附件一起工作。但是,一旦我获取找到的文件的名称,它就不起作用了。这是我的代码。错误为"800401E4 CDO.Message.1“
FOLDER_PDF = "T:\MBö\AusdruckLieferverzug"
FOLDER_MOVE = "T:\MBö\AusdruckLieferverzug\Sent"
set lobj_cdomsg = CreateObject("CDO.Message")
Set objRegEx = CreateObject("VBScript.RegExp")
Set objFSO = CreateObject("Scripting.FileSystemObject")
strPDFs = ""
For Each file In objFSO.GetFolder(FOLDER_PDF).Files
If LCase(objFSO.GetExtensionName(file.Path)) = "pdf" Then
strPDFs = """" & file.Path & """"
End If
lobj_cdomsg.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
lobj_cdomsg.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "mail04.provider.de"
lobj_cdomsg.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 465
lobj_cdomsg.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "testperson@firma.de"
lobj_cdomsg.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "xxxxxx"
lobj_cdomsg.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 465 '
lobj_cdomsg.To = "testperson@apt.de"
lobj_cdomsg.From = "testperson@apt.de"
lobj_cdomsg.Subject = "Lieferverzug"
lobj_cdomsg.TextBody = "Bitte finden Sie als Anlage eine PDF-Datei mit den Artikeln, die im Lieferverzug sind." & vbCRLF
strCmd = "lobj_cdomsg.AddAttachment " & strPDFs
WScript.Echo strCmd
lobj_cdomsg.AddAttachment strPDFs
'The following code works but not the code line before, although the content of strPDFs is exactly the same
'lobj_cdomsg.AddAttachment "T:\MBö\AusdruckLieferverzug\tesdatei.pdf"
'objFile.Close
' Dann ganzes abschicken
lobj_cdomsg.Configuration.Fields.Update
lobj_cdomsg.Send
Set lobj_cdomsg = Nothing
Next 你能帮我找出错误吗?提前感谢
发布于 2017-09-18 21:14:22
我发现了错误:
这是命令:strPDF=“& file.Path &”
如果我不加引号,它就会起作用。正确的语法是:strPDF= file.Path
……lobj_cdomsg.AddAttachment strPDF
我希望它能对其他人有用。
https://stackoverflow.com/questions/46221813
复制相似问题