I'm going to re-open this thread fresh...

Replaced an ailing machine with a new one. Installed fresh Windows XP
(2002) SP3 and Office 2003 SP3. Version numbers of Office apps all
match on the machine, and match everyone else's machine, all of them
ending in .8221.

When attempting to sent mail from an Excel VBA script, this line fails
on the new machine...

With ActiveSheet.MailEnvelope.Item

this exact same line, in the same workbook, works fine on every other
machine.

I have tried Windows Update and Detect and Repair, neither had any
effect.

Any ideas? I believe MailEnvelope relies on a COM object
(MSOEnvelope?) Can I check to see if this is properly installed?
Anything else I should look for?

Maury

Hi Maury

Be sure that Outlook is your default mail program
Have you check the register settings on your machine ?

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


--

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


"Maury Markowitz" wrote in message
...
I'm going to re-open this thread fresh...

Replaced an ailing machine with a new one. Installed fresh Windows XP
(2002) SP3 and Office 2003 SP3. Version numbers of Office apps all
match on the machine, and match everyone else's machine, all of them
ending in .8221.

When attempting to sent mail from an Excel VBA script, this line fails
on the new machine...

With ActiveSheet.MailEnvelope.Item

this exact same line, in the same workbook, works fine on every other
machine.

I have tried Windows Update and Detect and Repair, neither had any
effect.

Any ideas? I believe MailEnvelope relies on a COM object
(MSOEnvelope?) Can I check to see if this is properly installed?
Anything else I should look for?

Maury

Be sure that Outlook is your default mail program
Have you check the register settings on your machine ?

Both are set correctly.

Following other leads on your page revealed that selecting Send to...
from inside Excel results in "Excel could not start the e-mail
program".

However, every page on this error, including MS's, claims this only
happens in Excel 2002. I am using Excel 2003 SP3.

Any ideas? The HTML conversion doesn't work well in this case.

Maury

I not say that this
The Outlook version and the Office version must be the same to send in the body of the mail.

I read that you have uninstalled the 2007 test version on that machine and it is working now ?

--

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


"Maury Markowitz" wrote in message
...
Be sure that Outlook is your default mail program
Have you check the register settings on your machine ?

Both are set correctly.

Following other leads on your page revealed that selecting Send to...
from inside Excel results in "Excel could not start the e-mail
program".

However, every page on this error, including MS's, claims this only
happens in Excel 2002. I am using Excel 2003 SP3.

Any ideas? The HTML conversion doesn't work well in this case.

Maury

Yes, like a champ. It's not Office 2007, but Office 2007 Primary
Interop. In spite of un-installing Office itself, this code is left
behind. They filed a report, the KB article will likely be updated
shortly.

I got my first KB! :-)

Maury