Excel Table (hidden rows and columns) to copy to Outlook in text?

[Allilue]

OK, strange question but hoping there will be some kind of an answer...

If I have an excel table where I'm summarizing information through filters (so only showing relevant info), I'd like to get this in a format to email where it will be blackberry friendly. So for example, today I have a macro that gets the table in the proper format (so filter on rows, and macro to hide relevant columns) and a macro to copy and paste the result as a picture into a text box. Then the user would copy this (along with other sections of the worksheet) into Outlook. The problem is that this doesn't show up on blackberries well. Is there a way to do this so that the summary table can be formatted into text instead?

Thanks for your help!
Allilue

 

[Allilue]

Just wanted to add...

Prior to the table being summarized, so before filtering on the rows and hiding the columns, the original table is just a list of items, an "X" marked against some, and columns that would have an "X" depending on the item. So:

Item# "X" A B C D E
Item 1 X X X
Item 2
Item 3 X X X
Item 4 X X X X

So rows with items 1, 3 and 4 would show (item 2 hidden) and column E would be hidden as no X's are under there at all. There's no need to do the filtering or hiding of columns at all - that's just the way I thought it could be done, but again doesn't work for the copy/paste into email well. Maybe an alternative would be to leave all cells unhidden and have lookups (or whatever) to show:

Item 1 - B, C
Item 3 - A, D
Item 4 - A, C, D

This way it will just be plain text in an email so any blackberry user could read it.

Sorry for babbling...

 

[Gavona]

I don't know about Blackberries but...
If you hold down the Shift key then you can choose Edit, Copy Picture. no need for a text box.
If your email format is plain text then I am suprised that simple copy paste doesn't work.

Gavin

 

[SkipVought]

Just a simple PASTE in Outlook, just shows VISIBLE rows and columns.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Allilue]

thanks, all makes sense, but copying and pasting a table into Outlook is not blackberry friendly. So looking more for a method of getting the info into Outlook, without pasting, so that the information is transferred in some way as text?

 

[SkipVought]

Edit > Paste Special...

then choose unformatted text

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Allilue]

yes, this works but the text would be all over the place. I'm trying to find a way to do this that will probably take complex formulae and not a copy paste job. Sorry, maybe i'm not explaining myself well enough...

 

[SkipVought]

try Formatted Text (RTF)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Gavona]

From what you have said you are using macros so why not:
Select the "A column" and Use Edit, Replace to replace X with A
Repeat for the other columns
Add a new column that Concatenates the others
=A2&" "&C2&" "&D2&" "&E2&" "&F2&" "&G2
OR
=SUBSTITUTE(A2&" "&C2&" "&D2&" "&E2&" "&F2&" "&G2," "," ")

Gavin