email worksheet

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

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

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

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

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?

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

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

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