Pasting Excel Table to Outlook - Retain Cell Alignment

[Askol]

Hey,

Apologies if this is not the correct place for this question, as it may have more to do with Outlook than Excel.

The issue that I am having is when pasting Autofitted columns from Excel into an Outlook email. In Excel, the table is formatted correctly, and none of the cells contain wrapped text. However, once I paste the table into Outlook, the cells with the most text do not fine in the first line, and are automatically wrapped.

I realize this is explanation might not make much sense, so please see here for a picture showing an example of what I mean.

I have played around with nearly all of the settings in Outlook and Excel, but has anybody ever encountered this issue and found a fix?

Thanks,
Andrew

 

[Andrew Poulsom]

Try using Word as the Email editor and use Currency number format rather than Accounting.

 

[Askol]

Thanks Andrew -

Formatting as currency is a good fix for that specific example, but the bigger issue is that it also wraps to the next line with text when the column is AutoFitted.

I am using Outlook 2010, and it is my understanding that means Word should be the default editor.

Any other ideas on what could fix the issue?

 

[Andrew Poulsom]

Sorry, I don't understand. The text in the first cell in your Excel image is wrapped isn't it? With currency number formatting it appeared exactly the same in Outlook (2003).

 

[Askol]

Apologies for the misunderstanding - The issue I'm referencing about it occurring for text entries wasn't shown in my picture.

Please see here for an example of what I meant with regard to pasting text.

 

[Andrew Poulsom]

Yes, I see. That's an issue with Word. After pasting into your EMail, right click choose AutoFit and select AutoFit to Contents.

 

[matangan]

Yes, I see. That's an issue with Word. After pasting into your EMail, right click choose AutoFit and select AutoFit to Contents.

Hi All, I know this thread is a little old but figured it could not hurt to try...

I have (found code online and modified it) a macro to copy and paste an excel table into outlook 2013 email. The code works great except the resulting table in the email is not “auto fitted” and looks pretty bad. Any quick lines of code I can add to have the table “auto-fit” in the email? Something along the lines of selection(table).autofit or similar? Any help would be appreciated!

Thanks!