How to Attach an Active Excel Worksheet and Add Email Recipients
Question details
The user wants to automate the process of attaching the currently active Excel worksheet to an Outlook email while simultaneously auto-filling the email recipients.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to share a specific active worksheet via email to predefined recipients directly from Excel.
- Observed behavior
- Native Excel commands can either attach the workbook or populate recipients via hyperlinks, but cannot do both simultaneously without automation.
Check with your IT administrator to ensure VBA macros are permitted on your network, as automating this dual-action process requires executing a macro.
Automate with a VBA Macro
Use a VBA script to create a new email, attach the active worksheet, and set predefined recipients automatically.
Since Excel does not have a native feature to combine the 'Send Email' attachment command with a prepopulated recipient list, a VBA macro is the standard solution. This macro will copy the active sheet, save it temporarily, and open an Outlook message with your recipients already added.
Press ALT + F11 on your keyboard to open the Visual Basic for Applications (VBA) editor.
Click on 'Insert' in the top menu, then select 'Module' to open a blank code window.
Write or paste a VBA script that utilizes 'CreateObject("Outlook.Application")'. Ensure you define the '.To' field with your intended recipients (e.g., user1@xyz.com; user2@xyz.com) and use the '.Attachments.Add' method for the active workbook.
Press F5 to run the script, or assign it to a button on your Quick Access Toolbar for easy access in the future.

Manual Two-Step Workaround
A reliable workaround if your organization's IT policy restricts the use of VBA macros.
Automate Email Attachments in WPS Spreadsheets
WPS Office fully supports VBA macros, allowing you to easily run scripts that attach active worksheets and add recipients simultaneously without compatibility issues.
- 1. Open Your Spreadsheet: Download and open WPS Office, then load your spreadsheet file.
- 2. Access the Developer Tools: Navigate to the Developer tab to access the built-in VBA editor.
- 3. Insert Your Macro: Insert your script to copy the active worksheet and set the email recipients.
- 4. Run and Send: Run the macro to instantly generate your predefined Outlook email with the attachment ready to send.

Frequently Asked Questions
Why can't I use a mailto hyperlink to attach the active worksheet?
A 'mailto' hyperlink can successfully open a new email and prepopulate the recipients, subject, and body. However, HTML protocol restrictions prevent 'mailto' links from attaching local files for security reasons.
Can I attach just one active worksheet instead of the entire workbook?
By default, the standard Excel email command attaches the entire workbook. To send only the active worksheet, you must either copy that single sheet to a new workbook first, or use a VBA macro to handle the extraction and attachment automatically.
What if my IT administrator disables VBA macros?
If VBA is disabled by policy, you cannot fully automate the combined attachment and recipient population. You will need to attach the file using the built-in Share button and manually enter the recipients, or request an exception from your IT department.




