Forum Discussion
Formatting wont transfer from Excel to Outlook
The last 2 or 3 days every time I copy and paste from Excel into Outlook it drops all of the formatting. I've adjusted my settings to keep formatting, tried manually telling it to keep the formatting. It simply wont. I've googled and searched the Microsoft website to no avail.
2 Replies
If Excel formatting suddenly stopped transferring to Outlook, it’s likely Outlook or Office settings. Not always have Excel problem. Firstly users can try Paste Special → Keep Source Formatting.
If still not work then you should check Outlook → File → Options → Mail → Editor Options → Advanced → Cut, copy, and paste.
Excel content isn’t being pasted as plain text. Make sure your Outlook message is set to HTML, not Plain Text. You can also test Outlook on the web to determine whether the desktop app is causing the issue. If nothing works, restart Office, disable add-ins temporarily, or run an Office repair. If still not changing the format then you can choose software solution which not just convert your file but also make formatting unchangeable. I suggest BitRecover. I used their application to convert MBOX to PST. You can contact support team.
Excel formatting can change in Outlook when the message is composed as plain text or rich text, when paste defaults merge formatting, or when an add-in modifies the editor. Start a new message and confirm its format is HTML. Copy a small test range from Excel, then use the paste options and select Keep Source Formatting; Paste Special can also preserve the table as HTML or insert it as a picture when fidelity matters. Test in a new message rather than a reply, because the original message format can control the reply. If the problem persists, start Outlook in Safe Mode and repeat the paste. A successful Safe Mode test indicates an add-in is involved, so disable add-ins individually. Update Office and run Quick Repair, followed by Online Repair only if needed. Complex conditional formatting, column widths, and unsupported Excel features will not always translate perfectly into Outlook’s HTML editor.
