Cannot send out Excel workbook through Outlook Express

[Abel Chan]

Hi all,

I was trying to send out an excel workbook through Outlook Express.

I looked at http://www.rondebruin.nl/ and have:
Workbooks.Application.ActiveWorkbook.SendMail "[email protected]", _
"This is a test"
In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
failed"

I checked my Internet Option | Program and it has Outlook Express as the
default Email.

Any idea why?

Thanks so much.

Abel Chan

[Ron de Bruin]

Hi Abel

Your code is not the same as the Example on my site

Sub Mail_workbook_1()
ActiveWorkbook.SendMail "[email protected]", _
"This is the Subject line"
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Abel Chan" <[email protected]> wrote in message news:[email protected]...
> Hi all,
>
> I was trying to send out an excel workbook through Outlook Express.
>
> I looked at http://www.rondebruin.nl/ and have:
> Workbooks.Application.ActiveWorkbook.SendMail "[email protected]", _
> "This is a test"
> In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
> failed"
>
> I checked my Internet Option | Program and it has Outlook Express as the
> default Email.
>
> Any idea why?
>
> Thanks so much.
>
> Abel Chan
>

[Abel Chan]

Hi Ron,

Thanks to your quick reply. I used your code and got error 1004
Application-defined or object-defined error. Somehow Excel was unable to
find Outlook Express.

On the other hand, I was able to use your code at:
http://www.rondebruin.nl/mail/oebody.htm to bring up a dialog box and send
out a test email.

I also tried the Outlook object code and got similar error:
Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject

Thanks so much Ron.

Abel

"Ron de Bruin" wrote:

> Hi Abel
>
> Your code is not the same as the Example on my site
>
> Sub Mail_workbook_1()
> ActiveWorkbook.SendMail "[email protected]", _
> "This is the Subject line"
> End Sub
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
> > Hi all,
> >
> > I was trying to send out an excel workbook through Outlook Express.
> >
> > I looked at http://www.rondebruin.nl/ and have:
> > Workbooks.Application.ActiveWorkbook.SendMail "[email protected]", _
> > "This is a test"
> > In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
> > failed"
> >
> > I checked my Internet Option | Program and it has Outlook Express as the
> > default Email.
> >
> > Any idea why?
> >
> > Thanks so much.
> >
> > Abel Chan
> >
>
>
>

[Ron de Bruin]

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



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Abel Chan" <[email protected]> wrote in message news:[email protected]...
> Hi Ron,
>
> Thanks to your quick reply. I used your code and got error 1004
> Application-defined or object-defined error. Somehow Excel was unable to
> find Outlook Express.
>
> On the other hand, I was able to use your code at:
> http://www.rondebruin.nl/mail/oebody.htm to bring up a dialog box and send
> out a test email.
>
> I also tried the Outlook object code and got similar error:
> Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject
>
> Thanks so much Ron.
>
> Abel
>
> "Ron de Bruin" wrote:
>
>> Hi Abel
>>
>> Your code is not the same as the Example on my site
>>
>> Sub Mail_workbook_1()
>> ActiveWorkbook.SendMail "[email protected]", _
>> "This is the Subject line"
>> End Sub
>>
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
>> > Hi all,
>> >
>> > I was trying to send out an excel workbook through Outlook Express.
>> >
>> > I looked at http://www.rondebruin.nl/ and have:
>> > Workbooks.Application.ActiveWorkbook.SendMail "[email protected]", _
>> > "This is a test"
>> > In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
>> > failed"
>> >
>> > I checked my Internet Option | Program and it has Outlook Express as the
>> > default Email.
>> >
>> > Any idea why?
>> >
>> > Thanks so much.
>> >
>> > Abel Chan
>> >
>>
>>
>>

[Abel Chan]

1)
Check out if Outlook or Outlook Express is your mail program for Office
Start>Settings>Control Panel....Internet options (Program Tab)
Close Excel first before you make a change.

*** Outlook Express is the mail program. No change needs to make.

2)
XL2002: "Send To Routing Recipient" Command Does Nothing
http://support.microsoft.com/default...b;en-us;296396

*** We are not using routing. Not appliable.

