Attachment Issues

How to Attach an Active Excel Worksheet and Add Email Recipients

Nimra MalikNimra Malik Nov 3, 2026 870 views

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.

How to Attach the Active Excel Worksheet and Prepopulate 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.
Before you start

Check with your IT administrator to ensure VBA macros are permitted on your network, as automating this dual-action process requires executing a macro.

Solution 1Recommended

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.

1
Open the VBA Editor

Press ALT + F11 on your keyboard to open the Visual Basic for Applications (VBA) editor.

2
Insert a New Module

Click on 'Insert' in the top menu, then select 'Module' to open a blank code window.

3
Add the Automation Script

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.

4
Run the Macro

Press F5 to run the script, or assign it to a button on your Quick Access Toolbar for easy access in the future.

Automate with a VBA Macro
Save as Macro-Enabled: Remember to save your Excel file as an Excel Macro-Enabled Workbook (.xlsm) so the VBA script is preserved for future use.

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. 1. Open Your Spreadsheet: Download and open WPS Office, then load your spreadsheet file.
  2. 2. Access the Developer Tools: Navigate to the Developer tab to access the built-in VBA editor.
  3. 3. Insert Your Macro: Insert your script to copy the active worksheet and set the email recipients.
  4. 4. Run and Send: Run the macro to instantly generate your predefined Outlook email with the attachment ready to send.
Full support for Excel VBA macros and automationSeamless integration with desktop email clients100% compatible with Microsoft Excel (.xlsx and .xlsm) formatsLightweight and free to use
microsoft office alternative - wps office

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.