question

SabrinaMartin-8971 avatar image
0 Votes"
SabrinaMartin-8971 asked emilyhua-msft commented

Excel on a Mac

How can I send one sheet of a workbook to a person via email when using a Mac?

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft commented

@SabrinaMartin-8971

You could click the Share button in the upper right corner, then click Send a Copy.

141548-capture30.jpg

And then please choose one app, such as Outlook as following image.
141594-capture31.jpg

But please note, before you can send an email, you should set up an email accout in Outlook, then you could enter the address that receive this email, and click Send.
141620-capture34.jpg

Otherwise, you need to click OK to close the prompt below, go to Outlook > Preferences > Accounts under Personal Settings to add an email account in Outlook.
141623-capture33.jpg


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




capture30.jpg (17.5 KiB)
capture31.jpg (23.9 KiB)
capture34.jpg (49.5 KiB)
capture33.jpg (30.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@SabrinaMartin-8971
If you have a chance to back, please check whether my information is helpful.
Any issues, you could feel free to post back.

0 Votes 0 ·
SabrinaMartin-8971 avatar image
0 Votes"
SabrinaMartin-8971 answered emilyhua-msft commented

Yes Emily, that's great, but I specifically asked how to send a SHEET, not the entire workbook.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SabrinaMartin-8971
Thanks for your explaination.
But currently there is no direct option on Excel for Mac to send a single worksheet.
A worksheet cannot exist as an "entity" that you can attach to an e-mail, you need to have a workbook file to send, so I suggest you save a single worksheet into a workbook.

To do it, please right-click the sheet tab, click "Move or Copy".
Then choose one sheet that you need to send to others. Please do not forget to tick the box of "Create a Copy".
142934-capture50.jpg
And then I suggest you open the copy file, please continue to checkout the steps that I mentioned in my first reply.

0 Votes 0 ·
capture50.jpg (20.7 KiB)

Hi @SabrinaMartin-8971
I am checking this thread, do you have any other issues?
If yes, please let me know.

0 Votes 0 ·
SabrinaMartin-8971 avatar image
0 Votes"
SabrinaMartin-8971 answered emilyhua-msft commented

No, no other questions at the moment.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SabrinaMartin-8971,
Thanks for your quick reply.
If you have any issues of Office on Mac, welcome to disscuss with us on Q&A forum with this tag.

Besides, if you need a automated operation to achieve your request, I would suggest you post a new thread with the tag "office-vba-dev".
Thanks for your understanding.


0 Votes 0 ·