email body

I have an excel sheet which creates an email when clicked. Currently the body of the message only shows the row where the data is (the recipient will need to know the row to complete other tasks required) I would like to add more text to the body of the email as well as a hyperlink to the file...

Please Help! I included a code for send emails on button click with multiple cell values which comes in column A and B. These column are selected using dynamically generated checkboxes. I’m able to create dynamic checkboxes but I failed to retrieve the cell values to a variable. While I’m...

I have an Excel sheet that I use as a mailing automatism for reports. As it currently is it attaches an actual copy of the excel workbook to the email and send them out. The mailer contains several different people, and they get different report each day. Due to the size of some of the files...

I am trying to send a multiline email using a macro in Excel 2011. The problem is that it isn't sending a separated lines it just ends up all bunched together. Can anybody give me any help? This is what I have right now Sub MailBody() 'Generate Email Address emadd = "" & UserName &...

Hello, I am trying to find a way to send an email from excel (no attachment needed just text), but it needs to send from an alternate email address than the one that I would be using in Outlook or Apple Mail. I created one that works on Windows by sending it with CDO, but the same code doesn't...

Hi There, Not sure if this is the correct place to post this question, but hopefully someone can hel me out. Every day I get a system email that confirms the upload of a bulk SMS file to an FTP server, from where another company will collect it and send out the SMS's throughout the day. The...

I hate to keep posting the same stuff over and over, but I need someone that has done VBA coding that can look at some VBA code that I got from this website to see what I'm doing wrong trying to extract 5 pieces of information from each Email Body to a separate column in a spreadsheet in either...

Hi there, i was write a script on a stationary inventory sheet. This file has a sheet where the user can fill in a request for stationary and i have a sheet with the list of stationary in column A and quanlity required (no.) in column b what i want is a script which can insert this array...

Hello, I am using the following code from Ron DeBruin 'how to email site' and I would like to add a message to each email. Any help is appreciated. thanks much this what I am using - but I do not know how to add message: Sub Mail_sheets() Dim MyArr As Variant Dim last As Long Dim...

Hello, I'm looking for code that will create an email using data from column 1 as the subject, and the data from column 2 as the body. There are multiple rows, but it would create and send a single email from each row. It would iterate through all the rows and all of these emails would be sent...

Hi, It appears someone else has posted a similar question regarding this but not received a solution: http://www.mrexcel.com/forum/showthread.php?t=588628 Perhaps I can elaborate on the issue at hand. I am using code written by Ron de Bruin in order to send a table I have created in Excel to...

Hello all, I am using Ron de Bruin's VBA to send workbook as attachment. I want to include a range in the body, however, I cannot get it to work. I am using the following statement in the body: .Body = Range(R23:V49).Value Here's the full Destwb ---------------- With Destwb...