body

  1. D

    Adding images in table with formatting into Outlook using a file picker

    I have pieced together some code using excel as a file picker to add images to embed within subject body. Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting Outlook seems not to have a huge support...
  2. Jyggalag

    Change my email macro to email multiple recipients in different rows

    Hi all! I currently have this setup in Excel: And the code is this: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t543932\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim...
  3. D

    Formula in Excel to display email message with CC & email receiver

    Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...
  4. N

    VBA copy visible cells to email body below text

    Hi All, Have the below code, almost there, but body text is currently going below the copied table and also want to add a signature. Code- to copy visible cells in range into email body.
  5. P

    Emailing from (?) Pivot data

    I'd appreciate some guidance, please. I'm running a dinner where each member can invite guests. I'd like to use Excel as the data source to send an email to each member's email address, with the body containing details of each guest (name, diet, confirmation etc). I've created a pivot table...
  6. J

    Email 'Do It All Super' Button

    Hello! I would like to send an email from excel that has a pre-populated body of text that but also pulls some data from an excel sheet to populate parts of the email. So for example, you would click the macro....a prompt would ask for a row number and based on that, the email box would pop...
  7. W

    VBA split string and add to HTML body with formatting

    Hi all, I am trying to separate string from a cell based on character present and add it after to HTML body. Sample text (all in one cell): <tbody> Need to separate it by ";" and add it to HTML body for better look, like this: Think this is somewhat common problem, but can not find a...
  8. P

    Email BODY error lines all in red

    Hi Please can you help on the code below, this is in my command button but the email body is all in red, please can you help? Private Sub CommandButton3_Click() Dim aOutlook As Object Dim aEmail As Object Dim rngeAddresses As Range, rngeCell As Range, strRecipients As String Set aOutlook =...
  9. A

    Can I use Mailto and body to generate an email that includes working hyperlinks

    Hello, I am new to excel and I am unsure if what I am trying to dois possible. I cannot use VBA/macros for this as our sharepoint site does notsupport macro enabled workbooks. I am using a mailto:formula to create an email, and I have body and subject set up...
  10. R

    Auto save to PDF and email macro

    Hi all, I've confused myself once again and can't figure this one out. I'm trying to figure out the macro to save file as a PDF in the Set Printing Area and attach the PDF file to new email template in outlook so that way the user can write who it's got to be emailed to. And if it's possible...
  11. D

    Table from excel to email body

    i am trying to simply paste a some values from a pivot table to an email body via VBA, i have deployed Ron DeBruin's methodology - RangetoHTML but my organisations blocks the file type this method uses. is there an alternative? Many thanks
  12. U

    VBA to email selected range in body of email and add the same selected range as an attachment

    Hello! I'm hoping I explain this correctly but what I'm trying to do is use vba to send an email where the selected range is added to the body of the email and at the same time add the same selected range as an attachment to the email. I'm currently using Ron de Bruin's "Mail Range/Selection in...
  13. E

    send pre-defined email to email list from excel

    Dear all I have currently a macro which I run to generate a report. Once finished the report needs to be sent to several people. The email list of people, subject of the email and body text are saved under the tab "email" as you can see below I want to also only send the tab named...
  14. 1

    vba to send email using data in fields

    Hi, to those who use vba regularly, I'm sure this is an easy one. I have an excel spreadsheet with a number of columns. I currently paste data into email fields to send. I currently send 14 emails. some emails contain more values than others, example below. First email To D2 Subject "Test...
  15. C

    Mail to be sent from Excel with info from specified columns

    Hi Team I would like to send a mail from excel with the info from - specified columns - Specific email body Please see screenshot - SDA email - that should be To - TL Email - That should be in CC - Reason and INC/WO should be in subject with line "Returned Ticket...... - Email body - "Your...
  16. J

    Document Content to Body of Email

    Good morning, Hoping all you wonderful folks out there can help me, I am trying to find a vba script to open a word document and copy the contents and create a new email message and use the document contents as the email body, is this possible using vba? Thanks
  17. B

    Chart or Pivot Table to be included in the body of email VBA

    Hi, ANy suggestions how to include graph from a sheet to the body of the email in OUtlook 2010?
  18. B

    How to include Pivot Table and Chart in the body of email

    Hi All, Please help me to automate sending of email from excel file. In the body of the email, I would like to include my pivot table and chart from sheet("Graph"). I'm using outlook 2010. Any help will do. Thank you I found an example here but my chart is not showing on the body of the email...
  19. E

    Extract Data to Email Body (from a VBA newbie)

    Hi all, I have a form that staff complete. Cells A1:B6 contains information. I need VBA writing to complete the following: Send to designated email address Subject line to be B1 and B2 (example "Mr Smith 12 May 2019") Copy information from A1:B6 into the body of the email The user should...
  20. A

    problem search in sheet and show result in listbox

    actually i have problem in this code when i searh in textbox1 to show the resault in listbox it gives me the wrong in code https://ibb.co/g94tvXB https://ibb.co/Zc7ydGG https://ibb.co/N67XKwj https://ibb.co/X7XxX9j any body can help me, please

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top