Note : If you use a other language version then English
The MAPIX=1 can be in the section [Correo] for example and not in the [Mail]
section.
This is a example for a Spanish version (Correo = Mail in Spanish).

*** Language is English. Not appliable

3)
Error <Excel could not start the E-mail program>
http://support.microsoft.com/default...b;en-us;828509

*** I can go to Excel | File | Send To | Mail Recipients to bring up the
email dialog box. So this is not an issue.

If you want to send the selection in the body of the mail in Excel 2000 or
2002.
(File>Send To...Mail recipient or use the E-Mail button on the Standard
toolbar)
And have Outlook 2003 as your default mail program then
Excel will tell you this <Excel could not start the E-mail program>

***We are using Excel 2000/XP and Outlook Express 6.

The Outlook version and the Office version must be the same to send
in the body of the mail.

4)
Because there is a bug in Outlook it is possible that you must uncheck
"send immediately when connect" in the Outlook options.
Tools>Options>Mail Setup in the Outlook menu.
In Outlook 2000 Tools>Options>Mail Delivery

*** We are using Outlook Express.

Problem: It will not close the Outlook process after the mail is sent in the
Task Manager


5)
Search in the MS Knowledge Base for solutions of other problems (Click here)

***None of them target Outlook Express. If my client has Outlook, I can use
Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject.
To bad...

Thanks.

Abel Chan




"Ron de Bruin" wrote:

> See
> http://www.rondebruin.nl/mail/problems.htm
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
> > Hi Ron,
> >
> > Thanks to your quick reply. I used your code and got error 1004
> > Application-defined or object-defined error. Somehow Excel was unable to
> > find Outlook Express.
> >
> > On the other hand, I was able to use your code at:
> > http://www.rondebruin.nl/mail/oebody.htm to bring up a dialog box and send
> > out a test email.
> >
> > I also tried the Outlook object code and got similar error:
> > Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject
> >
> > Thanks so much Ron.
> >
> > Abel
> >
> > "Ron de Bruin" wrote:
> >
> >> Hi Abel
> >>
> >> Your code is not the same as the Example on my site
> >>
> >> Sub Mail_workbook_1()
> >> ActiveWorkbook.SendMail "[email protected]", _
> >> "This is the Subject line"
> >> End Sub
> >>
> >>
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >>
> >> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
> >> > Hi all,
> >> >
> >> > I was trying to send out an excel workbook through Outlook Express.
> >> >
> >> > I looked at http://www.rondebruin.nl/ and have:
> >> > Workbooks.Application.ActiveWorkbook.SendMail "[email protected]", _
> >> > "This is a test"
> >> > In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
> >> > failed"
> >> >
> >> > I checked my Internet Option | Program and it has Outlook Express as the
> >> > default Email.
> >> >
> >> > Any idea why?
> >> >
> >> > Thanks so much.
> >> >
> >> > Abel Chan
> >> >
> >>
> >>
> >>
>
>
>

[Peter Huang [MSFT]]

Hi,

Currently I am researching the issue and we will reply here with more
information as soon as possible.
If you have any more concerns on it, please feel free to post here.

Thanks for your understanding!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

[Ron de Bruin]

