Hi All.........
Using xl2k, I made a macro using mostly Ron de Bruin's fine code to send an
email of part of an Excel sheet, (copied over into a helper workbook) in
Lotus Notes.
The macro works fine on my
work computer with Lotus Notes. It also works on my home much smaller
computer using
OE5, but does not work on the user's computer I want to give it to at work,
nor any other
computer around my area. The User's computer is essentially the same
Dell as mine,
only a little faster, and with the same 1GB RAM......the rest of the program
works fine on
his computer, just the sendmail command don't work

I get the error msg of "Run time error 1004 Method 'sendmail' of object
'_Workbook' failed.

I tried both
Application.sendmail EmailAddy, "mytest3 from Mike"
and
Application.Dialogs(xlDialogSendMail).Show EmailAddy, "mytest3 from Mike"

same results with both.........works on mine, don't on his.....

Our computers at work are burdened down with EXTREME controls by the MIS
dept.....some
more than others. Could there be some sort of setting that may be different
on the various
computers that would demonstrate this situation?

Any help would be much appreciated.

Vaya con Dios,
Chuck, CABGx3

See
http://www.rondebruin.nl/mail/problems.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CLR" wrote in message ...
Hi All.........
Using xl2k, I made a macro using mostly Ron de Bruin's fine code to send an
email of part of an Excel sheet, (copied over into a helper workbook) in
Lotus Notes.
The macro works fine on my
work computer with Lotus Notes. It also works on my home much smaller
computer using
OE5, but does not work on the user's computer I want to give it to at work,
nor any other
computer around my area. The User's computer is essentially the same
Dell as mine,
only a little faster, and with the same 1GB RAM......the rest of the program
works fine on
his computer, just the sendmail command don't work

I get the error msg of "Run time error 1004 Method 'sendmail' of object
'_Workbook' failed.

I tried both
Application.sendmail EmailAddy, "mytest3 from Mike"
and
Application.Dialogs(xlDialogSendMail).Show EmailAddy, "mytest3 from Mike"

same results with both.........works on mine, don't on his.....

Our computers at work are burdened down with EXTREME controls by the MIS
dept.....some
more than others. Could there be some sort of setting that may be different
on the various
computers that would demonstrate this situation?

Any help would be much appreciated.

Vaya con Dios,
Chuck, CABGx3

Thanks Ron.....
I'm hopeing it's the MAPIX=1 thing......I can't do a Start Run myself,
have to wait for MIS to get off their duff and grace us with their presence.
It's correct on my home computer and the code works on it.
Or maybe, I can just search for Win.ini at work and check it that
way.........I'll look tomorrow when I get to work.

Thanks again,
Vaya con Dios,
Chuck, CABGx3



"Ron de Bruin" wrote in message
...
See
http://www.rondebruin.nl/mail/problems.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CLR" wrote in message
...
Hi All.........
Using xl2k, I made a macro using mostly Ron de Bruin's fine code to
send an
email of part of an Excel sheet, (copied over into a helper workbook) in
Lotus Notes.
The macro works fine on my
work computer with Lotus Notes. It also works on my home much smaller
computer using
OE5, but does not work on the user's computer I want to give it to at
work,
nor any other
computer around my area. The User's computer is essentially the same
Dell as mine,
only a little faster, and with the same 1GB RAM......the rest of the
program
works fine on
his computer, just the sendmail command don't work

I get the error msg of "Run time error 1004 Method 'sendmail' of
object
'_Workbook' failed.

I tried both
Application.sendmail EmailAddy, "mytest3 from Mike"
and
Application.Dialogs(xlDialogSendMail).Show EmailAddy, "mytest3 from
Mike"

same results with both.........works on mine, don't on his.....

Our computers at work are burdened down with EXTREME controls by the MIS
dept.....some
more than others. Could there be some sort of setting that may be
different
on the various
computers that would demonstrate this situation?

Any help would be much appreciated.

Vaya con Dios,
Chuck, CABGx3

