View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
freddie mac freddie mac is offline
external usenet poster
 
Posts: 1
Default Sending automatic email + Bloomberg


Hello! I have a thing that I want to do but I do not know if this is
possible. I have a spreadsheet on a Blommberg PC that has Excel. I
download prespecified data from Bloomberg to the spreadsheet at a
certain time once every day. The data that I am dowloadning to the
spreadsheet is different ratings for different banks. Now I want to
send out an email (automatically) if a rating has changed. In this
email I want to show:

1) what bank has a new rating
2) what the old rating was
3) what the new rating is

I use the DDE to connect Bloomberg to the spreadsheet and this works
fine. Now what I do not know is how (if possible) you send out en email
if any rating has changed. Is this best done from Excel or Bloomberg?
Any assistance is very much appreciated. I can post some more detalied
info concerning this at request. Thank you very much for your time.


--
freddie mac
------------------------------------------------------------------------
freddie mac's Profile: http://www.excelforum.com/member.php...o&userid=36101
View this thread: http://www.excelforum.com/showthread...hreadid=560577