HOWTO: Get Email Messages from Exchange to SharePoint

mhinze.com » Blog Archive » links for 2007-02-08

mhinze.com » Blog Archive » links for 2007-02-08 — Mon, 19 Feb 2007 17:03:22 GMT

PingBack from http://mhinze.com/links-for-2007-02-08/

re: HOWTO: Get Email Messages from Exchange to SharePoint

scoleman — Mon, 05 Mar 2007 21:39:38 GMT

Currently I can recieve but in eml format, will this fix so I recieve as email to open in my outlook client as a regular email. I need to have this work, we are intergrating the document library to our exchange 2007. I was told I needed a mapi client installed on the sharepoint 2007 server. But not sure if any special configuration is involved. Any help would be great.

re: HOWTO: Get Email Messages from Exchange to SharePoint

... — Mon, 12 Mar 2007 13:03:53 GMT

mmm.. nice design, I must say..

re: HOWTO: Get Email Messages from Exchange to SharePoint

Patrick Creehan — Tue, 13 Mar 2007 20:14:07 GMT

So the reason you need a MAPI client is that Outlook is a MAPI client and reads MAPI data from a MAPI store. MSG is the file format for MAPI data. These types of files would open in Outlook. It would involve a completely different code path to get the MAPI data from the store and save it as MSG. You can use MAPI Editor's source code available from this KB article (http://support.microsoft.com/kb/291794/) to do so. However, please note that MAPI code is not supported inline with .NET code. You would have to do this in C++ unmanaged code and wrap it in a COM+ component that you could call into from .NET. Outlook Object Model can also save messages as MSG files, but be careful again because Outlooks OMG (Object Model Guard) can prompt you with security prompts. Once you save the msg file to the disk, you can use the same UploadToSPS code I have above to push it into SharePoint. The reason I went after the EML (MIME content) files is that WebDAV is supported under .NET.

re: HOWTO: Get Email Messages from Exchange to SharePoint

Nick — Tue, 20 Mar 2007 18:00:32 GMT

We implement a VERY similar technique, although we found you have to loop read the bytes as on larger emails stuff gets lost/truncated. See my blog entry for what I mean.

http://nickwhite.spaces.live.com/blog/

re: HOWTO: Get Email Messages from Exchange to SharePoint

Nick — Tue, 20 Mar 2007 18:31:23 GMT

You will find you'll need to read the email stream in chunks to avoid loosing stuff and ending up with a truncated email (especially true when there are attachments, my blog has code for our very similar implementation.

re: HOWTO: Get Email Messages from Exchange to SharePoint

Pritam — Mon, 02 Apr 2007 23:05:26 GMT

Hi Patrick,

Good article.

What I am trying to do is write an event handler for an email enabled document library. So, when my document library receives the eml file, I want to open the file and find out who the sender is, the subject, cc fields, body and what the attachments are. Do you know of any way to parse eml files through code?

Thanks

-pritam

re: HOWTO: Get Email Messages from Exchange to SharePoint

Patrick Creehan — Tue, 17 Apr 2007 16:21:10 GMT

Hi Pritam. Yes, CDOSYS is an effective API for parsing eml files.

http://msdn2.microsoft.com/en-us/library/ms527302.aspx

re: HOWTO: Get Email Messages from Exchange to SharePoint

DLS — Thu, 20 Sep 2007 06:46:14 GMT

I'm new to webDAV. How would you use this in a project?

re: HOWTO: Get Email Messages from Exchange to SharePoint

Saharathendral — Fri, 20 Mar 2009 07:51:15 GMT

Hi Patrick Creehan,

I am also working in SharePoint 2007. I am facing some problem with images while sending it thru mail. Our problem is, we are sending Emails (watch word - with image) to end users on daily basis. Currently we are doing it manually. Now we need to automate this using SharePoint designer work flow. The problem is background images are not displayed while getting the emails in outlook. There is no problem with the text. We are in hot stove now. Could you please help me to solve this?

Thanks.

Saharathendral

re: HOWTO: Get Email Messages from Exchange to SharePoint