>*** We are not using routing. Not appliable.
Header is not very good in this KB
Check out your win.ini file


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Abel Chan" <[email protected]> wrote in message news:[email protected]...
> 1)
> Check out if Outlook or Outlook Express is your mail program for Office
> Start>Settings>Control Panel....Internet options (Program Tab)
> Close Excel first before you make a change.
>
> *** Outlook Express is the mail program. No change needs to make.
>
> 2)
> XL2002: "Send To Routing Recipient" Command Does Nothing
> http://support.microsoft.com/default...b;en-us;296396
>
> *** We are not using routing. Not appliable.
>
> Note : If you use a other language version then English
> The MAPIX=1 can be in the section [Correo] for example and not in the [Mail]
> section.
> This is a example for a Spanish version (Correo = Mail in Spanish).
>
> *** Language is English. Not appliable
>
> 3)
> Error <Excel could not start the E-mail program>
> http://support.microsoft.com/default...b;en-us;828509
>
> *** I can go to Excel | File | Send To | Mail Recipients to bring up the
> email dialog box. So this is not an issue.
>
> If you want to send the selection in the body of the mail in Excel 2000 or
> 2002.
> (File>Send To...Mail recipient or use the E-Mail button on the Standard
> toolbar)
> And have Outlook 2003 as your default mail program then
> Excel will tell you this <Excel could not start the E-mail program>
>
> ***We are using Excel 2000/XP and Outlook Express 6.
>
> The Outlook version and the Office version must be the same to send
> in the body of the mail.
>
> 4)
> Because there is a bug in Outlook it is possible that you must uncheck
> "send immediately when connect" in the Outlook options.
> Tools>Options>Mail Setup in the Outlook menu.
> In Outlook 2000 Tools>Options>Mail Delivery
>
> *** We are using Outlook Express.
>
> Problem: It will not close the Outlook process after the mail is sent in the
> Task Manager
>
>
> 5)
> Search in the MS Knowledge Base for solutions of other problems (Click here)
>
> ***None of them target Outlook Express. If my client has Outlook, I can use
> Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject.
> To bad...
>
> Thanks.
>
> Abel Chan
>
>
>
>
> "Ron de Bruin" wrote:
>
>> See
>> http://www.rondebruin.nl/mail/problems.htm
>>
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
>> > Hi Ron,
>> >
>> > Thanks to your quick reply. I used your code and got error 1004
>> > Application-defined or object-defined error. Somehow Excel was unable to
>> > find Outlook Express.
>> >
>> > On the other hand, I was able to use your code at:
>> > http://www.rondebruin.nl/mail/oebody.htm to bring up a dialog box and send
>> > out a test email.
>> >
>> > I also tried the Outlook object code and got similar error:
>> > Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject
>> >
>> > Thanks so much Ron.
>> >
>> > Abel
>> >
>> > "Ron de Bruin" wrote:
>> >
>> >> Hi Abel
>> >>
>> >> Your code is not the same as the Example on my site
>> >>
>> >> Sub Mail_workbook_1()
>> >> ActiveWorkbook.SendMail "[email protected]", _
>> >> "This is the Subject line"
>> >> End Sub
>> >>
>> >>
>> >>
>> >> --
>> >> Regards Ron de Bruin
>> >> http://www.rondebruin.nl
>> >>
>> >>
>> >>
>> >> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
>> >> > Hi all,
>> >> >
>> >> > I was trying to send out an excel workbook through Outlook Express.
>> >> >
>> >> > I looked at http://www.rondebruin.nl/ and have:
>> >> > Workbooks.Application.ActiveWorkbook.SendMail "[email protected]", _
>> >> > "This is a test"
>> >> > In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
>> >> > failed"
>> >> >
>> >> > I checked my Internet Option | Program and it has Outlook Express as the
>> >> > default Email.
>> >> >
>> >> > Any idea why?
>> >> >
>> >> > Thanks so much.
>> >> >
>> >> > Abel Chan
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

[Abel Chan]

I checked out the win.ini file and I don't find a [Mail] section.

Should I create one? What else do I need to add after [Mail].

Thanks.

Abel Chan

"Ron de Bruin" wrote:

