INTELLIGENT WORK FORUMS FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a Computer / IT professional? Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)
Feedback
"...A lot of the information I've found at this site would've taken me forever if I'd have attempted to research it on my own. Thanks again."
Geography
Where in the world do Tek-Tips members come from?
|
VBA Visual Basic for Applications (Microsoft) FAQ
|
Outlook VBA
|
How do i go through a folder in outlook and save the attachments ?
Posted: 10 Aug 04
|
CODEFunction funGetEmailData(strFolder As String) 'strfolder is the name of the folder you want to look in 'dont forget to refernce oulook libaray if using in another 'app. Dim olOutlook As Outlook.Application Dim ns As Outlook.NameSpace Dim fld As Outlook.MAPIFolder Dim itm As Object Dim MyMail As Outlook.MailItem Dim int_cnt As Integer '-----------
On Error Resume Next
Set olOutlook = CreateObject("Outlook.Application") Set ns = olOutlook.GetNamespace("MAPI") Set itm = ns.GetDefaultFolder(olFolderInbox) Set itm = itm.Folders(strFolder)
int_cnt = 1 For Each MyMail In itm.Items
MyMail.Attachments.Item(1).SaveAsFile "H:\Temp " & int_cnt & " "
int_cnt = int_cnt + 1
Next
For Each MyMail In itm.Items MyMail.Delete Next
Set olOutlook = Nothing Set ns = Nothing Set itms = Nothing Set MyMail = Nothing
End Function
|
Back to VBA Visual Basic for Applications (Microsoft) FAQ Index
Back to VBA Visual Basic for Applications (Microsoft) Forum |
|
 |
|
Join Tek-Tips® Today!
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Talk To Other Members
- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close