sending email when running on diff machine

[Dennis Benjamin]

Hi All

Hope this isn't a FAQ - I've looked for several hours and can't find an
answer. I've written my first VB.NET app, a ~20 line console application
that opens up an Excel document, compares the number of the last line to the
number stored in a text document, and if they're different sends an email
..It's just a tool to alert me when someone has added a request to our log. I
wrote it as a standalone app because of the ungodly mess required to allow
me to put a macro inside an Excel sheet and not have to instruct all our
users to ignore the security warning - it requires digital signing and a
keyserver and someone who understands all that.
So, my little app runs great, emails me if it ffinds a difference, but my
machine is a notebook that goes home w/ me. So I want to run this on a
desktop machine here at work. And when I try that, I get the following error
message:

Unhandled Exception: System.Web.HttpException: Could not access
'CDO.Message' ob
ject. ---> System.Reflection.TargetInvocationException: Exception has been
throw
n by the target of an invocation. --->
System.Runtime.InteropServices.COMExcepti
on (0x80040220): The "SendUsing" configuration value is invalid.

--- End of inner exception stack trace ---

From googling around there seem to be many ways to get this error, but none
that I've found are unique to running on a machine different from the one
where the code is compiled. Any suggestions? Do I have to install something
on the target machine?

Thanks for any help!
Dennis

 

[Guest]

I'm going to take a WAG...have you looked at permissions? Automated Excel
requires a valid login profile and the proper COM security settings. In this
blog post
http://krgreenlee.blogspot.com/2006/03/digipede-distributing-excel_10.html in
a section under Administration Issues: User Identity I walk you through how
to make sure the COM security settings for Excel will allow automated Excel.

Good luck,

Kim