Blackberry Friendly report automated

[Excel_Enthuse]

Hi Guys

Was just wondering if you could help. I currently have to send a small report (about 8 columns wide & 20 rows down) via outlook as a message as opposed to an attachment. This is so my regional directors can read the message on their blackberry.

What I currently do is open a report run a macro, copy a tab over and then I am left with my report. I then highlight this, open outlook do a copy and paste (convert table to text) and off it goes. Was just wondering could this all be done through running my macro?? I easily found code to send it as an attachment but now I really need the code that would do the copy and paste and convert table to text. Any experts out their can help me out?

Much Appreciated!

[Richard Buttrey]

Hi Guys

Was just wondering if you could help. I currently have to send a small report (about 8 columns wide & 20 rows down) via outlook as a message as opposed to an attachment. This is so my regional directors can read the message on their blackberry.

What I currently do is open a report run a macro, copy a tab over and then I am left with my report. I then highlight this, open outlook do a copy and paste (convert table to text) and off it goes. Was just wondering could this all be done through running my macro?? I easily found code to send it as an attachment but now I really need the code that would do the copy and paste and convert table to text. Any experts out their can help me out?

Much Appreciated!

Hi,

Since you've already got the code to add an attachment, just modify it so that an Excel range contains the report in text format, give this name a range, and in the .BODY of the Outlook email refer to this named range, and remove the bit of code that adds an attachment.

You can actually fire up an Outlook session from within Excel which makes the whole process fairly simple.


HTH