Create a Formatted Email from Excel Without VBA
Question details
Create an email from Excel with a recipient list, subject, and formatted message body without requiring VBA.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A project-management spreadsheet prepares notifications for people whose project data is incorrect.
- Observed behavior
- The HYPERLINK function can populate email fields, but a mailto link does not preserve Excel cell formatting, background colors, or embedded hyperlinks in the message body.
Prepare the recipient list, subject, and formatted message in separate Excel cells. Make sure your email application can compose messages in HTML or another rich-text format.
Copy Formatted Excel Cells into a New Email
Use this manual method when sending the message yourself is acceptable and you want to avoid VBA.
A mailto link passes plain text to the email application; it cannot transfer Excel cell formatting as an HTML message. Copying the cells separately gives the email application an opportunity to retain their formatting.
Click the existing mailto HYPERLINK in Excel to open a draft with the recipients and subject, or create a new email and copy those fields from the spreadsheet.
In the email compose window, select HTML or a rich-text message format if the application offers a format option.
In Excel, select the cells containing the message body and use Home > Copy or press Ctrl+C.
Click in the email body and paste the cells. If a paste-options menu appears, choose the option to keep source formatting. Check the colors, layout, and hyperlinks before sending.
Review the To and Subject fields, make any needed corrections, and click Send in your email application.

Prepare Email Content in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to move existing files. You can prepare and copy formatted cells into an email, although switching apps does not make mailto links preserve formatting automatically.

Frequently Asked Questions
Can an Excel HYPERLINK create an HTML-formatted email body?
No. A mailto link can supply plain-text fields, but it does not transfer Excel formatting as an HTML email body. Copy the formatted cells into the email separately.
Why did my pasted cells lose their background colors?
The email may be in plain-text mode, or the email application may not preserve the copied formatting. Choose HTML or rich text in the compose window, then paste again and select a keep-source-formatting option if available.
Will hyperlinks in copied Excel cells work in the email?
They may carry over when you paste into an HTML or rich-text email, depending on the email application. Check each link in the draft and add it again using the email editor's link tool if necessary.
Can I automate a formatted email from Excel?
Yes, but a mailto HYPERLINK alone is not enough. A VBA procedure can automate an email application such as Outlook to create a formatted message; the manual copy-and-paste method avoids that programming requirement.