> >*** We are not using routing. Not appliable.
> Header is not very good in this KB
> Check out your win.ini file
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
> > 1)
> > Check out if Outlook or Outlook Express is your mail program for Office
> > Start>Settings>Control Panel....Internet options (Program Tab)
> > Close Excel first before you make a change.
> >
> > *** Outlook Express is the mail program. No change needs to make.
> >
> > 2)
> > XL2002: "Send To Routing Recipient" Command Does Nothing
> > http://support.microsoft.com/default...b;en-us;296396
> >
> > *** We are not using routing. Not appliable.
> >
> > Note : If you use a other language version then English
> > The MAPIX=1 can be in the section [Correo] for example and not in the [Mail]
> > section.
> > This is a example for a Spanish version (Correo = Mail in Spanish).
> >
> > *** Language is English. Not appliable
> >
> > 3)
> > Error <Excel could not start the E-mail program>
> > http://support.microsoft.com/default...b;en-us;828509
> >
> > *** I can go to Excel | File | Send To | Mail Recipients to bring up the
> > email dialog box. So this is not an issue.
> >
> > If you want to send the selection in the body of the mail in Excel 2000 or
> > 2002.
> > (File>Send To...Mail recipient or use the E-Mail button on the Standard
> > toolbar)
> > And have Outlook 2003 as your default mail program then
> > Excel will tell you this <Excel could not start the E-mail program>
> >
> > ***We are using Excel 2000/XP and Outlook Express 6.
> >
> > The Outlook version and the Office version must be the same to send
> > in the body of the mail.
> >
> > 4)
> > Because there is a bug in Outlook it is possible that you must uncheck
> > "send immediately when connect" in the Outlook options.
> > Tools>Options>Mail Setup in the Outlook menu.
> > In Outlook 2000 Tools>Options>Mail Delivery
> >
> > *** We are using Outlook Express.
> >
> > Problem: It will not close the Outlook process after the mail is sent in the
> > Task Manager
> >
> >
> > 5)
> > Search in the MS Knowledge Base for solutions of other problems (Click here)
> >
> > ***None of them target Outlook Express. If my client has Outlook, I can use
> > Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject.
> > To bad...
> >
> > Thanks.
> >
> > Abel Chan
> >
> >
> >
> >
> > "Ron de Bruin" wrote:
> >
> >> See
> >> http://www.rondebruin.nl/mail/problems.htm
> >>
> >>
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >>
> >> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
> >> > Hi Ron,
> >> >
> >> > Thanks to your quick reply. I used your code and got error 1004
> >> > Application-defined or object-defined error. Somehow Excel was unable to
> >> > find Outlook Express.
> >> >
> >> > On the other hand, I was able to use your code at:
> >> > http://www.rondebruin.nl/mail/oebody.htm to bring up a dialog box and send
> >> > out a test email.
> >> >
> >> > I also tried the Outlook object code and got similar error:
> >> > Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject
> >> >
> >> > Thanks so much Ron.
> >> >
> >> > Abel
> >> >
> >> > "Ron de Bruin" wrote:
> >> >
> >> >> Hi Abel
> >> >>
> >> >> Your code is not the same as the Example on my site
> >> >>
> >> >> Sub Mail_workbook_1()
> >> >> ActiveWorkbook.SendMail "[email protected]", _
> >> >> "This is the Subject line"
> >> >> End Sub
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >> Regards Ron de Bruin
> >> >> http://www.rondebruin.nl
> >> >>
> >> >>
> >> >>
> >> >> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
> >> >> > Hi all,
> >> >> >
> >> >> > I was trying to send out an excel workbook through Outlook Express.
> >> >> >
> >> >> > I looked at http://www.rondebruin.nl/ and have:
> >> >> > Workbooks.Application.ActiveWorkbook.SendMail "[email protected]", _
> >> >> > "This is a test"
> >> >> > In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
> >> >> > failed"
> >> >> >
> >> >> > I checked my Internet Option | Program and it has Outlook Express as the
> >> >> > default Email.
> >> >> >
> >> >> > Any idea why?
> >> >> >
> >> >> > Thanks so much.
> >> >> >
> >> >> > Abel Chan
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

[Ron de Bruin]

Try to add this in the win.ini file

