Get XML file from email attachement to variable

Question

So, I want to be able to get an XML file attachment from an email and store it in the database for later use.

I can retrieve the emails and store the SenderEmailAdress, sentOn and the body in the database. Now I want to add the XML file attachment to the database too, so I can use it later.

How can I get the attachment file (or the content) from the email and to a variable so I can add it to the DB?

Here's the code for the attachment I have now (so after I get the Mail Item):

//Check for attachments.
int AttachCnt = oMsg.Attachments.Count;

// Check if there are any attachments
if (AttachCnt > 0)
{
    for (int i = 1; i <= AttachCnt; i++)
    {
        System.Diagnostics.Debug.WriteLine(i.ToString() + " - FileName: " + oMsg.Attachments[i].FileName);
        String ext = Path.GetExtension(oMsg.Attachments[i].FileName);
        // check if the file extention is .xml
        if (ext == ".xml")
        {
            // Get the file ready to store in the DB. This is what I want to know!
            return;
        }                            
    }                            
}

Dmitry Streblechenko · Accepted Answer · 2016-02-12 13:55:36Z

1

Save the attachment as a file (Attachment.SaveAsFile), then read the file data into a variable.

answered Feb 12, 2016 at 13:55

Dmitry Streblechenko

67.1k4 gold badges56 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zabi Over a year ago

msdn.microsoft.com/en-us/library/…

Collectives™ on Stack Overflow

Get XML file from email attachement to variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related