body

Hi, I am building a code where mails will be send automatically from excel according to felds. Like email ids will get seleced from cell B2, CC from C2 and so on.. i have finished some part of it the only issue is that i want snapshot of the table mentioned in another tab (Table). We can...

In Excel, I have created a sub that creates an e-mail in Outlook and adds some text in the body. In particular, I have text which is a location, such as: C:\MyLocation\MyFiles\ The problem is this is displayed simply as text. I want it to be hyperlink. Can it be done with VBA from Excel...

Hi, I have followed the code set by Ron de Bruin below https://www.rondebruin.nl/win/s1/outlook/bmail2.htm i now have two modules. One will create an email with an attachement, the other will create an email with a range from one of my sheets pasted into the body of the email. For some...

I have workbooks names in Col a on sheet1 that are .xls files if not specified eg M_BR1 Sales (P). M_ERT Sales (P) Etc I have specifiedthe .xlsm files eg M_BR3 Sales (P).xslm I have code below to create an email in outlook and to attach the sheet "summary", which works perfectly where...

Hi, Good Day guys! I need help on the code for sending an email (item.display instead of item.send). I want to have the TO CC and Subject ("Portfolio Dashboard Red and Yellow Report" + a prior specific date included (ex. Portfolio Dashboard Red and Yellow Report 27-2-2019) reflected as well...

I want to do as the title states. Print a certain range as pdf and send as attachment with a choice of a body. Can someone help me ? Thanks YM

I have a large text file I want to extract the email headers from. Every email is different, and there is no standardized way the data is organized. Let's say headers run for 2 -10 rows but they are all random and all different Let's say the largest sized header is 10 lines Each email has a...

Hi all, I have an excel sheet that performs some automatic tasks, one of them is creating a string that contains a HTML formatted text that contains the body of an email and then sending it via email. I'd like to have the possibility of showing the formatted result of the email body generated...

Is it possible to insert a hyperlink with a friendly name in the body of an Outlook message without using HTML? I have a range of Cells that contain web addresses and I want to be able to add them to the message body but with a friendly name is possible to cut down on the body size. The reason...

Hello, I have taken on a new role and have never used VBA before. I can absolutely see that using VBA to automate some of the more repetitive tasks my new team do would be a great thing for me to do. There is so much information on these and other boards and sites that putting together what I...

Hi, I wrote a VBA Code to send a mail to the recipient based on a criterion. My next step is a bit complex and I am not sure how to proceed. Problem: I have a criterion, passing which, a mail will be sent to a recipient. But there shall be several instances where the criterion is TRUE and...

I am using the code below to email my xls info in the body oif the email. I would like to be able to add some text before the data. Addionally I would like to specify what email address it is sent from and to use that address outlook signiture. Can anyone help? Sub SendSelectedCells() 'Copy...

Here is a portion of the macro I am using to email from a worksheet. Everything works fine except when I try to add something to the Body of the email it is replacing the portion of the email with the data from excel. I am trying to add a predefined message in the body and then add the excel...

My sheet contains hundreds of invoices that are separated by numbers in the first column. ex. A B C D 1 Beginning of New Invoice 1 Body Of Invoice 1 End of First Invoice 2 Beginning of...

Hi Everyone My first post, I'm new to VBA but have got a lot of help from this site from articules already posted, but this is the first time I cannot find what I'm looking for hence the post. I'm using Winows 10 64bit with office 2016. I have an excel file that I'd like to create a task from...

HI, Working on a macro and need help. Just trying to paste this range below into the body of an email in outlook. I already copied range opened email with vba. I just don't know how to paste this below into body of email. As I can not record it see the outcome. Range("B4:H11").Copy Thanks

Hello, I was attempting to generate an email with an HTML body using a bootstrap CDN I noticed the bootstrap was not being recognized. Is there a way to achieve this or are external CDN's not allowed in the HTML body of the VBA code. Thank you

Hi, I have a sheet with data points and another reference sheet with the different ways to write different body parts. The idea is to see which body parts/ appear in each data row, but because there are multiple ways to say the same body part, I have put the different variations of body part...

Hello, I need to send out a standardized email, but I need to change a few fields within the body of the email to reflect names specific to the recipient. It's pretty simple, but I can't find anything specific to this case. Example: Hello _______, Here are your login credentials: Username...

Hi all, I have a macro that creates multiple emails and copies a powerpoint slide into the body of each email using the "Getinspector.wordeditor" function. Im now trying to resize (make bigger) the slide that gets pasted into each email body. Any help would be greatly appreciated! Thanks...