Hi all, there's lots of threads in the Software Forum discussing how to extract data from Bloomberg into vba or vb. Just wondering if anybody out there knows whether a vba macro could be used to send a Bloomberg email (with attachment).

I haven't been able to find it either, the conspiracy theory is that if they put the email api in, the users who only use bloomberg as an email system won't need bloomberg anymore... maybe the server api has it

Yes, this is possible. I currently download corporate action, reporting, expiration, etc... information into a spreadsheet. Then I email it to me via SMTP and VBA everyday so I have a heads up on what to expect. This works great.If you wanted to email prices to your customers then this might violate your license agreement. I guess it depends on what you are trying to do.

I can understand that the Bloomberg people would be sensitive to making it somehow easier to distribute proprietary data and such. In my client's particular situation the stuff we want to email has zero to do with Bloomberg other than that is the email system they prefer to use.Marine, thanks for the response. How did you find out about this capability? Is it documented somewhere or did you figure it out yourself?

I needed a simple way to automate certain alerts / information. It took me maybe an hour to put the spreadsheet together initially and another couple hours to get the spreadsheet into it's current form to date. It is usually the first thing I look at in the morning.Email ExampleI think this website offers a very good example on how to send an email via SMTP using VBA. The rest is just getting the Bloomberg data into Excel and wrapping it in error handling and a visually nice format for the email.Enjoy

That you for that interesting resource Marine, it should prove useful to any number of people. But at the risk of sounding a bit thick, I don't think it is related to my particular question. I have previously written VBA code to send an email from Excel using Outlook (or Lotus Notes, for that matter). What I am seeking to do is send an email from Excel that uses the Bloomberg as the email system.

When you send an email using SMTP you do not use Outlook or Lotus Notes, etc... It communicates directly to your email server. In fact you can spoof a co-worker when sending an email via SMTP if the email server is not configured correctly; (95% of the time). Information is logged and IT should be able to trace it back to you so please don't try to do this (my DISCLAIMER). Bloomberg's email system is the same as every other email system. You can send the email to Bloomberg's SMTP server or your own it doesn't matter. Every Bloomberg user has an email address, it's "login name@Bloomberg.net". So use the reference I provided to send an email to the Bloomberg address of the user(s) you want.So you should be able to send an email for "youruser@Bloomberg.net" to "joedude@Bloomberg.net" using SMTP. I believe that is what you are asking to do.

Marine, thank you for your patience. I'm a front office person by experience, only learned what programming I know on a need to know basis and had never even heard of SMTP before you mentioned it below. It looks to be more straightforward than I had imagined. We shall see.