How to Send Macro-Enabled Excel Files Blocked by Email Servers
Question details
The user needs to send a macro-enabled Excel workbook, but the email attachment is being rejected by the email server due to security limits.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Sending a macro-enabled Excel file (.xlsm) to colleagues or clients via email.
- Observed behavior
- Email providers like Gmail, Hotmail, and corporate mail servers block the message and return a permission or security error.
Verify that your recipient's organization allows macro-enabled files, and inform them in advance that you are sending a secure file link or archive to avoid confusion.
Upload to Cloud Storage and Send a Shareable Link
The safest and most reliable method is to host the file on a cloud service and share the link, completely bypassing email attachment security filters.
Email servers block macro files to protect users from malicious code. Uploading the file to a trusted cloud drive respects these security protocols while ensuring your recipient gets the file.
Log in to a cloud storage provider such as Google Drive, OneDrive, Dropbox, or WPS Cloud, and upload your .xlsm file.
Right-click the uploaded file in your cloud drive and select 'Share' or 'Get link'. Set the permissions so your intended recipient can download it.
Copy the generated sharing link, paste it into your email body, and send it to the recipient.

Compress the Workbook into a ZIP Archive
Zipping the file changes its extension, which can bypass basic attachment filters on some email servers.
Use a Secure File-Transfer Service
If cloud storage is unavailable or the file is too large, use a dedicated file-transfer website to deliver the document securely.
Easily Share Macro-Enabled Spreadsheets with WPS Office
WPS Office provides excellent support for VBA macros and features built-in cloud sharing. You can save your macro-enabled spreadsheet directly to WPS Cloud and instantly generate a sharing link, avoiding email attachment blocks entirely.
- 1. Save to WPS Cloud: Open your macro-enabled spreadsheet in WPS Office Spreadsheet, click on 'Menu', and select 'Save to Cloud'.
- 2. Generate a Share Link: Click the 'Share' button located in the top-right corner of the interface to create a secure, shareable link.
- 3. Send the Link: Copy the link and paste it into your email. Your recipient can easily download the file without triggering email security filters.

Frequently Asked Questions
Why do email servers block macro-enabled Excel files?
Email servers block .xlsm files because macros can contain malicious code or viruses. Blocking these files by default is a security measure to protect users and corporate networks from malware attacks.
Can I bypass the email block by changing the file extension?
While changing the extension from .xlsm to .txt might bypass simple filters, modern email servers scan the actual file headers and will likely still block it. Furthermore, it causes confusion for the recipient who must rename it back to open it correctly.
Are ZIP files always allowed by corporate email servers?
No. Strict corporate email security systems often scan the contents of ZIP archives. If they detect a macro-enabled file inside, they will still strip the attachment or reject the email entirely.
Does WPS Office support macro-enabled files?
Yes, WPS Office Pro and WPS Office Business editions fully support VBA macros. You can open, edit, and run macros just as you would in Microsoft Excel, and easily save them in the standard .xlsm format.




