Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2014, 02:18 PM
bshawnr bshawnr is offline Using ActiveWorkbook.EnvelopeVisible = True to send part of a sheet as an email. Windows XP Using ActiveWorkbook.EnvelopeVisible = True to send part of a sheet as an email. Office 2003
Novice
Using ActiveWorkbook.EnvelopeVisible = True to send part of a sheet as an email.
 
Join Date: Aug 2013
Posts: 2
bshawnr is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-12-2014, 05:02 AM
p45cal's Avatar
p45cal p45cal is offline Using ActiveWorkbook.EnvelopeVisible = True to send part of a sheet as an email. Windows 7 32bit Using ActiveWorkbook.EnvelopeVisible = True to send part of a sheet as an email. Office 2010 32bit
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

It's fine here in Excel 2010.
Is Outlook installed?
Reply With Quote
Reply

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
Using ActiveWorkbook.EnvelopeVisible = True to send part of a sheet as an email. 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
Using ActiveWorkbook.EnvelopeVisible = True to send part of a sheet as an email. Can't send email helpplease Outlook 6 12-21-2008 06:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft