Macro for Outlook 2010 to MOVE/PRINT email to Sharepoint folder?

Posted on 2011-10-14
Medium Priority
Last Modified: 2012-05-12
I have an Outlook 2010 user on Windows 7 (hosted Exchange server) and an internal Sharepoint site on the network (mapped to Z:). I have a macro in Outlook 2010 that says that if "An email from JOHN comes with an ATTACHMENT to move those attachments to a Z: on the Sharepoint server". This macro works but I would like to create an additional rule to take that email (.EML) and move it to Sharepoint drive as well so that it can be read by sharepoint users.

What is the best way to do this? Some ideas: rule to auto-forward > email to folder OR auto convert to pdf > to folder? Not sure but please suggest :)
Question by:XAnalyzer
  • 2

Author Comment

ID: 36969512
FYI- I linked my Sharepoint to my Outlook and it now shows up under "Sharepoint Lists" but it says THIS SHAREPOINT LIST IS READ-ONLY IN OUTLOOK. So I can't save anything to the folder from Outlook?!
LVL 47

Accepted Solution

apache09 earned 2000 total points
ID: 36977646
You could use the following code to save copies of Emails to a folder on the local drive

Then just create a bat to copy these file over to the Sharepoint Server location

You can then add the bat file to scheduled tasks

Author Comment

ID: 36997413
I currently have a macro in outlook that takes any incoming emails and saves the attachments ONLY to the share point folder. Two questions-
1. for this vba, can i just copy and paste under my first macro in VBA editor, and both macros will take place (first save the attachment if any, and second save email)

2. why can't i just save copies of emails to the shared share point folder? currently, my share point intranet displays all files within that shared folder

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question