xoutmail

  1. S

    EnterFieldBehaviour

    Morning all Is there a way that when data is been added to a Userform Textbox and Return is pressed to start a new line that ";" is added to the end of the previous line? The reason i am asking is the data being added are multiple email addresses and when these are added to the new email via...
  2. M

    VBA Code to send email based on cell not working

    Can any please help I have been on this all day and can not get it to do what I want it to do. I have managed to obtain this VBA Code to send an automated email when the cell valve of M12 is greater than 200. Now this code works fine when I manually type a value in M12 greater than 200 and...
  3. S

    Auto email changes to specific cells

    Hello All, I would like an email sent whenever a quantity on an inventory sheet is updated. The quantities are held in column G I'd like the body of the email to contain the corresponding data from the rest of the row in-order to "Showcase" the change. Example Email Body for a change in G2...
  4. I

    Need to repeat VBA code down rows - at the moment inflexible

    Let me start by saying I am completely new to VBA as of today so apologies in advance, I won't have any advanced understanding. I managed to find a VBA code online, in order to help me create automated emails. In essence, the below code is picking up the desired email addresses in cell B2, and...
  5. T

    VBA question - email alerts prompted by cell values

    Hi, I need to have email alerts prompted based on cell values (e.g. when call value is >200 an email alert is triggered). I've used the below VBA code, but it only works when I manually enter into the specific cells. I now need an email to be prompted when the values in the specified cells are...
  6. J

    Create email from excel with good morning/afternoon depending on time

    Hi, Looking to have a button within a spreadsheet that creates an email using outlook. Rather than just saying "Hello", I'd like it to say good morning up until 12:00, good afternoon until 17:00 and good evening. I'd also like to insert a signature at the bottom. Here's what I have so far...
  7. G

    Automatic Email VBA help needed

    I hope this is as easy as it sounds, but I could not figure it out. I am using the following template to automatically generate an outlook email, which seems to be working, what I can't figure out is how to properly reference certain cells in the code. I was hoping to have the mail to address be...
  8. R

    Code to save as in a specific folder and throw into an email as an attachment

    Hello I am trying to make a button that allows my coworkers to save as in a specific folder and email their excel forms from excel but I've run into the problem where the attachment doesn't attach. This is the code I am using, what am I doing wrong? Dim FileName As String Dim Path As String Dim...
  9. D

    Email Alert Excel Using VBA

    Hi All, i'm wanting to create an auto email to be sent from excel when a cell in I equals more than one, kind of like an alert... However i would like this email to include certain cells of information depending on which cell in I has changed. For example if I10 changes i would like cells A10 to...
  10. K

    vba code to only autogenerate 1 email

    I have a code to autogenerate an email if an change is made to cells e11:a33. If I make several changes, I'd only like it to autogenerate the email once. How can I do this? Thanks, Dim xRg As Range 'Update by Extendoffice 2018/3/7 Private Sub Worksheet_Change(ByVal Target As Range) 'Determine...
  11. C

    Value Formula in VBA

    I am looking for a VBA code that pulls a value from a cell into a email, i already have a code for the email, the only two lines i cant fill are what cells to grab the information from. I would like to place a formula in this spot which pulls information from a cell in column C, how would i...
  12. C

    Pulling Information From Spreadsheet to VBA

    Good Afternoon, i am currently running this code Sub Macro1() Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.CreateItem(0) xMailBody = "Hi there" & vbNewLine & vbNewLine & _...
  13. V

    email sent from worksheet value change

    Hello all This piece of code sends out an email if the cell value is above 100 but you have to enter and exit the cell "H7" to activate What I would like is if the cell value changed due to a sum function in that cell so is auto changes then this activate the email is this possible please or...
  14. A

    Sending multiple emails through excel

    I have this VBA script: Private Sub sendEmail_Click() 'Updated by Extendoffice 2017/9/14 Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String On Error Resume Next Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.CreateItem(0)...
  15. F

    How Can I get this functionality for all rows short of coding it for each instance?

    Hey all, I created a script that will auto-generate an email in outlook based upon a cell value in a row, and will populate the email based upon information in that same row. Long story short, I would like to be able to apply this to all rows, or at least to a defined set, and if possible, all...
  16. C

    Automated email macro

    Hello All I am looking for assistance regarding a macro that will run a check on a specific column when the workbook is opened then send an alert email if a cell value is reached. so the macro would check to see if outlook is open, if not open it run a check on coulomb C to identify if any...
  17. F

    VBA to update "from" field when sending an email from Excel?

    Good afternoon everyone, I got some code that will automatically send an email based upon cell value. I got the To and CC fields right, but I cannot get the From field to send from the right mailbox/distro. Anyone know how I can do this? Private Sub Worksheet_Change(ByVal Target As Range)...
  18. M

    Email button with file path

    Hi all, I have tried using the below code to add an Active X button to automatically send an email. I have gotten this to work but wanted to add some static text to the email body along with the file path of the current workbook and was wondering if someone could help? If possible also I’d like...
  19. C

    Attach an Excel 2010 workbook in an e-mail using a "Submit" button

    Hi, I am very new to VBA Code and am struggling to achieve adding an Excel 2010 workbook (or even Active Worksheet) to an e-mail using VBA and wondered if anyone could help? So I've created a form in Excel 2010 which I want colleagues to complete. When they've done that, I'd like them to be...
  20. P

    Pasting cells from multiple sheets into an email help please

    Hi, i hope you can help again beginner at this and still learning :), i havethe code below which i have put in for command button, so when clicked it copiein the cells from a - k and only data that hasi want to do this multiple times heading above the code, but the below isnt helping any chanyou...

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
Back
Top