Corrupt attachments using MailMessage.Att achments.Add()

[Trond A. S. Andersen]

Hi all,

I'm working on a project in which i need to send mail
attachments in the form of Excel documents from a .NET C#
application.
I've written a class which creates the Excel document
using the automation features provided by the
Excel.Applicati on component. The Excel workbooks/documents
are stored locally before I call my SendExcelDocume nt()
method in order to attatch each document to an instance of
the System.Web.Mail .MailMessage class, and send the
message using System.Web.Mail .SmtpMail. The path of the
file representing the Excel document are stored in the
DocumentPath property of the class implementing the
SendExcelDocume nt() method, as you can see from the code
snippet below.

public void SendExcelDocume nt(string smtpServerId, string
from, string to, string subject)
{

if(this.Documen tPath.Length > 0)
{
System.IO.FileI nfo fileinfo = new
System.IO.FileI nfo(this.Docume ntPath);

if(fileinfo.Exi sts)
{
System.Web.Mail .MailMessage message = new
System.Web.Mail .MailMessage();
message.Attachm ents.Add(new
System.Web.Mail .MailAttachmen( this.DocumentPa th));
message.From = from;
message.To = to;
message.Subject = subject;

System.Web.Mail .SmtpMail.SmtpS erver =
smtpServerId;
System.Web.Mail .SmtpMail.Send( message);

}
else
{
throw new
Scandpower.NP.E xception.NPExce ption(this.Form ular + " do
not exist.");
}
}
}

The transmission of the mail massages are seemingly
running quite smoothly, but any attempt to open the Excel
attacments from MS Outlook as the messages arrive at the
receiving end, results in an Excel error message stating
that the "document is corrupt and cannot be opened". My
local version of the same file, however, can be opened by
Excel without any problems. I've also noticed that the
size of the Excel documents attatched to the mail messages
differ from the size of the the original files I've stored
locally before attaching them to mail messages. I've done
some experimenting on the overload of the
System.Web.Mail .MailMessage.At tachments.Add() method,
providing different System.Web.Mail .MailEncoding
parameters, but this effort does not seem to get my
anywhere. If any of you guys have an idea what's causing
this problem, and maybe even a suggestion for a
workaround, your advice would be highly appreciated.

Regards, Trond

[codr]

I had the same issue and it seemed to resolve itself when I qualified
the attachment with the FullName.ToStri ng() attribute of the FileInfo
object.

Since you already instantiated fileinfo, try changing:
message.Attachm ents.Add(new
System.Web.Mail .MailAttachmen( this.DocumentPa th));

to:
message.Attachm ents.Add(new
System.Web.Mail .MailAttachmen( fileinfo.FullNa me.ToString())) ;

Hope it works for you,
CoDr

Trond A. S. Andersen wrote:

Hi all,

I'm working on a project in which i need to send mail
attachments in the form of Excel documents from a .NET C#
application.
I've written a class which creates the Excel document
using the automation features provided by the
Excel.Applicati on component. The Excel workbooks/documents
are stored locally before I call my SendExcelDocume nt()
method in order to attatch each document to an instance of
the System.Web.Mail .MailMessage class, and send the
message using System.Web.Mail .SmtpMail. The path of the
file representing the Excel document are stored in the
DocumentPath property of the class implementing the
SendExcelDocume nt() method, as you can see from the code
snippet below.

public void SendExcelDocume nt(string smtpServerId, string
from, string to, string subject)
{

if(this.Documen tPath.Length > 0)
{
System.IO.FileI nfo fileinfo = new
System.IO.FileI nfo(this.Docume ntPath);

if(fileinfo.Exi sts)
{
System.Web.Mail .MailMessage message = new
System.Web.Mail .MailMessage();
message.Attachm ents.Add(new
System.Web.Mail .MailAttachmen( this.DocumentPa th));
message.From = from;
message.To = to;
message.Subject = subject;

System.Web.Mail .SmtpMail.SmtpS erver =
smtpServerId;
System.Web.Mail .SmtpMail.Send( message);

}
else
{
throw new
Scandpower.NP.E xception.NPExce ption(this.Form ular + " do
not exist.");
}
}
}

The transmission of the mail massages are seemingly
running quite smoothly, but any attempt to open the Excel
attacments from MS Outlook as the messages arrive at the
receiving end, results in an Excel error message stating
that the "document is corrupt and cannot be opened". My
local version of the same file, however, can be opened by
Excel without any problems. I've also noticed that the
size of the Excel documents attatched to the mail messages
differ from the size of the the original files I've stored
locally before attaching them to mail messages. I've done
some experimenting on the overload of the
System.Web.Mail .MailMessage.At tachments.Add() method,
providing different System.Web.Mail .MailEncoding
parameters, but this effort does not seem to get my
anywhere. If any of you guys have an idea what's causing
this problem, and maybe even a suggestion for a
workaround, your advice would be highly appreciated.

Regards, Trond