Board logo

Outlook data problem
ReMan - 2/9/11 at 08:23 AM

Any outlook experts, I'm qite new to it, having just migrated from another programme.

As per the pictuire, I copy a bit of an excel into a outlook 2003 email and send it.
When it is recieved the reciever cant select just Col 1 data, the selection picks up all rows and columns.

This is part of a bigger issue around building new blank template emails for completion, but at it's most basic level, if I can fix/understand this bit I may be able to move that forward too.

TIA

outlook
outlook


blakep82 - 2/9/11 at 08:27 AM

looks like it selects the data the same way as it would with text. i haven't used outlook for ages, so i assume it treats it as text.
you might have to save the excel file and send the file as an attachment, for the recipient to open in excel?


rb968 - 2/9/11 at 10:34 AM

This is in Outlook 2007 but I am sure is relevant to the previous version.

You can insert a spreadsheet into a new email.

Go to Insert > Table and select Excel Spreadsheet from the list. It will insert a sheet and you can paste the cells you have copied into that.

Spreadsheet in email
Spreadsheet in email


Not sure how that will work with template emails but my two penneth!

Rich

[Edited on 2/9/11 by rb968]


ReMan - 2/9/11 at 07:57 PM

Thanks guys, no good though
It startsd well embedding the excell, but the recipient gets it as a .bmp and cant edit it