Sending a mail NOT as an attachment.

BenNV · May 9th, 2002, 01:43 AM

I'm am able to send a mail as an attachment by using:

ActiveWorkbook.sendMail Recipients:="123@abc.com"

Is there a way to send the Excel sheet within the mail, like a copy and paste?

crimlet · May 9th, 2002, 02:04 AM

Yes as you said, copy the selected cells open up a new mail message and paste

BenNV · May 9th, 2002, 02:15 AM

Trying to find the lazy way round this! What I want to do is find some code that will allow this.

eddy · May 9th, 2002, 02:15 AM

I need to do the same thing. It sounds simple but a simple cut'n'past dosn,t work. You loose the formatting. I would also like to see a solution using a macro if anyone knows how to do it.
eD

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 01:43 AM	#1
BenNV Board Regular Join Date: Mar 2002 Posts: 160	I'm am able to send a mail as an attachment by using: ActiveWorkbook.sendMail Recipients:="123@abc.com" Is there a way to send the Excel sheet within the mail, like a copy and paste?

May 9th, 2002, 02:04 AM	#2
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	Yes as you said, copy the selected cells open up a new mail message and paste

May 9th, 2002, 02:15 AM	#3
BenNV Board Regular Join Date: Mar 2002 Posts: 160	Trying to find the lazy way round this! What I want to do is find some code that will allow this.

May 9th, 2002, 02:15 AM	#4
eddy Board Regular Join Date: Mar 2002 Posts: 473	I need to do the same thing. It sounds simple but a simple cut'n'past dosn,t work. You loose the formatting. I would also like to see a solution using a macro if anyone knows how to do it. eD