MAC - Import table from Excel 2011 to Outlook 2011 using copy and paste - losing formatting

Hi Guys

I have a user that is attempting to import tables created within Excel 2011 to a new Outlook message. She can actually do this - but the formatting looks a little different.
Back in the days of using Entourage - this copied and pasted perfectly, as you would expect

The new Outlook message is definately set to HTML

There doesnt seem to be a 'paste special' option like when using PCs.

Does anyone have any tips? Ideas?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian GeeCommented:
When you mentioned 'look a little different' what aspects are different? Are the rows/columns not lining up or are the font properties adjusted some or is the text in the cells aligned differently?

Also, just for sakes, try pasting using Rich Text format to see if that yields any difference as well.
nexusitcomsAuthor Commented:
excelHere is what it looks like in Excel

 outlookHere is what it looks like in Outlook

The data of course is the same - but they want a carbon copy gridlines and all
(i know....)

Brian GeeCommented:
The columns in the top picture have those white breaks to help in signifying where the cells split (visually on the spreadsheet)... is it possible to try incorporating white borders so as to specifically include the white separation lines so that they carry over into Outlook email to look like the top picture?

It's like if I copy over a range of cells in Excel (having the visual cell boundary lines inherent of the spreadsheet) but when I paste into Outlook email, the boundary lines don't carry over so all I have is data with spacing (and no lines)... not in HTML or RTF formats.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

nexusitcomsAuthor Commented:
Yup - so even if i set black boarders + gridlines on the table and then copy that table from Excel to Outlook it doesnt work and still looks like the Outlook example above...
Brian GeeCommented:
I went to test this using the Format as Table coloring scheme with Office 2010 (PC) and the copy and paste transfers like it is supposed to (this since I don't have a copy of Office 2011 for my Mac VM).

If the data sent via email must look like what is being displayed in Excel with the borders intact, would a screenshot of the certain section work for their objectives?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nexusitcomsAuthor Commented:
I think it will have to Yobri.
After all there isnt much other choice by the seem of it! :)

Cheers anyway
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
select the table in Excel. go to border options. select a thicker line. apply to external edges and internal edges. and there you have it. it should copy and paste into Outlook with the borders.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.