LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Sending a selection by email

I cannot find any VBA code to allow me to send a Selected Range as
part of the body of an email. I can do this easily by first selecting
the range; and the use MSExcel menu "File-Sent To-Mail Recipient" add
email address and subject and then press "Send-Selection".

I can send a whole workbook using VBA Code:- "ActiveWorkbook.SendMail"
but not a selected range.
Can anyone help?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Macro how to create email link for the email addresses in aRange or Selection Satish[_2_] Excel Worksheet Functions 8 December 28th 09 03:30 PM
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email billbrandi Excel Discussion (Misc queries) 1 April 3rd 08 03:44 AM
Sending Email via VBA Chad Excel Programming 2 August 31st 07 09:46 PM
Sending email with selection of data from spreadsheet tanyhart[_26_] Excel Programming 1 June 15th 06 08:59 PM
sending a singular email by selection Steven Excel Programming 2 March 3rd 04 02:56 PM


All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"