body

  1. O

    CDO Email, specific cells in the body

    Hey all! Is it possible to send email through SMTP server using CDO (no Outlook!) and insert specific cells in to the body of the email? I have functioning macro for sending emails, but I strugle with the body content. I would like to insert specific region in to the body of the email. Cells...
  2. G

    macro in every workbook - Personalize

    Can i run my macro in every new workbook. or in already existing workbook. Can any body help in personalize? Thankyou
  3. C

    Pull Specific Data from Outlook body 2016 and Export to an Excel File

    Hi, I have tried several scripts (and modified them) but I seem to be missing something. I would like to export, from a specified folder in Outlook, specific body items. This is from the body: SM Form 2018-05-11 11:19 AM was submitted by Guest on 5/11/2018 11:19:03 AM (GMT-05:00) US/Eastern...
  4. S

    VBA code to Email excel sheets as an attachment to different people

    Hi everyone I have an excel file with several sheets and i want to send every sheet as an attachment to certain people in to and cc in outlook .recipients are different for every sheet and I want to add subject and body of email too.( I want email to be ready with To CC Subject and body and...
  5. S

    Creating a Name to Time to populating a calendar formula

    Greetings! So I am currently working on a project at my job. It is something that I can do by hand, but requires a tedious amount of time. I'll try to explain briefly and then I need help figuring out how to use formulas to make this easier. We create hot rods from the ground up. We have...
  6. J

    VBA to get file path and active worksheet then create link to it

    Good morning, Was looking for some help on this small project. I have macro with code that open up an appointment in outlook, but I am looking to auto generate a link to the current worksheet they are in, in the body of the appointment. That way when the appointment comes up they can simply...
  7. Z

    Outlook Macro to move / delete e-mails that contain certain text in an attachment

    Is there a macro that can scan over the context of an e-mail attachment on arrival and delete / move it to a certain folder if it contains it? in a previous thread, i mentioned i receive about 200 emails a day with Text files attached (nothing in the body of the e-mail, only the attached text...
  8. D

    Help with message format

    Hi, I want to be able to create a message body for email on a worksheet, which includes hyperlinks. What would be the best method? I'm currently using a Textbox on my Excel sheet to create the body of an email message - example below. I use the 'shapes' object code below to get the text...
  9. M

    Add Email Body Text - Excel/Outlook 2007

    I have trhe following code to create an email, add a subject, body and attachment but the line to add the body text is causing an errorSet objMail = objOutlook.CreateItem(0) With objMail .To = strEmail .Subject = Range("Admin_EmailSubject") & " - " & strMonth .Body =...
  10. N

    email through excel

    Hello All, I am struggling with my email macro. I found a great one online that attaches a worksheet as a PDF as I need it to, but cant get the body right. I need certain items in the body to be bold and underlined. After doing some research it seems the only way to accomplish this...
  11. M

    vba check before sending email if attachment is present

    Greetings, I found this code online and it's not working for me :( (Outlook 2016) I have set all macros to allow in the trust center and inserted the code inside Developer-visual basic-this outlook session. ' Declare a variable to save the body content. Dim strBody As String ' Conver the...
  12. F

    Sending multiple charts in in an email body with a macro

    Hi there! First post in here, so please bare with me :biggrin::biggrin: I am looking for some help to make a macro that sends multiple charts within the email body. Alternativly, convert a specific range into a PDF (that contains my charts), and send that as an attachment in an email. Any...
  13. P

    Putting Excel table in Outlook MailItem using VBA

    Hi, The following Excel code drafts a simple email in Outlook: Sub testerrrrrrrrr() Set myItem = Outlook.CreateItem(olMailItem) myItem.To = "a.b@c.com" myItem.Subject = "Test" myItem.Body = "Two words." myItem.Display End Sub I have a table in Excel (it's a calendar) that I...
  14. D

    Macro to add text to the body of an email

    Hi Folks The amount I know about writing macros could probably be written on the back of a postage stamp so please bear with me Everything I've ever created has been copied from various websites and through a process of substation, trial and error I've eventually got it working. I've got the...
  15. R

    Need Iteration formula by index and match function

    Hi Every one, I had one very good and almost accurate excel formula for calculating a specific value by index and match function. I lost my external hard drive and that formula too. Can body body help me to do that formula again as I almost not working on excel over two year and above. What I...
  16. X

    VBA - Email multiple people with different attachments

    Hi All, This is the first time I'm posting on this forum and I'm a Macro dummy right now so I need some help. I have a list of 200+ emails which I would need to send individual emails to as they require different attachment for them. Here is what I have: Column A - To Email Column B - CC...
  17. F

    Automation of email sending from Excel...

    <tbody> NAME (A1) EMAIL (B1) SUBJECT (C1) TEXT (D1) ATTACHMENT (E1) Andy (A2) ah@mail.com Auto email Dear (insert name) Andy This is a sample of the body text to be included in the email message. Signature Attach PDF 1 Harry hj@mail.com Auto email Dear (insert name) Harry This...
  18. J

    Using =if(countif), slow data, and much more fun!

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

    Add hyperlink on a word in textbox

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

    Email VBA

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

Some videos you may like

This Week's Hot Topics

Top