• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3032
  • Last Modified:

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?

Cheers
0
nexusitcoms
Asked:
nexusitcoms
1 Solution
 
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.
0
 
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....)

Cheers
0
 
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.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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...
0
 
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?
0
 
nexusitcomsAuthor Commented:
I think it will have to Yobri.
After all there isnt much other choice by the seem of it! :)

Cheers anyway
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
kutzcdCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now