View Single Post
  #5  
Old April 8th 10, 05:34 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Save attachment if email is from joe



The VBA macro can be run only within Outlook, not on the server.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en


Am Thu, 8 Apr 2010 05:01:01 -0700 schrieb Joe:

Should i set up a specific email and on a application server so that the
account is always logged in and not dependant on someone? How do i deal

with
something like that? My comp IT dept isnt handy at all and they are on

the
other side of the planet

Thank you

"Michael Bauer [MVP - Outlook]" wrote:


You can create a rule in Outlook to run a script that might look like

this:

Public Sub SaveAtt(Mail as Outlook.MailItem)
Dim Att as Outlook.Attachment
If Mail.Attachments.Count Then
Set Att=Mail.Attachments(1)
Att.SaveAsFile "c:\" & Att.Filename
Endif
End Sub

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en


Am Wed, 7 Apr 2010 12:03:03 -0700 schrieb Joe:

I need to save an attachment to a specific network drive/folder if an

email
comes from a specific person. I know som excel vba but nothing in

access,
can u guys help me out?

Thanks!~

.

Ads