插入不同电子邮件地址的选择案例

Question

我有密码可以单击一个按钮来保存附件。

我们的货运团队想要，具体取决于哪个电子邮件与附件有关客户电子邮件的地址来保存在特定于客户的文件夹中。 （更改strfolderpath取决于情况。）

我想使用Select-case方法以更轻松的更改和添加。我尝试了多次更改。

如何为该用例添加Select-Case方法？

我的工作代码：

Sub SaveAttachments()
Dim objOL As Outlook.Application
Dim objMsg As Outlook.MailItem 'Object
Dim objAttachments As Outlook.Attachments
Dim objSelection As Outlook.Selection
Dim i As Long
Dim lngCount As Long
Dim strFile As String
Dim strFolderpath As String
Dim strDeletedFiles As String

' Instantiate an Outlook Application object.
Set objOL = CreateObject("Outlook.Application")

' Call the Namespace to see the sender e-mail address.
Set objNamespace = objOL.GetNamespace("MAPI")

' Get the collection of selected objects.
Set objSelection = objOL.ActiveExplorer.Selection

' Set the Attachment folder.
strFolderpath = "C:\Folder\Test\"

' Check each selected item for attachments. If attachments exist,
' save them to the strFolderPath folder and strip them from the item.
For Each objMsg In objSelection

    ' This code only strips attachments from mail items.
    ' If objMsg.class=olMail Then
    ' Get the Attachments collection of the item.
    Set objAttachments = objMsg.Attachments
    lngCount = objAttachments.Count
    strDeletedFiles = ""

    If lngCount > 0 Then

        ' We need to use a count down loop for removing items
        ' from a collection. Otherwise, the loop counter gets
        ' confused and only every other item is removed.

        For i = lngCount To 1 Step -1

            ' Save attachment before deleting from item.
            ' Get the file name.
            strFile = objAttachments.Item(i).FileName

            ' Combine with the path to the Temp folder.
            strFile = strFolderpath & strFile

            ' Save the attachment as a file.
            objAttachments.Item(i).SaveAsFile strFile

            ' Delete the attachment.
            objAttachments.Item(i).Delete

            'write the save as path to a string to add to the message
            'check for html and use html tags in link
            If objMsg.BodyFormat <> olFormatHTML Then
                strDeletedFiles = strDeletedFiles & vbCrLf & "<file://" & strFile & ">"
            Else
                strDeletedFiles = strDeletedFiles & "<br>" & "<a href='file://" & _
                strFile & "'>" & strFile & "</a>"
            End If

            'Use the MsgBox command to troubleshoot. Remove it from the final code.
            'MsgBox strDeletedFiles

        Next i

        ' Adds the filename string to the message body and save it
        ' Check for HTML body
        If objMsg.BodyFormat <> olFormatHTML Then
            objMsg.Body = vbCrLf & "The file(s) were saved to " & strDeletedFiles & vbCrLf & objMsg.Body
        Else
            objMsg.HTMLBody = "<p>" & "The file(s) were saved to " & strDeletedFiles & "</p>" & objMsg.HTMLBody
        End If
        objMsg.Save
    End If
Next

ExitSub:

Set objAttachments = Nothing
Set objMsg = Nothing
Set objSelection = Nothing
Set objOL = Nothing
Set objNamespace = Nothing
End Sub

Answer 1

您将需要选择案例才能在每个OBJMSG loop的内案例语法）。

For Each objMsg In objSelection
    Select Case True
        Case objMsg.SenderEmailAddress = "[email protected]"
            strFolderpath = "C:\Folder\sender1folder\"
        Case objMsg.SenderEmailAddress like "*domain.com"
            strFolderpath = "C:\Folder\otherfolder\"
        Case Else
            strFolderpath = "C:\Folder\Test\"
    End Select

    'rest of loop carry on here

Answer 2

我想将Select-Case方法用于此问题，以便将来更轻松地进行更改和添加，但是我现在就卡住了

不必使用选择案例操作员。您需要做的第一件事是在代码中获取发件人的SMTP地址，只有这样您才能确定要使用哪种路径。

要获取SMTP地址而不是Exchange One（x500），您可以尝试使用 equestEntry.getExchangeuser 方法，然后尝试检索

在 Howto：将基于Exchange的电子邮件地址转换为SMTP电子邮件地址文章。

检索SMTP地址后，您可以分析内容并选择适合保存附件的文件夹。