TRIGGER

We do a daily report on excel but I have found some people cant read it either as an attachment or direct email from Excel. It is made up of mainly text (but needs to be done in Excel for annoying reasons). Does anybody know a way to copy it across to word or similar with formatting in place so it can be sent as a text email ?

DJ Dunk

iTrader: (5)

You can do File, Send To, Mail Recipent (Not as attachment), then select Send The Current Sheet As The Message Body

This any good ?

DJ Dunk

iTrader: (5)

Then when you get it back, just select Edit, Edit Message to return it to Excel.

TRIGGER

Thanks for that - but unfortunately this is what I am doing for most people but one client doesnt run Outlook and when it comes in this form is runs to pages of garbage. So somehow it needs to be in a text format - any further ideas ?

Fosters

Can't you save in .csv format. you can then send that (it's a text file afterall)

DJ Dunk

iTrader: (5)

Or how about saving it as a webpage with an embedded interactive spreadsheet ?

fast bloke

Have you tried saving it as comma delimited text. The recipient then opens Excel and specifies the file. It will work it out and import it into the format you had initially