Here is a simplified version of an email macro which works in 2003 but
not in 2007.

Sub SendEmail()

Sheets("Email").Select
Range("A1:L32").Select

ActiveWorkbook.EnvelopeVisible = True
With Application.ActiveSheet.MailEnvelope
With .Item
.Recipients.Add "
.DeleteAfterSubmit = True
.Send
End With
End With
End Sub

If I set my internet options - Programs - Email to Microsoft Office
Outlook, it fails on this line:
ActiveWorkbook.EnvelopeVisible = True
with this error:
Run-time error '1004': Method 'EnvelopeVisible' of object '_Workbook'
failed

If I set my internet options - Programs - Email to Outlook Express, it
fails on this line:
With Application.ActiveSheet.MailEnvelope
with this error:
Run-time error '430': Class does not support Automation or does not
support expected interface

I have Excel 2007 installed and Outlook 2003 (not 2007) -- not sure if
that makes a difference.

I have scoured the web but cannot find any documentation of others
with this exact problem.

Any help or ideas will be greatly appreciated! thanks!!

I have Excel 2007 installed and Outlook 2003 (not 2007) -- not sure if
that makes a difference.

Yes, it makes a difference. That feature requires matching versions of Excel
and Outlook. It doesn't work with Outlook Express at all.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"lowspark" wrote in message
...
Here is a simplified version of an email macro which works in 2003 but
not in 2007.

Sub SendEmail()

Sheets("Email").Select
Range("A1:L32").Select

ActiveWorkbook.EnvelopeVisible = True
With Application.ActiveSheet.MailEnvelope
With .Item
.Recipients.Add "
.DeleteAfterSubmit = True
.Send
End With
End With
End Sub

If I set my internet options - Programs - Email to Microsoft Office
Outlook, it fails on this line:
ActiveWorkbook.EnvelopeVisible = True
with this error:
Run-time error '1004': Method 'EnvelopeVisible' of object '_Workbook'
failed

If I set my internet options - Programs - Email to Outlook Express, it
fails on this line:
With Application.ActiveSheet.MailEnvelope
with this error:
Run-time error '430': Class does not support Automation or does not
support expected interface

I have Excel 2007 installed and Outlook 2003 (not 2007) -- not sure if
that makes a difference.

On Jul 8, 5:51*pm, "Sue Mosher [MVP]" wrote:
I have Excel 2007 installed and Outlook 2003 (not 2007) -- not sure if
that makes a difference.

Yes, it makes a difference. That feature requires matching versions of Excel
and Outlook. It doesn't work with Outlook Express at all.

--
Sue Mosher, Outlook MVP
* *Author of Microsoft Outlook 2007 Programming:
* * *Jumpstart for Power Users and Administrators
* *http://www.outlookcode.com/article.aspx?id=54


Well, that did it! Thank you very much, that was exactly the answer I
was looking for!