Cannot send out Excel workbook through Outlook Express

A

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 "(e-mail address removed)", _
"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
 
R

Ron de Bruin

Hi Abel

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

Sub Mail_workbook_1()
ActiveWorkbook.SendMail "(e-mail address removed)", _
"This is the Subject line"
End Sub
 
A

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
 
A

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.aspx?scid=kb;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.aspx?scid=kb;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
 
P

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.
 
R

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 said:
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.aspx?scid=kb;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.aspx?scid=kb;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 said:
 
A

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 said:
*** 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 said:
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.aspx?scid=kb;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.aspx?scid=kb;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 said:
See
http://www.rondebruin.nl/mail/problems.htm



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



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

:

Hi Abel

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

Sub Mail_workbook_1()
ActiveWorkbook.SendMail "(e-mail address removed)", _
"This is the Subject line"
End Sub



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



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 "(e-mail address removed)", _
"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
 
R

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 said:
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 said:
*** 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 said:
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.aspx?scid=kb;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.aspx?scid=kb;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




:

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



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



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

:

Hi Abel

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

Sub Mail_workbook_1()
ActiveWorkbook.SendMail "(e-mail address removed)", _
"This is the Subject line"
End Sub



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



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 "(e-mail address removed)", _
"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
 
P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top