How to e-mail current sheet as an attachment ???

dougp · Apr 17th, 2002, 08:12 AM

Excel 2000

Thanks

Doug

Visions_Fugitive · Apr 17th, 2002, 08:21 AM

Try this:

File > Send To > Mail Recipient (As Attachment)...

dougp · Apr 17th, 2002, 11:30 AM

File - Send To attaches the entire workbook.

Thanks

Doug

Visions_Fugitive · Apr 17th, 2002, 01:52 PM

I see. Well, you could try copying the sheet to a new workbook, then send that workbook. This code will do the copying and will open the email. You have to enter the recipient's address and send it manually:

Code:

ActiveSheet.Copy
Application.Dialogs(xlDialogSendMail).Show

gareth · Apr 18th, 2002, 02:06 AM

You will need to go to >> Send to >>> Mail Recipient as attachment>>

Then excel will ask you if you want to send the whole document or just the selected sheet.Hope that helps you to perform your task.

Jack in the UK · Apr 25th, 2002, 11:29 AM

Garth

Visions_Fugitive
Board Regular

Joined: Apr 16, 2002
Posts: 9
From: Milwaukee, WI
Posted: 2002-04-17 07:21
--------------------------------------------------------------------------------
Try this:

File > Send To > Mail Recipient (As Attachment)...

||||||||||||||||||||||||||||||||||

you posted some four hours later ??? the board has been asnswered and you post offeres little advance, i welcom and warmly thank all posters for help even if negative that is does not work but was sent in good faith and is related to topic... here you say just the same... do you not read the posts and all the feed, i have noticed this has happened before....

Im not digging you or bing hostile, but credit the posters work is all im hinting at and read the posts fully... never know might learn from the wonderful guys, i know i do every day.

your post timed
Posted: 2002-04-18 01:06
but was answered at
Posted: 2002-04-17 07:21

gareth
Board Master

Joined: Apr 16, 2002
Posts: 73
From: Cape Town,South Africa
Posted: 2002-04-18 01:06
--------------------------------------------------------------------------------
You will need to go to >> Send to >>> Mail Recipient as attachment>>

Then excel will ask you if you want to send the whole document or just the selected sheet.Hope that helps you to perform your task.

Apr 17th, 2002, 01:52 PM	#4
Visions_Fugitive New Member Join Date: Apr 2002 Location: Milwaukee, WI Posts: 18	I see. Well, you could try copying the sheet to a new workbook, then send that workbook. This code will do the copying and will open the email. You have to enter the recipient's address and send it manually: Code: ActiveSheet.Copy Application.Dialogs(xlDialogSendMail).Show

Apr 25th, 2002, 11:29 AM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Garth Visions_Fugitive Board Regular Joined: Apr 16, 2002 Posts: 9 From: Milwaukee, WI Posted: 2002-04-17 07:21 -------------------------------------------------------------------------------- Try this: File > Send To > Mail Recipient (As Attachment)... \|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\| you posted some four hours later ??? the board has been asnswered and you post offeres little advance, i welcom and warmly thank all posters for help even if negative that is does not work but was sent in good faith and is related to topic... here you say just the same... do you not read the posts and all the feed, i have noticed this has happened before.... Im not digging you or bing hostile, but credit the posters work is all im hinting at and read the posts fully... never know might learn from the wonderful guys, i know i do every day. your post timed Posted: 2002-04-18 01:06 but was answered at Posted: 2002-04-17 07:21 gareth Board Master Joined: Apr 16, 2002 Posts: 73 From: Cape Town,South Africa Posted: 2002-04-18 01:06 -------------------------------------------------------------------------------- You will need to go to >> Send to >>> Mail Recipient as attachment>> Then excel will ask you if you want to send the whole document or just the selected sheet.Hope that helps you to perform your task. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Apr 17th, 2002, 08:12 AM	#1
dougp New Member Join Date: Mar 2002 Location: Doug Potter Posts: 3	Excel 2000 Thanks Doug

Apr 17th, 2002, 08:21 AM	#2
Visions_Fugitive New Member Join Date: Apr 2002 Location: Milwaukee, WI Posts: 18	Try this: File > Send To > Mail Recipient (As Attachment)...

Apr 17th, 2002, 11:30 AM	#3
dougp New Member Join Date: Mar 2002 Location: Doug Potter Posts: 3	File - Send To attaches the entire workbook. Thanks Doug

Apr 18th, 2002, 02:06 AM	#5
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	You will need to go to >> Send to >>> Mail Recipient as attachment>> Then excel will ask you if you want to send the whole document or just the selected sheet.Hope that helps you to perform your task.