[Mail]
MAPI=1
MAPIX=1



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Abel Chan" <[email protected]> wrote in message news:[email protected]...
>I checked out the win.ini file and I don't find a [Mail] section.
>
> Should I create one? What else do I need to add after [Mail].
>
> Thanks.
>
> Abel Chan
>
> "Ron de Bruin" wrote:
>
>> >*** We are not using routing. Not appliable.
>> Header is not very good in this KB
>> Check out your win.ini file
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
>> > 1)
>> > Check out if Outlook or Outlook Express is your mail program for Office
>> > Start>Settings>Control Panel....Internet options (Program Tab)
>> > Close Excel first before you make a change.
>> >
>> > *** Outlook Express is the mail program. No change needs to make.
>> >
>> > 2)
>> > XL2002: "Send To Routing Recipient" Command Does Nothing
>> > http://support.microsoft.com/default...b;en-us;296396
>> >
>> > *** We are not using routing. Not appliable.
>> >
>> > Note : If you use a other language version then English
>> > The MAPIX=1 can be in the section [Correo] for example and not in the [Mail]
>> > section.
>> > This is a example for a Spanish version (Correo = Mail in Spanish).
>> >
>> > *** Language is English. Not appliable
>> >
>> > 3)
>> > Error <Excel could not start the E-mail program>
>> > http://support.microsoft.com/default...b;en-us;828509
>> >
>> > *** I can go to Excel | File | Send To | Mail Recipients to bring up the
>> > email dialog box. So this is not an issue.
>> >
>> > If you want to send the selection in the body of the mail in Excel 2000 or
>> > 2002.
>> > (File>Send To...Mail recipient or use the E-Mail button on the Standard
>> > toolbar)
>> > And have Outlook 2003 as your default mail program then
>> > Excel will tell you this <Excel could not start the E-mail program>
>> >
>> > ***We are using Excel 2000/XP and Outlook Express 6.
>> >
>> > The Outlook version and the Office version must be the same to send
>> > in the body of the mail.
>> >
>> > 4)
>> > Because there is a bug in Outlook it is possible that you must uncheck
>> > "send immediately when connect" in the Outlook options.
>> > Tools>Options>Mail Setup in the Outlook menu.
>> > In Outlook 2000 Tools>Options>Mail Delivery
>> >
>> > *** We are using Outlook Express.
>> >
>> > Problem: It will not close the Outlook process after the mail is sent in the
>> > Task Manager
>> >
>> >
>> > 5)
>> > Search in the MS Knowledge Base for solutions of other problems (Click here)
>> >
>> > ***None of them target Outlook Express. If my client has Outlook, I can use
>> > Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject.
>> > To bad...
>> >
>> > Thanks.
>> >
>> > Abel Chan
>> >
>> >
>> >
>> >
>> > "Ron de Bruin" wrote:
>> >
>> >> See
>> >> http://www.rondebruin.nl/mail/problems.htm
>> >>
>> >>
>> >>
>> >> --
>> >> Regards Ron de Bruin
>> >> http://www.rondebruin.nl
>> >>
>> >>
>> >>
>> >> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
>> >> > Hi Ron,
>> >> >
>> >> > Thanks to your quick reply. I used your code and got error 1004
>> >> > Application-defined or object-defined error. Somehow Excel was unable to
>> >> > find Outlook Express.
>> >> >
>> >> > On the other hand, I was able to use your code at:
>> >> > http://www.rondebruin.nl/mail/oebody.htm to bring up a dialog box and send
>> >> > out a test email.
>> >> >
>> >> > I also tried the Outlook object code and got similar error:
>> >> > Application.Dialogs(xlDialogSendMail).Show aryEmailAddress, strEmailSubject
>> >> >
>> >> > Thanks so much Ron.
>> >> >
>> >> > Abel
>> >> >
>> >> > "Ron de Bruin" wrote:
>> >> >
>> >> >> Hi Abel
>> >> >>
>> >> >> Your code is not the same as the Example on my site
>> >> >>
>> >> >> Sub Mail_workbook_1()
>> >> >> ActiveWorkbook.SendMail "[email protected]", _
>> >> >> "This is the Subject line"
>> >> >> End Sub
>> >> >>
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Regards Ron de Bruin
>> >> >> http://www.rondebruin.nl
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Abel Chan" <[email protected]> wrote in message news:[email protected]...
>> >> >> > Hi all,
>> >> >> >
>> >> >> > I was trying to send out an excel workbook through Outlook Express.
>> >> >> >
>> >> >> > I looked at http://www.rondebruin.nl/ and have:
>> >> >> > Workbooks.Application.ActiveWorkbook.SendMail "[email protected]", _
>> >> >> > "This is a test"
>> >> >> > In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
>> >> >> > failed"
>> >> >> >
>> >> >> > I checked my Internet Option | Program and it has Outlook Express as the
>> >> >> > default Email.
>> >> >> >
>> >> >> > Any idea why?
>> >> >> >
>> >> >> > Thanks so much.
>> >> >> >
>> >> >> > Abel Chan
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

[Peter Huang [MSFT]]

Hi Abel,

Have you tried Ron's suggestion?
If you still have any concern with this issue, please feel free to post
here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.