Macro Code to send email

[colinmstone]

I have been reading a lot of different codes that come very close to what I need but not exactly. I have data on sheet 1 that is then copied to sheet 2 with calculating formula to total. If this is over my limit criteria then an email must be sent to the customer. The way I do this now is I open outlook 2010 and input all the email address's in BCC and the body of the email is copied from a excel worksheet. What I would like to create is a macro that will take a yes or no in a column beside the email address copy the body from the sheet that contains that info and send to that email. I appreciate any help on could offer.
Thanks

[john55]

if you search you can find plenty of code for email...try to incorporate this piece of code into yours and see if it helps you.
(in col C type yes or no, if you type "yes" the code displays/sends the email)

Please Login or Register  to view this content.

[colinmstone]

Thanks John,
I will have ago with this and see how it works out.

[colinmstone]

I have edited the code to send the "to" as Bcc this works, however, I have two email address's attached to my outlook program. The first in the "From:" category has a signature attached for every email sent and the second is from another email address and has no signature. This is the one I want to use. I tried to insert the "from:" category just ahead of the "to:" but this gave me a syntax error I changed things again and then I got an expression error so I removed it from the code. I also I'm not sure how to call another tab up with all it's contents in the same work book and insert that as the "body" of the email as this will always be the same.
Hope this make sense.

[john55]

as far as I know "From" does not work, for add the signature please see here http://www.excelforum.com/excel-prog...-vba-code.html
it works very well.
also you can build your signature using html code

Please Login or Register  to view this content.