Cuirfidh an VBA seo an seoltóir agus gach faighteoir ríomhphoist go huathoibríoch mar theagmhálaithe nua agus tú ag freagairt an ríomhphoist in Outlook. Déan mar a leanas le do thoil:

1. Brúigh Eile + F11 eochracha chun an fhuinneog Microsoft Visual Basic for Applications a oscailt.

2. Leathnaigh an Tionscadal1, agus cliceáil faoi dhó ThisOutlookSession chun é a oscailt, agus ansin greamaigh faoi bhun chód VBA isteach i bhfuinneog ThisOutlookSession. Féach an pictiúr:

VBA: Auto Cuir Teagmhálacha ó r-phost agus tú ag freagairt in Outlook

Public WithEvents xExplorer As Outlook.Explorer
Public WithEvents xMailItem As Outlook.MailItem
Sub Application_Startup()
Set xExplorer = Outlook.Application.ActiveExplorer
End Sub

Private Sub xExplorer_SelectionChange()
On Error Resume Next
Set xMailItem = xExplorer.Selection.Item(1)
End Sub

Private Sub xMailItem_Reply(ByVal Response As Object, Cancel As Boolean)
Dim xNameSpace As NameSpace
Dim xSenderAddress As String
Dim xContactItems As Outlook.Items
Dim i, k As Long
Dim xFilterAddress As String
Dim xContact As Outlook.ContactItem
Dim xNewContact As Outlook.ContactItem
Dim Arr() As String
Dim ArrName() As String
Dim xArrCount As Integer
On Error Resume Next
ReDim Arr(xMailItem.Recipients.Count + 1)
ReDim ArrName(xMailItem.Recipients.Count + 1)
xSenderAddress = xMailItem.SenderEmailAddress
Arr(0) = xSenderAddress
ArrName(0) = xMailItem.SenderName
For i = LBound(Arr) + 1 To UBound(Arr) - 1
Arr(i) = xMailItem.Recipients.Item(i).Address
ArrName(i) = xMailItem.Recipients.Item(i).Name
Next i
Set xNameSpace = Outlook.Application.GetNamespace("MAPI")
Set xContactItems = xNameSpace.GetDefaultFolder(olFolderContacts).Items
For i = LBound(Arr) To UBound(Arr) - 1
For k = 1 To 3
xFilterAddress = "[Email" & k & "Address] = " & Arr(i)
Set xContact = xContactItems.Find(xFilterAddress)
If Not (xContact Is Nothing) Then
Exit For
End If
Next k
If xContact Is Nothing Then
Set xNewContact = Outlook.Application.CreateItem(olContactItem)
With xNewContact
.FullName = ArrName(i)
.Email1Address = Arr(i)
.Categories = "From Email"
.Save
End With
End If
Next i
End Sub

3. Sábháil an cód VBA, agus déan do Microsoft Outlook a atosú.

As seo amach, nuair a thabharfaidh tú freagra ar r-phost in Outlook, sábhálfar seoltóir an ríomhphoist seo agus gach faighteoir mar theagmhálacha nua go huathoibríoch i bhfillteán teagmhála réamhshocraithe an chuntais ríomhphoist réamhshocraithe.

Conas baisc teagmhálacha a sheoladh ó ríomhphoist / fillteán Míreanna Seolta in Outlook?

Conas mórchóir teagmhálacha a chur leis an ngrúpa teagmhála in Outlook?