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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top