Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Office 2007-Source formating lost when emailing from excel

When emails are sent from Excel using outlook the source formating does not
transfer through to the email when the excel sheet is sent in the message
body. Columns become oversized and flow off the page.

We did not have this problem with office 2003. We could email excel sheets
with outlook and the formating was exactly like it is in excel. I have made
sure the settings are all set to keep the source formating but it does not. A
copy & paste from excel to outlook 2007 also loses its formating.

Any solutions?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Office 2007-Source formating lost when emailing from excel

Hi csi.sec

Can't reproduce this on my machine
do you have this problem with all workbooks ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"csi.sec" wrote in message ...
When emails are sent from Excel using outlook the source formating does not
transfer through to the email when the excel sheet is sent in the message
body. Columns become oversized and flow off the page.

We did not have this problem with office 2003. We could email excel sheets
with outlook and the formating was exactly like it is in excel. I have made
sure the settings are all set to keep the source formating but it does not. A
copy & paste from excel to outlook 2007 also loses its formating.

Any solutions?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Office 2007-Source formating lost when emailing from excel

in borders set the gridelines to print for a full page. Make the first 6
columns 3 pixles and the remaining 6 pixels then send a full page to email.
Open the email & do a print preview. On my machine the columns and rows have
grown in size to where I only see about 4 columns out of the 20 I sent

Let me know what you see. If you see what I see then you can see what is
happening to my nicely format emails. I am not sure why they are not
distorterd in 2003 but are in 2007

"Ron de Bruin" wrote:

Hi csi.sec

Can't reproduce this on my machine
do you have this problem with all workbooks ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"csi.sec" wrote in message ...
When emails are sent from Excel using outlook the source formating does not
transfer through to the email when the excel sheet is sent in the message
body. Columns become oversized and flow off the page.

We did not have this problem with office 2003. We could email excel sheets
with outlook and the formating was exactly like it is in excel. I have made
sure the settings are all set to keep the source formating but it does not. A
copy & paste from excel to outlook 2007 also loses its formating.

Any solutions?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Office 2007-Source formating lost when emailing from excel

Send me a workbook private.
I test it for you then

Mail address is on my index page
http://www.rondebruin.nl/



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"csi.sec" wrote in message ...
in borders set the gridelines to print for a full page. Make the first 6
columns 3 pixles and the remaining 6 pixels then send a full page to email.
Open the email & do a print preview. On my machine the columns and rows have
grown in size to where I only see about 4 columns out of the 20 I sent

Let me know what you see. If you see what I see then you can see what is
happening to my nicely format emails. I am not sure why they are not
distorterd in 2003 but are in 2007

"Ron de Bruin" wrote:

Hi csi.sec

Can't reproduce this on my machine
do you have this problem with all workbooks ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"csi.sec" wrote in message ...
When emails are sent from Excel using outlook the source formating does not
transfer through to the email when the excel sheet is sent in the message
body. Columns become oversized and flow off the page.

We did not have this problem with office 2003. We could email excel sheets
with outlook and the formating was exactly like it is in excel. I have made
sure the settings are all set to keep the source formating but it does not. A
copy & paste from excel to outlook 2007 also loses its formating.

Any solutions?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Office 2007-Source formating lost when emailing from excel

After looking at the file

Problem: Merged cells

Seems 2007 have more problems then 2003
As always not use merged cells in your worksheet


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Send me a workbook private.
I test it for you then

Mail address is on my index page
http://www.rondebruin.nl/



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"csi.sec" wrote in message ...
in borders set the gridelines to print for a full page. Make the first 6
columns 3 pixles and the remaining 6 pixels then send a full page to email.
Open the email & do a print preview. On my machine the columns and rows have
grown in size to where I only see about 4 columns out of the 20 I sent

Let me know what you see. If you see what I see then you can see what is
happening to my nicely format emails. I am not sure why they are not
distorterd in 2003 but are in 2007

"Ron de Bruin" wrote:

Hi csi.sec

Can't reproduce this on my machine
do you have this problem with all workbooks ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"csi.sec" wrote in message ...
When emails are sent from Excel using outlook the source formating does not
transfer through to the email when the excel sheet is sent in the message
body. Columns become oversized and flow off the page.

We did not have this problem with office 2003. We could email excel sheets
with outlook and the formating was exactly like it is in excel. I have made
sure the settings are all set to keep the source formating but it does not. A
copy & paste from excel to outlook 2007 also loses its formating.

Any solutions?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Major bug when serving Excel 2007 files through IE? Danny Tuppeny Excel Discussion (Misc queries) 2 January 31st 07 01:03 PM
How to create icon sets for excel 2007 conditionnal formating ? Julien Montserrat Excel Discussion (Misc queries) 1 January 30th 07 05:50 PM
Macros in Office Excel 2007 Macros in Office 2007 - Excel Excel Worksheet Functions 2 July 7th 06 12:29 AM
Excel Range permission , Office 2007 Beta 2 Ali Excel Discussion (Misc queries) 0 June 24th 06 11:39 AM
Lost Excel 2000 VBA help after installing Excel 2007 Beta [email protected] Excel Discussion (Misc queries) 0 June 20th 06 11:42 PM


All times are GMT +1. The time now is 12:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"