Patrick Creehan — Wed, 25 Mar 2009 17:26:35 GMT

Hi Saharathendral,

Are you getting the red X where your image should be or are you just seeing a plain text email?

If you are seeing the red X, then it is most likely that your images are stored in a location that requires authentication to access. You should put them somewhere they can be accessed anonymously. You'll also want to look at these articles:

http://msdn.microsoft.com/en-us/library/aa338201.aspx

http://msdn.microsoft.com/en-us/library/aa338200.aspx

In Outlook 2003, there was an entirely different security mechanism in Tools/Options that governed how and if images were displayed in HTML emails.

Patrick

re: HOWTO: Get Email Messages from Exchange to SharePoint

Saharathendral — Wed, 01 Apr 2009 14:02:22 GMT

Hi Patrick,

your reply helps us a lot to solve our problem. Thanks a lot. ;-)

Saharathendral

re: HOWTO: Get Email Messages from Exchange to SharePoint

Antti — Fri, 17 Apr 2009 09:00:13 GMT

Hi Patrick!

I'm not sure whether this is a good place to ask about this, so sorry if not, but here goes anyway.

We have a "company-general" email address, that actually goes to just one person's mailbox. Currently the person then forwards the messages to whoever he guesses the message concerns. We would like to have the messages sent to this address be somehow automatically moved to a place in Sharepoint where other people could see them if they like and put alerts to get notification etc. Ideally this place could be a Sharepoint discussion forum so that the messages could be seen similar to as in an email reader.

We could of course just forward the mails coming to the address to all those who want to receive them, but then the decision of whether to receive them or not would be more of an on-off decision, all or nothing. If the messages (even only text body would be enough) would automatically appear on a Sharepoint page, then the people could check them when they want (for example when they expect something concerning them to be inbound) and then ignore them in other times.

Finally, in our location we don't have the Sharepoint server, it is managed by IT in another location so it would be best if something like this could be done without any actual extra coding, just utilizing existing features, adding a suitable web part or something similar. Do you think anything like this would be reasonably easily doable?

-Antti

re: HOWTO: Get Email Messages from Exchange to SharePoint

Roopesh — Thu, 23 Apr 2009 20:26:41 GMT

I am getting the remote server returned an error 403 forbidden after it reach this line

// Send the SEARCH method request and get the

// response from the server.

Response = (HttpWebResponse)Request.GetResponse();

re: HOWTO: Get Email Messages from Exchange to SharePoint

Roopesh Das — Fri, 24 Apr 2009 06:20:32 GMT

I am getting a 403 error here on this line

// Get a reference to the request stream.

RequestStream = Request.GetRequestStream();

I have a https URI web email access

string strRootURI = "https://webmail.hhs.gov/exchweb/bin/auth/owalogon.asp?url=https://webmail.hhs.gov/exchange&reason=0";

string strSPSRootURI = "http://samhsa-dmsg:48497/Email%20Import/";

re: HOWTO: Get Email Messages from Exchange to SharePoint

Patrick Creehan — Wed, 22 Jul 2009 16:19:00 GMT

Hi Roopesh,

It looks like your value for strRootURI is incorrect - it should be directed at the mailbox you intend to log on to - not the logon page for owa. There are strategies you can employ to get the auth cookie from OWA and include it in your requests (http://support.microsoft.com/kb/891748/), but my sample above assumes OWA is configured for Basic or Windows authentication, not Forms Based Authentication.

re: HOWTO: Get Email Messages from Exchange to SharePoint

SharePoint — Wed, 29 Jul 2009 06:37:45 GMT

I got a hold of Exchange email body (in html) through Exchange Impersonation. How do I convert it to plain text?

re: HOWTO: Get Email Messages from Exchange to SharePoint

Patrick Creehan — Fri, 28 Aug 2009 22:04:19 GMT

How did you get the html? (There may be a similar way to get the plain text.)

re: HOWTO: Get Email Messages from Exchange to SharePoint

sema — Wed, 21 Oct 2009 22:40:34 GMT

just use discussion board as a library which creates a body field so you don't need to worry about reading eml file body.