![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
I keep getting this error after i have taken the attachments off
"object variable or with block variable not set " the line that causes it the one below Item.Move otherInbox.Folders("Flash Processed") i have included all the code below to help, i think its because i havent set move as a variable but not sure if i have to or even what type thanks for any help Private Sub CommandButton1_Click() 'On Error GoTo SaveAttachmentsToFolder_err Dim ns As NameSpace Dim Inbox As MAPIFolder Dim SubFolder As MAPIFolder Dim Item As Object Dim Atmt As Attachment Dim FileName, sel As String Dim i As Integer Dim varResponse As VbMsgBoxResult Dim oRecip As Outlook.Recipient Dim itemcheck As Boolean Dim myitem As Object Dim otherInbox As Outlook.MAPIFolder Dim iCount As Long Dim i1 As Long Set ns = GetNamespace("MAPI") Set oRecip = ns.CreateRecipient("Air Flash") If oRecip.Resolve() Then Set otherInbox = ns.GetSharedDefaultFolder(oRecip, olFolderInbox) Else MsgBox "No Mailbox" End If Set SubFolder = otherInbox.Folders("Flash Recieved") i = 0 If SubFolder.Items.Count = 0 Then MsgBox "There are no messages in the Sales Reports folder.", vbInformation, _ "Nothing Found" Exit Sub End If For Each Item In SubFolder.Items For Each Atmt In Item.Attachments If Right(Atmt.FileName, 3) = "xls" Then FileName = "\\iodine.euston.uk.ssp\groupshare\Finance\AIR FINANCE\Financial Analyst\AIR REPORTS\Flash\Air Flash Recieved\" & Atmt.FileName Atmt.SaveAsFile FileName i = i + 1 End If Next Atmt Next Item i = 1 iCount = SubFolder.Items.Count For i1 = iCount To 1 Step -1 Item.Move otherInbox.Folders("Flash Processed") Next ' Show summary message If i 0 Then varResponse = MsgBox("I found " & i & " attached files." _ & vbCrLf & "I have saved them into the \\iodine.euston.uk.ssp\groupshare\Finance\AIR FINANCE\Financial Analyst\AIR REPORTS\Flash\Air Flash Recieved\." _ & vbCrLf & vbCrLf & "Would you like to view the files now?" _ , vbQuestion + vbYesNo, "Finished!") ' Open Windows Explorer to display saved files if user chooses If varResponse = vbYes Then Shell "Explorer.exe /e,\\iodine.euston.uk.ssp\groupshare\Finance\AIR FINANCE\Financial Analyst\AIR REPORTS\Flash\Air Flash Recieved\", vbNormalFocus End If Else MsgBox "I didn't find any attached files in your mail.", vbInformation, "Finished!" End If ' Clear memory SaveAttachmentsToFolder_exit: Set Atmt = Nothing Set Item = Nothing Set ns = Nothing Exit Sub ' Handle Errors SaveAttachmentsToFolder_err: MsgBox "An unexpected error has occurred." _ & vbCrLf & "Please note and report the following information." _ & vbCrLf & "Macro Name: GetAttachments" _ & vbCrLf & "Error Number: " & Err.Number _ & vbCrLf & "Error Description: " & Err.Description _ , vbCritical, "Error!" Resume SaveAttachmentsToFolder_exit End Sub the error line is the |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook Login Issues / Possible Password Authentication Issues | D|an-0 | Outlook - General Queries | 0 | December 21st 07 02:22 AM |
issues receiving email | bchirikas | Outlook Express | 5 | October 22nd 07 12:51 PM |
Issues with getting the Sender Name in email | [email protected] | Add-ins for Outlook | 6 | October 15th 07 11:12 PM |
2 simple macros - create task from email and move email to folder | [email protected] | Outlook and VBA | 5 | February 4th 07 09:57 AM |
Is this a bug? attach email in another email issues | matchbox | Outlook - General Queries | 0 | May 3rd 06 08:53 AM |