|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using ActiveWorkbook.EnvelopeVisible = True to send part of a sheet as an email.
I was using the below code in Excel 2003 and it worked with no problem. I am now using Excel 2010 and I get "Run-time error '287' Application defined or object defined error.
I have the following code: Activeworkbook.Names.Add Name:="EmailBody", RefersToR1C1:="=Email!R38c13:r100c15" Application.Goto Reference:="EmailBody" ActiveWorkbook.EnvelopeVisible = True With ActiveSheet.MailEnvelope .Introduction = "" .Item.sentonbehalfofname = my email address .Item.To = email to send to .Item.Subject = Range("o35").value .Item.send End With It errors out when it gets to the .Item.send line. Does anyone know what the issue could be? Thanks. |
#2
|
||||
|
||||
It's fine here in Excel 2010.
Is Outlook installed? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
send an email every week. | devilonline | Outlook | 0 | 08-03-2012 10:30 AM |
How to send an email to all contacts I ever send an email to? | JSYdeJong | Outlook | 1 | 11-02-2011 07:22 PM |
Send document as email | pat-ty | Word | 0 | 09-09-2010 10:23 AM |
Email send delay--where? | markg2 | Outlook | 8 | 02-14-2010 03:40 PM |
Can't send email | helpplease | Outlook | 6 | 12-21-2008 06:00 AM |