email worksheet

  1. Small Paul

    VBA to eMail (Outlook) Worksheets Individually

    Hi I have a workbook with a set of data which needs to emailed to a variety of recipients on a daily basis. I have a macro which searches for a 'unique' value on each row and sets up (and names) a new worksheet for each. Each worksheet then needs to be emailed, using outlook, to the individual...
  2. M

    Email worksheet

    Hi, I have been using the code below to email a worksheet as an attachment which is great, but I now want to only email columns A to G, I would also like it to email to what ever email address is in cell H1. if anyone could help I would be very grateful...
  3. M

    VBA Code: Email tab with pasted values

    Hello, I am trying to create a macro to set up an email with the current tab. I found a macro online and edited it slightly, and it works. But now, I want to change the macro so that the tab that is emailed is emailed with values instead of formulas. Does anybody know what code I can add so...
  4. K

    Stop excel from sending email when certain cells are blank

    I have created a sheet with the following macro to email the page in the body of an email to a specified distribution list. Sub Email() 'Working in Excel 2002-2013 Dim Sendrng As Range On Error GoTo StopMacro With Application .ScreenUpdating = False...
  5. E

    VBA: Email individual Sheets to email value in cell

    I want to email each sheet in my workbook (30 sheets) to the email address in cell A1. The email address is different on each sheet. What I have below works for the active sheet but isn't attaching it. Can anyone help?
  6. G

    Macro to send each worksheet in mail attachment

    Hello I have 70-80 worksheets in my workbook, which I need to send to different receipients as an individual workbooks. My codes looks like below:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Sub Mail_Every_Worksheet() 'Working in 2000-2010...
  7. J

    Temp file not saving macros

    Hello! I've created a form for my work colleagues to complete when they want to start a new project. The form is completed by the project leader, then they hit a Command Button and it's sent to the Senior Manager. After the Senior Manager looks at it and approves it, he then sends it on to Admin...
  8. J

    Copying Worksheet to new workbook, naming, saving, emailng, deleting

    Well I spent a while looking for something that would email a worksheet to a specified person when a user clicked a button on a form. I never found anything in this forum that specifically met my requirements, so I was able to piece together a macro that works for me and I wanted to share it...

Some videos you may like

This Week's Hot Topics