Archive without attachments by VBA

Archive without attachments by Kutools for Outlook

This method will introduce a VBA to delete all attachments from the specified folder you will archive, and then you can archive without attachments. Please do as follows:

1. In the Mail view, select the folder you will archive, and press Alt + F11 keys to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and then paste below VBA into the new module window.

VBA: Remove all attachments from selected mail folder in Outlook

Public Sub SaveDeleteAttachments()
Dim xMailItem As Outlook.MailItem 'Object
Dim xAttachments As Outlook.Attachments
Dim i As Long
Dim xFolder As Folder
Dim xFilePath As String
Dim xFldPath As String
Dim xDeletedFilePath As String
On Error Resume Next
xFldPath = CreateObject("WScript.Shell").SpecialFolders(16)
xFldPath = xFldPath & "\MyAttachments"
If Dir(xFldPath, vbDirectory) = "" Then
MkDir xFldPath
End If
Set xFolder = Outlook.Application.ActiveExplorer.CurrentFolder
For Each xMailItem In xFolder.Items
If xMailItem.Class = olMail Then
Set xAttachments = xMailItem.Attachments
While xAttachments.Count > 0
xFilePath = xAttachments.Item(1).FileName
xFilePath = xFldPath & "\" & xFilePath
xAttachments.Item(1).SaveAsFile xFilePath
xAttachments.Item(1).Delete
If xMailItem.BodyFormat <> olFormatHTML Then
xDeletedFilePath = xDeletedFilePath & vbCrLf & "<file://" & xFilePath & ">"
Else
xDeletedFilePath = xDeletedFilePath & "
" & "" & xFilePath & ""
End If
Wend
If xDeletedFilePath <> "" Then
If xMailItem.BodyFormat <> olFormatHTML Then
xMailItem.Body = "The file(s) were saved to: " & xDeletedFilePath & vbCrLf & xMailItem.Body
Else
xMailItem.HTMLBody = "
" & _
"The file(s) were saved to: " & xDeletedFilePath & "
" & xMailItem.HTMLBody
End If
xMailItem.Save
xDeletedFilePath = ""
End If
End If
Next
Exit Sub:
Set xAttachments = Nothing
Set xMailItem = Nothing
End Sub

3. Press the F5 key or click the Run button to run the code. Then all attachments are removed from the selected mail folder immediately.

4. Click File > Info > Tools > Clean Up Old Items (or File > Info > Cleanup Tools > Archive).

5. In the Archive dialog box, please click to highlight the copied folder, type TODAY in the Archive items older than box, and then click the Browse button. See screenshot:

6. In the Open Outlook Data Files dialog box, please open the folder you will save the archived PST file in, name the PST file in the File name box, and then click the OK button. See screenshot:

7. Now you return to the Archive dialog box, please click the OK button to finish the archiving.
So far, you have archived the mail folder without any attachments.

If you have Kutools for Outlook installed, you can apply its Detach All feature to quickly delete all attachments from the specified folder you will archive, and then archive without attachments easily.

1. In the Mail view, open the specified mail folder you will archive, select all emails with pressing Ctrl + A keys, and then click Kutools > Detach All. See screenshot:

2. In the Please select a folder dialog box, click the Browse button  to specify the folder you will save the attachment in, specify a subfolder style from the create subfolders in the following style drop down list, and click the Ok button. See screenshot:

3. Please click Yes button and OK button successively in the popping out dialog boxes.

4. Go on to click File > Info > Tools > Clean Up Old Items (or File > Info > Cleanup Tools > Archive).

5. In the Archive dialog box, please click to highlight the specified folder you will archive without attachments, type TODAY in the Archive items older than box, and then click the Browse button. See screenshot:

6. In the Open Outlook Data Files dialog box, please open the folder you will save the archived PST file in, name the PST file in the File name box, and then click the OK button. See screenshot:

7. Now you return to the Archive dialog box, please click the OK button to finish the archiving.

So far, you have archived the specified mail folder without attachments already.

How to automatically archive attachments only in Outlook?

How to archive emails by year/month/date in Outlook?