baydeniro
Altın Üye
- Katılım
- 26 Ocak 2007
- Mesajlar
- 4,625
- Excel Vers. ve Dili
- Ofis 2016
- Altın Üyelik Bitiş Tarihi
- 20-02-2025
Merhaba Arkadaşlar,
Aşağıdaki kod ile Excelin içindeyken Outlooktan mail silmenin mümkün olduğu belirtilmiş ama beceremedim.
Bu kodu modüle yazıp, butona bağladım. Ama çalışmadı. Nerede hata yapıyor olabilirim acaba ?
https://www.ozgrid.com/forum/forum/other-software-applications/excel-and-or-email-help/123004-outlook-mail-selection-using-vba
linkindeki 4.mesajda
Public Sub Move_Inbox_Emails_From_Excel()
Dim outApp As Object
Dim outNS As Object
Dim inboxFolder As Object
Dim destFolder As Object
Dim outEmail As Object
Dim inboxItems As Object
Dim i As Integer
Dim inputNumber As String
Dim numberToMove As Integer
inputNumber = InputBox("Enter number of emails to move")
On Error Resume Next
numberToMove = CInt(inputNumber)
On Error GoTo 0
If numberToMove < 1 Then Exit Sub
Set outApp = CreateObject("Outlook.Application")
Set outNS = outApp.GetNamespace("MAPI")
Set inboxFolder = outNS.GetDefaultFolder(olFolderInbox)
Set destFolder = inboxFolder.Parent.Folders("ARŞİV") 'Test folder at same level as Inbox
'Sort Inbox items by Received Time
Set inboxItems = inboxFolder.Items
inboxItems.Sort "[ReceivedTime]", False 'ascending order (oldest first)
'inboxItems.Sort "[ReceivedTime]", True 'descending order (newest first)
'Loop through sorted items for the number entered by the user, up to the number of items in the Inbox
For i = 1 To Application.WorksheetFunction.Min(inboxItems.Count, numberToMove)
Set outEmail = inboxItems(i)
'Debug.Print i, outEmail.Subject
outEmail.Move destFolder
Next
End Sub
Aşağıdaki kod ile Excelin içindeyken Outlooktan mail silmenin mümkün olduğu belirtilmiş ama beceremedim.
Bu kodu modüle yazıp, butona bağladım. Ama çalışmadı. Nerede hata yapıyor olabilirim acaba ?
https://www.ozgrid.com/forum/forum/other-software-applications/excel-and-or-email-help/123004-outlook-mail-selection-using-vba
linkindeki 4.mesajda
Public Sub Move_Inbox_Emails_From_Excel()
Dim outApp As Object
Dim outNS As Object
Dim inboxFolder As Object
Dim destFolder As Object
Dim outEmail As Object
Dim inboxItems As Object
Dim i As Integer
Dim inputNumber As String
Dim numberToMove As Integer
inputNumber = InputBox("Enter number of emails to move")
On Error Resume Next
numberToMove = CInt(inputNumber)
On Error GoTo 0
If numberToMove < 1 Then Exit Sub
Set outApp = CreateObject("Outlook.Application")
Set outNS = outApp.GetNamespace("MAPI")
Set inboxFolder = outNS.GetDefaultFolder(olFolderInbox)
Set destFolder = inboxFolder.Parent.Folders("ARŞİV") 'Test folder at same level as Inbox
'Sort Inbox items by Received Time
Set inboxItems = inboxFolder.Items
inboxItems.Sort "[ReceivedTime]", False 'ascending order (oldest first)
'inboxItems.Sort "[ReceivedTime]", True 'descending order (newest first)
'Loop through sorted items for the number entered by the user, up to the number of items in the Inbox
For i = 1 To Application.WorksheetFunction.Min(inboxItems.Count, numberToMove)
Set outEmail = inboxItems(i)
'Debug.Print i, outEmail.Subject
outEmail.Move destFolder
Next
End Sub