Mail Attachment error

[JontyMC]

I'm dynamically creating an Excel file using ODBC (server doesn't have Excel installed). This works fine. The problem comes when I try to email it. I set up a basic email which works fine:

MailMessage m = new MailMessage();
m.From = aParams["emailFrom"];
m.To = aParams["emailTo"];
m.Subject = "Subject";
m.Body = body;
m.BodyFormat = MailFormat.Text;

SmtpMail.Send(m);

Now I add the attachment:

MailMessage m = new MailMessage();
m.From = aParams["emailFrom"];
m.To = aParams["emailTo"];
m.Subject = "Subject";
m.Body = body;
m.BodyFormat = MailFormat.Text;

MailAttachment xls = new MailAttachment(fileName); 
m.Attachments.Add(xls);

SmtpMail.Send(m);

And it breaks. I get this error:

Exception occurred:Could not access 'CDO.Message' object.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x800C000D): The specified protocol is unknown.

   --- End of inner exception stack trace ---
   at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
   at System.RuntimeType.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParameters)
   at System.Web.Mail.LateBoundAccessHelper.CallMethod(Object obj, String methodName, Object[] args)
The specified protocol is unknown.

Any ideas?

Jon

"I don't regret this, but I both rue and lament it.

 

[ca8msm]

Exception occurred:Could not access 'CDO.Message' object

That seems to suggest that the mail message is failing (not necessarily because there is an attachment). Can you send the message if you don't include the attachment?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[JontyMC]

Yes, without these 2 lines it works fine:

MailAttachment xls = new MailAttachment(fileName); 
m.Attachments.Add(xls);

Jon

"I don't regret this, but I both rue and lament it.

 

[ca8msm]

Try putting a Try/Catch statement around the code and read the InnerException message (it may be further down the exception tree so trace though all of the inner exceptions) as I suspect the reall error will be masked.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[ca8msm]

Oh, and if the inner exception turns out to be a permissions issue, check out this link:

http://www.systemwebmail.com/faq/4.2.8.aspx

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.