send mail

  1. L

    Automatically send email if deadline not met

    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...
  2. C

    Save contact from excel userform to outlook contacts and send email from excel

    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...
  3. E

    Macro to send email from excel when there is a change in cell content.

    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.
  4. S

    VBA code to Open Outlook

    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...
  5. V

    Need to send mail to filtered people

    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...
  6. B

    Mail Body Get Text

    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...
  7. rebelgeek

    Help with stolen code for send mail

    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...

Some videos you may like

This Week's Hot Topics