8
2
I'm trying to embed part of an Excel sheet into an email. I tried saving the Excel file as a .HTML and then emailing that, but the .HTML doesn't preserve text colors! Anyone have any ideas?
jakecar
Posted 2010-05-20T07:34:42.180
Reputation: 183
3
Here are your options:
Use the Windows Snipping Tool. You can find it in Start Menu > Accessories. Or access it by clicking Start, typing "snipping tool" in the search box and then pressing Enter. After screengrabbing a part of your sheet, it automatically sends it to the clipboard. Open your email client and then just paste it in the body of your message.
MS Excel's Camera tool. To add it to your Quick Access Toolbar, click the MS Office orb > Excel Options > Customize > Choose Commands not in the ribbon from the drop-down menu > Click Camera > Add. To use it, highlight the cell range you wish to include in your email and then click the Camera tool. Click anywhere in your spreadsheet to drop the image, copy it and then paste it in the body of your email.
Copy-pasting cells - You may lose some formatting (and even merged cells). Or: Paste Special > Source Formatting. You won't lose anything.
Create a duplicate spreadsheet that contains only the values (no formulas) and formatting, and then attach this to your email. I believe recording a macro can help you do this faster.
Collaborate online. Upload it to Office Live Workspace and collaborate from there. I think you need Office 2010 for this. You can even use Zoho or Google Docs.
Use free online file sharing services like Dropdo, Dropbox, Box.net or Min.us. Upload then embed the link to your file in your email.
Ellesa
Posted 2010-05-20T07:34:42.180
Reputation: 9 729
This was one comprehensive answer sir! :) – Dheeraj Bhaskar – 2016-07-22T10:13:24.643
1@DheerajBhaskar Thanks! :) But I'm a lady m'lord. :) – Ellesa – 2016-07-27T18:35:09.780
3
I assume you use Outlook 2007. Can you try to do the following?
1-Go to Insert > Table
2-Excel Spreadsheet
3-Paste your table
4-Make some arrangements like font, color.
I think this solves your problem, at least for now.
evowinds
Posted 2010-05-20T07:34:42.180
Reputation: 195
My fault for not being more specific...
I am trying to do this ultimately through my school's online email client (which is pretty crappy), but maybe trying to do it in GMail first would be better. I realize I can attach the file, but that is not what I want. This is starting to sound like a pretty unattainable thing. I actually asked this on Stackoverflow because I want to do it through Python, but they referred me over here... – jakecar – 2010-05-20T16:40:18.127
2
If your eMail client supports colors and graphics, the answer is copy and paste when the client is in html mode. Another option is to get a different client which will support html. I use Outlook 2003 and Eudora and both do this without problems.
Dave
Posted 2010-05-20T07:34:42.180
Reputation: 526
This just worked quite well for me with Excel and Outlook 2013 - now to automate it... – Kendall Lister – 2017-05-23T06:52:18.877
1
This may be clunky, but it seems to satisfy your requirements (as I understand them): have you tried doing a print-screen, pasting the result into MSPaint, cropping it, then pasting the cropped image into the email? This method guarantees that the email recipient will see exactly what you want them to see, as long as images aren't a problem in your email system. You can even save a few steps by using the open source ZScreen or some similar print screen utility. Unless of course the recipient needs to be able to work with the data you're sending, in which case images will be useless.
boot13
Posted 2010-05-20T07:34:42.180
Reputation: 5 551
1
You can literally select anything you need to in your Excel file and then do a copy/paste into a Word document. Save the Word document as a JPEG, go to your "compose mail" button in Gmail and then copy/paste the jpeg into the body. Worked for me.
The format is the only obstacle preventing you from directly copying and pasting your images from Excel to Gmail. Unfortunately Windows isn't exactly up to speed with technology, so it requires that we take the long way around to do anything, but I digress.
Uh uh
Posted 2010-05-20T07:34:42.180
Reputation: 11
0
After opening new mail just click on the 'Rich Text' under Format text option. Then select the cursor where you want to embedded the file and just attach the file. It is automatically embedded the file in email.
user523905
Posted 2010-05-20T07:34:42.180
Reputation: 1
1But he doesn't want to attach the file. Just part of it. – Chenmunka – 2015-11-19T13:10:50.630
0
First you paste in Outlook & after that copy that Excel data & again paste into Gmail. It work for me check it out, it's cool.
ninad86
Posted 2010-05-20T07:34:42.180
Reputation: 1
Why don't you save the part you want to send as a new separate Excel file, and then attach it to the e-mail? – Mehper C. Palavuzlar – 2010-05-20T08:22:13.990
2
Just in case you didn't know: unless the recipient is using the same email software (and maybe even the exact same version on the same operating system, with the same settings), you can never be sure how things look when reading it. (For a lot of technical details see also the Campaign Monitor Guide to CSS Support in Email, but your email client might not even be using plain CSS to achieve formatting.)
– Arjan – 2010-05-20T09:05:32.5501Why don't use google docs? – Toc – 2010-05-21T10:42:42.080