MailEnvelope not working in Excel 2007

  • Thread starter Thread starter lowspark
  • Start date Start date
Status
Not open for further replies.
L

lowspark

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 "may.tillis@kochind.com"

> 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

"lowspark" <may.tillis@kochind.com> wrote in message

news:110285e3-c66c-4c6d-9c9c-1da0fda8167b@o6g2000yqj.googlegroups.com...
> 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 "may.tillis@kochind.com"
> .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]" <sue...@turtleflock.com> 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
>    >      >    >

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

was looking for!
 
Status
Not open for further replies.
< Automatically extract attachments? | Personal Stationery >
Similar threads
Thread starter Title Forum Replies Date
J Getting MailEnvelope of a Word document does not work Outlook VBA and Custom Forms 2
P Outlook 2016 Working Offline Using Outlook 2
T SMTP suddenly quit working - password Reset Using Outlook.com accounts in Outlook 3
D Outlook 2021 not working with Outlook 2003 installed Using Outlook 5
D Outlook 2003 stopped working - get they dialog box asking for username & Password Using Outlook 2
M Autocomplete not working properly Using Outlook 3
N VBA Code Not Working correctly Outlook VBA and Custom Forms 1
T Outlook 365 won't take new working password Using Outlook 0
E Outlook 365 Save Selected Email Message as .msg File - oMail.Delete not working when SEARCH Outlook VBA and Custom Forms 0
Z Outlook 2021 Outlook new emails notification not working Using Outlook 4
A Outlook 365 Outlook (part of 365) now working offline - argh Using Outlook 5
G LinkedIn tab missing in Outlook 365 (but working in OWA) Using Outlook 0
BartH VBA no longer working in Outlook Outlook VBA and Custom Forms 1
S New Email "From" box stopped working Using Outlook 0
R Outlook Working off line Using Outlook 0
H How to Fix 1510-370-1986 Garmin GPS Not Working Outlook VBA and Custom Forms 0
M Outlook 2019 Macro not working Outlook VBA and Custom Forms 0
L Outlook 365 Outlook not working on linux how to solve it Using Outlook.com accounts in Outlook 0
Z Outlook.com OST Stopped working without explanation Using Outlook.com accounts in Outlook 3
Commodore Automatic switch between working offline/online Using Outlook 4
V Outlook 2016 iCloud for Windows - Why no working Calendars and Tasks ? Using Outlook 1
S HTML Code Embedded in String Within Open Outlook Email Preventing Replace(Application.ActiveInspector.CurrentItem.HTMLBody From Working Outlook VBA and Custom Forms 4
G print attachment straight away; working script edit not working Outlook VBA and Custom Forms 0
V Auto-complete stopped working Using Outlook 4
F Searches are not working properly Using Outlook 1
Jennifer Murphy Spam filter not working Using Outlook 13
D Connecting Gmail to Outlook 365 - My Setup not working Using Outlook 2
A Prepending Email Addrs with "Display Name <email>" Has Stopped Working Using Outlook 0
R rules not working - done troubleshooting Using Outlook 0
R Follow up button doesn't working neither the reminders in BCM BCM (Business Contact Manager) 0
A calendar invites sent from Microsoft Outlook to Mac Outlook is not working Using Outlook 2
Z Task Filter Not Working When I add too many criteria Using Outlook 0
D iCloud Add-in not working in Outlook 2013 and Outlook 2016 After Windows Upgrade & iCloud Upgrade Using Outlook 2
bmtjedi Set objApp = Application Not Working in O365-32bit Using Outlook 1
B Outlook 2003 email sending & receiving suddenly stopped working Using Outlook 3
S Outlook Custom Form Scripting only working when clicking on "Run this form" Outlook VBA and Custom Forms 2
K Outlook 2016 - controlling IMAP OST size with Group Policy not working Using Outlook 1
F KB4475563 stops VBS at forms working Outlook VBA and Custom Forms 3
J Copy to calendar function no longer working in outlook 365 Using Outlook 5
D Archive by receive date not working Using Outlook 2
M move to iCloud not working in outlook calendar Using Outlook 12
cricket1001 Shade non-working days in calendar Using Outlook 0
L Outlook 2019 MAC sync error after working for 4 hours Using Outlook 1
A rules not working Using Outlook 2
B Reply and replyall macro is not working Outlook VBA and Custom Forms 1
D Any updates or fixes that would make this code stop working just moving emails to another folder Outlook VBA and Custom Forms 1
V Autocomplete not working on new email account Using Outlook 4
P Two main Outlook gripes: Voting buttons not working externally nor Focused Inbox Using Outlook 1
M email search not working Using Outlook 1
B When working on emails in a certain folder, when I hit reply or reply all, I would like it re always reply all and add an email address to send to Outlook VBA and Custom Forms 3

Similar threads

Back
Top