body

I have a very large database that I am trying to certain information and am having a problem doing so because of the size. What I want to accomplish: I would like two things 1) if Column C, F, and G are the same put "Original" in Column H 2) if Column C, F, and G are the same put but already...

Hi Friends, Please, If anyone can help me in this scenario. I have created an email template into excel. When I had build a macro to copy this template to clipboard to copy it into outlook body, it comes with table format. Then I had tried to copy this template through adding a textbox and it...

Hello, I'm using the below VBA to send an email through outlook and was hoping I can get some help on how to bold the body of the email. All I'm finding is how to bold a portion of the body. I would like to bold all of the body. .To = Range("A82").Value .CC = Range("A83").Value & "...

At my job we have our employees that have to take a fitness and body fat test occasionally. I have built a spreadsheet that calculates all the information I need but I am having trouble with a cell that is supposed to grade their fitness score ONLY if they pass the body fat score. I am going to...

I've created a spreadsheet which monitors the daily weights of animals and added conditional formatting so if the cell drops below 20% of their body weight it turns red I have the following formula where it calculates 20% of body weight of an animal =D4%80 that was easy but I'm having...

I currently have code that will send an email automatically once a value is changed in a cert cell see below. I want to include the value from another cell in the body of the email how do I do this? example of what I need. Headers = Date (A2) Run# (B2) Status (C3) 2/2/17...

Exactly as the title says. I have a macro that checks to see if a condition is met in a range of cells, and then sends an email. I want to go one step further and have the contents of the cell to the left of the cell that triggered the macro to be part of my email body. Can anyone help. I am a...

Hello ! Im beginning to get upset against my computer and I need your help! I am generating an email from Lotus Notes with VBA. Until now, I am able to create the email, send it and even include an attachment. However, I would like to have the attachment inserted into the body like: Mail Body...

Hello Please can you help me? We are receiving emails form 3rd party companies which contain information regarding our clients. The information we receive is in the following format: Title: Mr First Name: Gary Middle Name: Barry Surname: Jones I have written the code below (with...

I searched a lot in this forum and on the internet for my problem, but not found it yet. I'm using the following code (found on this forum) for sending a mail through Notes. This code: - attaches a file in the mail, - select/activate the Notes-Memo, - allows the user to edit the body before...

Hi Guys, Can anyone help in getting this code for Excel VBA (Macro) I am trying to write a code which select a particular range in Excel sheets and Paste it into Outlook body in Bitmap Format, I have a lot it in Google, but cannot find a proper code, the one i got is to convert it into html...

Hi all If there are Mac users in this forum I like to share some mail code for Mac Excel with Outlook. Send Mail from Mac Excel I changed the mail function so it is easy to add more then one person in the To, CC and BCC and add also a option to add more then one attachment, Also a example now...

Hi Would someone be able to help with the VBA code to get VBA to send a table of data from excel using Outlook? Eg: how do you get the below table of data (spread across 4 rows and 4 colulmns) into an Outlook email body? Account Water Earth Fire 123...

Hi all, I've been looking around like crazy trying to find a way to send an range from excel via email in the body as an image. Found multiple ways of doing it with either an attachment or HTML but both really wont work for me. The reason html wont work is because I have some formatting which...

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

Hi, I would like to know if it's possible to send my mail by using lotus with a text body via the macro below, Application.Dialogs(xlDialogSendMail).Show _ arg1:=recipient, _ arg2:=" subject" & RegionToGet For the moment the mails I can send to each of the recipient are composed only by...

I have several macros in a workbook to send e-mails to different address groups depending on specific scenarios. The e-mail body text will always be the same. What I want to do is have the body text written in just one single location and not in every macro so that when someone wants to change...

Howdy all- I found the magic macro i needed to be able to send an email from excel by clicking a button, and to populate the subject and body of the email with certain cells. The purpose of my file will be to input the time i'm leaving work for the day, click the email button, and have the...

Hello, Have a macro to pull all of the emails that contain "Tender -" in the subject, into excel as I am needing to extract specific data from the table in the email body. The macro pulls all emails in the specified folder that container replies, and forwards, as well as the tender changes...

I have searched, but just can't get this figured out. Any help would be SO appreciated. I have this code in a sheet. The code is activated by clicking on a button. It all looks great, but I want my email address to be a hyperlink. I've read several solutions, but can't seem to get it right...