outlook body

Hi all, I've done reading around but could not work out how to do this sadly. I want tocreate a button which generates an email. The body text needs to be populatedby the cell data. I have gone forthis code initially: Private SubCommandButton1_Click() 'Updated byExtendoffice 2017/9/14...

Hi Would be grateful for any assistance with the following: I have a spreadsheet with data on and a submit button, when this submit button is clicked, the below VBA code attaches the spreadsheet and emails the file to the address shown in the to box using outlook. This all works fine...

Hello! I have a code that is essentially copy/pasting excel data to the body of an Outlook email. It works correctly 90% of the time, but I have had some users experience issues with ONLY the headers copying over to Outlook (no input data) and then the Excel spreadsheet data is cleared out. What...

Hi guys, I've been searching on web to find a solution to my problem but have only found variations so far. So I need excel to automatically send an email when a cell in column X changes from "Y" to "N". In that email I need the corresponding row only be copied into the email. So say cell X3...

Reminder Emails via Outlook I'm new at this and been looking around for ages to get the right code and wondered if someone can help please? I have a sheet that I've setup to auto send a email when column "M" has the word "Reminder" inserted by another VBA command. What I want to do is copy...

Hi, I want to create a macro that will send a particular range of data from a sheet (based on number of rows from another sheet) to outlook 2007 with signature. In the below codes, new mail has been generated with signature, but body of the mail is empty and its showing error in the line...

Hello all, I am very VBA challenged and using it to create a simple process of emailing a Named Range in the Body of an Outlook email. I'm using Ron de Bruin's but cannot find the command that will use the Named Range versus the Selected Range. I hope that makes sense, I don't know the...