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...
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...
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.
'Working in Excel 2002-2013
Dim Sendrng As Range
On Error GoTo StopMacro
.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?
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>
'Working in 2000-2010...
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...