Then click this Send to Mail Recipient icon button, and a prompt box pops out, in the E-mail prompt box, check Send the current sheet as the message body, and click OK. The Send to Mail Recipient command has been inserted into the Quick Access Toolbar, see screenshot:Ĥ. And in the Excel Options dialog box, choose Commands Not in the Ribbon in the Choose Commands from drop down list, then select the Send to Mail Recipient option, and click Add > button to add this command, at last click OK to save this setting. Click the icon of the Customize Quick Access Toolbar, and choose More Commands, see screenshot:Ģ. If you use Excel 2007, 2010 or 2013, you need to add this Send to Mail Recipient command to the Quick Access Toolbar first.ġ. Send single worksheet as a PDF file from Excel with VBA codeĮxcel supports us to email the active worksheet as body content by using the Send to Mail Recipient command. ![]() Send single worksheet as an attachment from Excel with VBA code Send single worksheet as body from Excel with Send to Mail Recipient command But are there any quicker ways for you to deal with this problem in Excel? If you want to email a single worksheet out of a workbook in Excel via Outlook, you can send the worksheet as an attachment, as body content or as a PDF file. ![]() ![]() How to send worksheet only through Outlook from Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |