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

Posted on 2011-10-14
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

    Author Comment

    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

    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

    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

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
    Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now