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

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