Save attachment if email is from 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!~

Save attachment if email is from joe
 

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!~

Save attachment if email is from 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!~
.

Save attachment if email is from joe
 

I set up a rule to run a script and got a message that it is a client-only
rul and will process only when outlook is running. I used your code and put
it in a module i added in the vba ide under the moduels folder. Please see
my prior post about doing it so that it will always run

"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!~
.

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!~
.