That did the trick Ron..........many many thanks. By doing a search for the
Win.ini file and then editiing it, it started working........I can now send
Batch emails fromExcel, through Lotus Notes using your code.........

Thanks again,
Vaya con Dios,
Chuck, CABGx3



"CLR" wrote in message
...
Thanks Ron.....
I'm hopeing it's the MAPIX=1 thing......I can't do a Start Run myself,
have to wait for MIS to get off their duff and grace us with their
presence.
It's correct on my home computer and the code works on it.
Or maybe, I can just search for Win.ini at work and check it that
way.........I'll look tomorrow when I get to work.

Thanks again,
Vaya con Dios,
Chuck, CABGx3



"Ron de Bruin" wrote in message
...
See
http://www.rondebruin.nl/mail/problems.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CLR" wrote in message
...
Hi All.........
Using xl2k, I made a macro using mostly Ron de Bruin's fine code to
send an
email of part of an Excel sheet, (copied over into a helper workbook)
in
Lotus Notes.
The macro works fine on my
work computer with Lotus Notes. It also works on my home much
smaller
computer using
OE5, but does not work on the user's computer I want to give it to at
work,
nor any other
computer around my area. The User's computer is essentially the
same
Dell as mine,
only a little faster, and with the same 1GB RAM......the rest of the
program
works fine on
his computer, just the sendmail command don't work

I get the error msg of "Run time error 1004 Method 'sendmail' of
object
'_Workbook' failed.

I tried both
Application.sendmail EmailAddy, "mytest3 from Mike"
and
Application.Dialogs(xlDialogSendMail).Show EmailAddy, "mytest3 from
Mike"

same results with both.........works on mine, don't on his.....

Our computers at work are burdened down with EXTREME controls by the
MIS
dept.....some
more than others. Could there be some sort of setting that may be
different
on the various
computers that would demonstrate this situation?

Any help would be much appreciated.

Vaya con Dios,
Chuck, CABGx3

Great, thanks for the feedback

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CLR" wrote in message ...
That did the trick Ron..........many many thanks. By doing a search for the
Win.ini file and then editiing it, it started working........I can now send
Batch emails fromExcel, through Lotus Notes using your code.........

Thanks again,
Vaya con Dios,
Chuck, CABGx3



"CLR" wrote in message
...
Thanks Ron.....
I'm hopeing it's the MAPIX=1 thing......I can't do a Start Run myself,
have to wait for MIS to get off their duff and grace us with their
presence.
It's correct on my home computer and the code works on it.
Or maybe, I can just search for Win.ini at work and check it that
way.........I'll look tomorrow when I get to work.

Thanks again,
Vaya con Dios,
Chuck, CABGx3



"Ron de Bruin" wrote in message
...
See
http://www.rondebruin.nl/mail/problems.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CLR" wrote in message
...
Hi All.........
Using xl2k, I made a macro using mostly Ron de Bruin's fine code to
send an
email of part of an Excel sheet, (copied over into a helper workbook)
in
Lotus Notes.
The macro works fine on my
work computer with Lotus Notes. It also works on my home much
smaller
computer using
OE5, but does not work on the user's computer I want to give it to at
work,
nor any other
computer around my area. The User's computer is essentially the
same
Dell as mine,
only a little faster, and with the same 1GB RAM......the rest of the
program
works fine on
his computer, just the sendmail command don't work

I get the error msg of "Run time error 1004 Method 'sendmail' of
object
'_Workbook' failed.

I tried both
Application.sendmail EmailAddy, "mytest3 from Mike"
and
Application.Dialogs(xlDialogSendMail).Show EmailAddy, "mytest3 from
Mike"

same results with both.........works on mine, don't on his.....

Our computers at work are burdened down with EXTREME controls by the
MIS
dept.....some
more than others. Could there be some sort of setting that may be
different
on the various
computers that would demonstrate this situation?

Any help would be much appreciated.

Vaya con Dios,
Chuck, CABGx3