Sending a selection by email

[Canlink]

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?

 

[Ron de Bruin]

Hi Canlink

Try this example if you use Outlook
http://www.rondebruin.nl/mail/folder3/mail4.htm

Or
http://support.microsoft.com/default.aspx?scid=kb;en-us;816644

 

[Mike H]

hi,

Have a look here

http://www.rondebruin.nl/mail/folder2/mail4.htm

Mike

 

[Canlink]

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?

Thanks Ron and Mike for directing me to Ron's page - I have tried
Ron's Suggestion and it works wonderfully.

 

[LaRana!]

Your code rocks!
Thanks,
--
EddieV

Hi Canlink

Try this example if you use Outlook
http://www.rondebruin.nl/mail/folder3/mail4.htm

Or
http://support.microsoft.com/default.aspx?scid=kb;en-us;816644

 

[Ron de Bruin]

Hi EddieV

I add a new page
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm

This will also send a image in the body of the mail