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

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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
 
Upvote 0
You will need to go to <File> >> 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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top