Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Email Excel spreadsheets as formatted HTML pages Apps
This hint combines two-rarely used features -- Microsoft Excel's Web Page Preview and Safari's Mail Contents of this Page -- in a useful manner.

Open a spreadsheet in Excel, and choose File: Web Page Preview. Then in Safari, select File: Mail Contents of This Page (or just press Command-I). Surprisingly, the columns format nicely and the HTML code that it sends out will view properly in everything from web-based email clients to Entourage and Outlook. In many cases, this method of sending a spreadsheet may be preferred to sending an attachments.

[robg adds: Both Word and PowerPoint also have the Web Page Preview feature, so you could also send those files in this manner. It might not make much sense for Word, but could be useful for sending out the occasional PowerPoint slide.]
    •    
  • Currently 2.00 / 5
  You rated: 3 / 5 (7 votes cast)
 
[17,545 views]  

Email Excel spreadsheets as formatted HTML pages | 11 comments | Create New Account
Click here to return to the 'Email Excel spreadsheets as formatted HTML pages' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Email Excel spreadsheets as formatted HTML pages
Authored by: yrret on Aug 31, '06 08:02:30AM

Nice tip. Hadn't thought of that before, and it work well.

---
----------------------------
Microsoft is not the answer.
It is the question.
The answer is NO!



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: adrianm on Aug 31, '06 08:05:30AM

Useful, though I usually print to PDF and email that. Works in any app that can print.

---
--
I'm too old for a fancy .sig



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: ryebrye on Aug 31, '06 08:47:30AM

The main advantage to this over printing to a PDF or mailing the file directly is that you have no attachments in the email. Some people are paranoid of attachments, and very few email clients view PDF's inline.

For a quick "here are the numbers" - this works well. If you have charts or other things involved, you are going to need to use a PDF.



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: fredrikw on Aug 31, '06 10:17:23AM

And chosing the Pdf-service "Mail pdf" is even easier... (but has the same problem as printing, then mailing)



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: llstein on Aug 31, '06 08:50:57AM

This is a great work-around. Especially when making a .pdf won't work, i.e. multi-page Excel sheets don't export as a multi-page .pdf. Neither Acrobat Pro nor Apple pdf creator can do it.

Then I got to thinking....Acrobat Pro has a "create pdf from web page" option, maybe if I save as web page in Excel and create from web page in Acrobat Pro, I would get my much needed multi-page PDF?? No go.

Very good tip.

Linda



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: ateichman on Aug 31, '06 09:09:14AM

Be careful when saving Excel to HTML.

I work with an organisation that distributes its employee schedules through Excel as HTML. Because font substitution can take place in the recipient's browser, what occasionally occurs is that text at the right edge of a cell gets shoved over so that it is obscured by info in the adjacent cell. Sometimes this shows up as half a word, so you can guess at the rest. Sometimes it lops the extra off in a way that leaves you with no clue anything is missing.

Careful formatting choices can minimise the risk.



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: scorpion on Aug 31, '06 12:08:24PM

I'm assuming this won't work in Safari 1.3.2 (like it doesn't in mine)?

Is this 10.4 only?



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: otracey on Aug 31, '06 01:53:33PM

I get an error, "Safari couldn't create an email message becuase Microsoft Entourage doesn't support sending webpages from Safari. You can use the Mail application included with Mac OS X to send web pages."

Since my company forces us to use Entourage, I guess I'm out of luck with this tip, huh?



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: ryebrye on Aug 31, '06 09:58:13PM

In what way do they force you to use entourage?

My company uses an Exchange Server - but Apple's Mail program works quite well with exchange servers. You can even use iCal to handle calendar events - but admittedly Entourage works best for that.

I keep both Apple's Mail program and Entourage open at the same time. Because of how the exchange server works, I think the "read" status is updated in one when it is read in the other, but I'm not entirely sure.

It works well - because I can use Entourage for calendar events, and Mail for messages and sending out cool HTML formated messages - which Entourage reads just fine.

YMMV - but you should try setting Mail up with your exchange server and see how well it works.



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: MilMascaras on Sep 16, '06 12:15:47PM

Some large corps will ONLY support Entourage/Mac and Outlook/PC. PERIOD. For support consistency. Argue all you want, that's life.

Anyways, if you can figure out how to set up Apple Mail to use anything (for instance your ISP personal mail or dotMac), you can use Apple Mail to format the excel embedded email, then forward it to your corp email account, then now that it is captured in Entourage/Outlook, forward this formatted page as you wish...

Thats how we do it at the gigantic corp I work for (40,000+ employees...)



[ Reply to This | # ]
Email Excel spreadsheets as formatted HTML pages
Authored by: andreas999 on Sep 01, '06 02:04:56AM

I have used this technique quite a lot from Word to send nicely formated tables and such.

However, although it looks nice in Mail.app before you send, somewhere in the process the Swedish characters едц (and I suspect any other non-english character) doesn't display correctly at the recipents end, at least if they are using Outlook.



[ Reply to This | # ]