email active workbook

Hello All, I have a code that opens outlook and pulls data from cells to send an email. There are cells that contain a percent sign (%). I want that to be preserved when it transfers to email, but it doesn't. I've noticed it also does that with the ampersand(sp?) sign. I realize these are...

Hi there! I am relatively new to a company that are using macros as part of some key processes, I have been tasked with fixing them whenever there is an issue because my predecessor created the macro, but my VBA knowledge is minimal so any help with this would be massively appreciated! The...

Hello All, First posting here, so apologies if I have missed something. I have an issue with using Excel 2007 to send a defined range of a spreadsheet out as an email via a macro. I use Excel 2007 and Outlook 2007. I can send an email via a macro, but sometimes I get the mail multiple times...

I've written a very simple macro to send a workbook as an email from the workbook. There are 14 workbooks that I applied this macro to. Most of them send fine, but others do not send at all. I've narrowed it down to probably being something wrong in the .to field in Outlook 365. The formula...

Good morning from NZ. I want to automate emailing a report that needs to have files sent with the report. The files are hyperlinked in the report and they are monhly reports. I may have up to 5 files to go with the reprt. Is there a way that I can I can use the hyperlink function to insert...

Hi Hope you can help with this <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> problem! I included a code...

Hello everyone,I'm still having issue with a previous post.I've made the changes to my Macro but I'm getting a invalid procedure or argument error when C9 = "OK to submit". The correct msg box appears when C9 reads "Fields left to complete"When I debugger it shows this line...I've checked it...

Hi All, I am creating a questionnaire for office staff but i would like to create a link or button that will allow the person that has completed the questionnaire to press the button and it will be sent by email to me. Can this be done? We all use Outlook for emails. Cheers in advance. Red

I have the following macro that works fine except for 1 exception - it does not enter any text as the body of the message. How can I edit this code so it includes a message for the body of the email? Sub EmailRDReport() 'Working in Excel 2010 with Lotus Notes Dim wb As Workbook Dim I...

I did this 10 years ago so I admit I am rusty at this but here are what I had in my notes that worked with Excel XP. I am currently using Excel 2010 With ThisWorkbook .HasRoutingSlip = True With .RoutingSlip .Delivery = xlOneAfterAnother .Recipients =...

I found Nate Oliver's code (below) and tried it to send an email, including attaching the active workbook through the workbook using Lotus Notes. It works as advertised, except the workbook doesn't attach. The recipients, subject and body are all fine. I noticed the original post was from 2006...

I have used the code below to Email a copy of a workbook. I would like it to only send a specific worksheet named "JOB FORM". Can this be done. Thanks as always 'Sub Mail_Workbook_1() ' Works in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Outlook 2000, Outlook 2002, Outlook...

Hey Folks, I have a code in place that emails activeworksheet to a specified sender that i use for requesting information. How does a person email a macro enabled workbook to the same email consistently. Might be an easy question for most of you folks. Any help would be greatly appreciated.

The macro I'm using to copy a worksheet to the body of an Outlook email is working fine. Now I want to go to the worksheet ("volunteer list") and copy the email addresses in column D if the value of column A has an X in it then place that group of addresses in the TO: box of Outlook. Could you...

I am trying to email the active workbook but my code does not open OL. I do not want send but proof read it first before sending. I have got this work before but as I am doing something different obviously I havenot got syntax right. I copy a sheet into a new workbook, delete excess sheets...