I am trying to use VBA to download an outlook attachment(csv file) with “RICHARDSON” in
The attachment name, and save it to C:\current_data\RICHARDSON.CSV.
I have this coding but I get user-defined type not defined.
Public Sub saveAttachtoDisk(itm As Outlook.MailItem) Dim attach As Outlook.Attachment Dim saveFolder As String Case InStr(.Filename, &"*RICHARDSON*"&) .SaveAsFile (C:\current_data\*&"*RICHARDSON"&*) Case Else End Sub
Last edited by carrollm; 02-03-2022 at 02:50 PM. Reason: comply with forum rule 2
Thanks for the help. I have stopped using outlook and am using gmail. my current
situation is
I receive 8 emails with an attachment – 3 times a day, 7 days a week.
I am manually downloading the attachments to a local drive – doing the following:
1) Open email (cmayhew@gmail.com)
2) Right click on attachment
3) Left click on “save link as” (c:\abcurrentdata\
4) Left click on “save”
5) Open next email and repeat above for 7 more emails
I have been unsuccessful in finding a VBA routine that will automate this process.
I have tried several, with no success.
Help would be appreciated
Carroll
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks