send mail

Hello fellows, im facing a problem with automatically sending email to specific mail recipients. I have a file, where i have in column "F" certain date, in column "G" is the state, if the deadline is met or not (OK/NOK). It would be easy to write a macro for this, but this is, where my problems...

Hi, I have built a basic helpdesk in excel for jobs my company does for its clients. It has got more and more complicated and I am having to learn more about VBA. Since I started using it I have managed to capture more jobs than before therefore we can charge our clients more, now I have been...

I am totally new to macro. pls help me out. I need to trigger an email to be send automatically whenever a result is "PASS" Either by typing in or by external sources. Pls provide me examples on how to write the macro in this situation.

I have code that sends an email through VBA code in excel. I want to test to see if Outlook is open (not everone will be using this on their primary email box) and if not, to open then send the attachments. I have simpliefied the code below, would appreciate it if someone can give me the...

Hi All, I'm going to explain this as best as I can and hope I make sense. :) I have an excel workbook which is a result of a sports survey I conducted. It basically shows who likes which sport, what level they're at, preferred time of play, etc, and their email address. A colleague has...

I need a macro or sub routine to get text for the body of a email using this code Sub SendMail() Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) On Error...

I have added a for/next to this code from a reference on the board. With out the for/next everything works. Add the for/next and it sends the first one only? What am I doing wrong? Sub Mail_Text_From_Txtfile_Outlook() ' Is working in Office 2000-2007 Dim OutApp As Object Dim OutMail As...