Excel table format lost in Outlook

Status
Not open for further replies.

LarryK

Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
I am coordinating a high school car pool schedule and I'm using Excel to hold the rows and columns in a presentable format. Each week I update which parent is driving to/from school, on what day, students to pick up, etc. I then highlight the range of cells, Copy, then Paste into the message body of Outlook. The distribution goes to approx. 15 parents and students. The problem is when I view the message on my Android cell phone- All the Excel formatting (borders, font style, bold, etc) is gone and the text which was in separate columns is now stacked vertically in one column. Since I send a copy to myself it looks just fine on my desktop, just messed up on my cell... Before you think its my cell phone problem, last year another parent did the same format and method and I was able to receive his emails on my phone with the proper Excel formatting... But IF I forwarded that car pool schedule from my desktop Outlook back to myself, the format on the phone was screwed up as noted above. I have had one other person who occasionally receives regular (no formatting) emails from me complain that she receives my text stacked vertically which is very hard to read. Hope someone can determine whats wrong. MS Office 2010 Professional 64 bit. Win 7 Home 64 bit.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
It could be one of several things - the message is sent as plain text and lines are wrapping on the droid; it's being sent as RTF, the tables are fixed width. The missing formatting is symptoms of plain text and RTF - either it was sent as plain text or as RTF and the TNEF data is not available (RTF formatting is in the TNEF data)

Which paste format are you using? Excel 2010 has a command under customize ribbon / commands not in ribbon called "Mail Recipient". That adds a email header to the work sheet and you can send directly from Excel, no pasting. I'm not sure it will fix your problem though.
 

LarryK

Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
I am using copy/paste method with Clipboard. I forgot to mention is on my Android I see an attachment called winmail.dat and then the stacked text. Clicking on the attachment comes back with a message that the phone cannot open the attachment. So is that a problem with the phone (missing an app ?) or something that Outlook is sending out in error?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
that means the message was sent using RTF format - only outlook can open it. the formatting is 'hidden' in the winmal.dat. You need to make sure you are using HTML format, not RTF.
 

LarryK

Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
Diane, From your last reply, I'm not sure what needs to be changed from RTF to HTML.... While investigating, I found the following current settings in Outlook Options... MAIL> Compose Messages> "Compose messages in this format" HTML (this was selected) MAIL> Message Format> (the following selections were checked): Use Cascading Style Sheets for appearance of messages; Reduce message size by removing format information not necessary to display the message; (and) Remove extra line breaks in plain text messages. the last setting "When sending messages in Rich Text format to Internet recipients: Convert to HTML format is selected.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
right click on the email address of an affected user in contacts and choose Properties icon (looks like a sheet of paper) then choose Outlook properties. You'll get a properties dialog like this:

address-format.png

What does it have for the internet format? RTF here will override other settings. I would try deleting the affected names from the autocomplete list (or the contact group name, if you are using a group) - previous use of RTF will be remembered in the autocomplete cache. If you ever sent a voting message or possible a meeting request (and don't have the option set to use icalendar for internet address set in calendar options) the autocomplete file could be using rtf.

See Outlook is sending winmail.dat and especially the reg method at the bottom.
 

LarryK

Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
right click on the email address of an affected user in contacts and choose Properties icon (looks like a sheet of paper) then choose Outlook properties. You'll get a properties dialog like this:

View attachment 776

What does it have for the internet format? RTF here will override other settings. I would try deleting the affected names from the autocomplete list (or the contact group name, if you are using a group) - previous use of RTF will be remembered in the autocomplete cache. If you ever sent a voting message or possible a meeting request (and don't have the option set to use icalendar for internet address set in calendar options) the autocomplete file could be using rtf.

See Outlook is sending winmail.dat and especially the reg method at the bottom.
Diane, THANK YOU !! That solved it. Not really sure how that setting got changed but it was *my* email address that had RTF set on the email properties, so it affected any email copies I sent to myself as To: CC: or BCC:
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D Paste Excel table into Outlook message Outlook VBA and Custom Forms 7
M Download Outlook Meeting Attendees into Excel or other table/database Using Outlook 3
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 4
N Extract Outlook emails to excel Outlook VBA and Custom Forms 2
M Extract all links from Outlook email, send to Excel Using Outlook 2
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
C Pull Outlook shared calendars items from Excel Outlook VBA and Custom Forms 4
S How to export urls from email to excel and check the status of the url ? New Slipstick.com Articles 6
S save email from excel Outlook VBA and Custom Forms 1
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
E Accessing shared outlook folder doesn't work since switch to new outlook/excel Outlook VBA and Custom Forms 11
E Copying the whole e-mail body into excel Outlook VBA and Custom Forms 0
E Copy e-mail body from outlook and insert into excel Outlook VBA and Custom Forms 3
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
S Find a cell value in excel using outlook vba Using Outlook 1
K Update Appointment category when changed in Excel Using Outlook 3
A Script to fetch data from mails in restricted collection and sending them to excel Using Outlook 1
J Outlook 2013 Extract Flag Completed dates to Excel Macro Outlook VBA and Custom Forms 16
D Retrieving Tables from outlook to excel Using Outlook 14
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
nathandavies Email Details to Excel & Save as .MSG on one macro - combination of 2 macros Outlook VBA and Custom Forms 3
N Export details to a excel spreadsheet using macros Using Outlook 0
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0
T Outlook Calendar 2016 import Excel Using Outlook 1
D Macro sending outlook template from Excel list Outlook VBA and Custom Forms 6
N Lookup Value From Excel and Reply With Matching Value Using Outlook 0
D send email from Excel using outlook template Outlook VBA and Custom Forms 3
Diane Poremsky Importing Lists from Excel to Outlook New Slipstick.com Articles 0
N Paste content to Excel when .txt file (attachment) is opened Outlook VBA and Custom Forms 1
R Macro to copy email to excel - Runtime Error 91 Object Variable Not Set Outlook VBA and Custom Forms 11
M Creating Outlook Appointments from Excel Cells Outlook VBA and Custom Forms 1
M Linking Excel Cell to Shared Contacts Outlook VBA and Custom Forms 7
H Macro to Copy Specific content from Mail Body and Paste to Excel Outlook VBA and Custom Forms 4
R Exporting Excel data to Outlook 2016 Calendar Outlook VBA and Custom Forms 20
K Macro to search emails between two time slots on public folders with excel export Outlook VBA and Custom Forms 12
Diane Poremsky Use a macro to copy data in Outlook email to Excel workbook New Slipstick.com Articles 0
A How to export one email data to excel Using Outlook 1
W macro to export outlook emails to excel Outlook VBA and Custom Forms 6
B Importing Text from Excel to Outlook 2013 Calender Using Outlook 0
A Populate Excel from Outlook Userform Outlook VBA and Custom Forms 3
B Import Excel Text into Outlook Calender Using Outlook 4
J Outlook Macro to Update Sharepoint Excel File Using Outlook 1
K Extract email to excel from a specific sender Outlook VBA and Custom Forms 3
C Copy email to excel runtime error 5020 Using Outlook 5
O VBA to extract email (fields and body) to Excel Outlook VBA and Custom Forms 14
P Selecting specific calendar from Excel Outlook VBA and Custom Forms 5
D calendar to excel spreadsheet Using Outlook 1
X Outlook script to run excel data Outlook VBA and Custom Forms 1

Similar threads

Top