I have an existing spreadsheet that pulls data from a SQL Server displays it in 4 Columns within Excel:
Symbol LastPrice NetChg PerfRating
ABC 23.25 .50% 1
RTY 19.88 -2.68% 4
XYZ 7.12 .23% 2
UYT 89.45 -.10 3
Since we our user base uses Blackberry's to view this data, I currently use a some basic VBA Macros + VB SendKey commands to copy this information to Notepad and then to the clipboard. Once it's in Clipboard (memory), the senders can paste into their e-mail and send to the intended recipients manually. Why would I past to Notepad you say?.....Since we use Lotus Notes, it was the only way I could retain the column formatting so the information displayed in readable columns on the Blackberry (we don't have the option of using monospace fonts on the Blackberry).
I am hoping to relieve our user from manually updating th query, pasting into Notes and manually sending out. The perfect solution would be they open the spreadsheet, and it sends out the update every hour to a pre-defined set of receipients, on the hour (10:00am, 11:00am, Noon...till 5:00pm). I understand this would be easier if we were just sending an attachment, but I need to retain text formatting. Allso... we have to send in text, so user can immeadiatly see information without opening attachments.
Some of our internal developers are telling me that this is not possible, within VBA/Excel/VB and will require a new .Net application/utility. I want a second opinion before I'm proved wrong.