1. J

    Automatically email sections of a table to specific email addresses

    Hi All, I work for a manufacturing company and we receive a daily report which looks something like this: I would like to automatically email each recipient their confirmed stock BUT only their data - no one else's. Ideally the email they receive would look something like this: "Hi Pets To...
  2. D

    Need help with creating VBA to parse through emails in thunderbird

    One of our developers at work, created a suggestion box that generates an email of what customers would like to see available in our website. Each of this suggestions lands in my inbox, and I would like a way to create a vba that parses through all the non-read emails within that inbox, and then...
  3. S

    VBA - send email with multiple ranges in body with 'If Target.Value'

    Hi, I am trying to have a VBA to send out an email if when several rows which have a special character in column A, The VBA I have to add this character is : (wingding font for the check symbol) Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.CountLarge > 1 Then Exit Sub...
  4. B

    VBA email based on cell value (cell value is email selected from drop down)

    Hi all - I've been trying to get this to work for several days now. On my first sheet (a data entry form) my email macros work great. On my second sheet I'm attempting to select an email from a drop down list (in one of two columns) and have an email sent to the email selected from the drop...
  5. D

    Table to Outlook mail message missing frame

    Hi! I'm running the popular Excel-to-Outlook VBA code by Ron de Bruin. Granted, this seems like a miniature issue (and it is), but it still drives me crazy. As the code stands, I'm missing the bottom end of the table frame in Outlook (screenshots from Excel table + 2 below from Outlook...
  6. A

    Copying data from sheet into VBA module

    My end goal is to generate an e-mail with specific cell data, based of its value. I have a macro the selects all cells in A:A that are >=14. I want to take this selection and the 2 cells to the right of it, add it to my email body so that it can be sent. I have no idea how to add this data into...
  7. R

    VBA to send Outlook email difficulties

    Hi, I'm trying to use this macro to send an email. Let me try to explain: 1. need email to include default Outlook signature 2. want to be able to multi-task in Outlook When I use this macro, it composes a new email. When the email window pops up, i'm not able to click on any other...
  8. G

    VBA to have open email and allow user to select items to send.

    Below is the VBA I have, I have searched and can't find a VBA to allow myself to open outlook and allow the user to select an attachment(s) by opening the file explorer. Any help would be greatly appreciated. Sub Send() Dim OutApp As Object Dim OutMail As Object Set OutApp =...
  9. P

    send email from excel

    hi this code used to work in the past (open email form drive, filled send to and displayed email ), probably with older version of outlook, excel. now this code exits form sub at myRecipients.Add ws_names.Cells(i, 1) thanks for any suggestions Dim ws_names As Worksheet Dim...
  10. M

    VBA from MS Outlook to copy data from excel file and past it to email body

    Hi! I have excel file which is saved locally in OneDrive folder but is shared within office 365 so can't use VBA. So I need to run a macro from MS Outlook to copy data from the excel file and past it in the new email's body. Here is the whole routine I want to automate: 1) Open the excel file...
  11. P

    VBA to save some sheets as xlxs and some as PDF

    Hi, I am hoping for some help to for VBA code to save some sheets as xlxs and some as pdf. I am using the below code to save all sheets as xlxs with a filename as the name of the sheet within the workbook. Sub SaveShtsAsBook() Dim Sheet As Worksheet, SheetName$, MyFilePath$, N&...
  12. M

    HOW to retrive data from ASP website to excel.

    In cover company whenever any body observed any unsafe act they Write PI card in company Website consisting "Observation" & " Action" he took. Website assign ID to that PI card email to me with only ID & Observation. On some observation I need to reply. Currently I have to copy ID, put it in...
  13. P

    Macro to save copies of 2 sheets with current with current filter and attached to email

    Hi, I am having trouble with a macro to export two sheets and attached to an email. I have two tabs that I need to attach to an email to number of email address' (addresses' can be in cells A1,A2,A3 etc.). I can have the tab names to attach also in cells if needs be. Ideally I would the sheets...
  14. J

    VBA - Updating Sheets and Sending Email to Multiple Recipients

    I am hoping for some help on this one. Looking for a VBA wizard to direct me . I have an email list where the Name/Address/Birthday/Todays Date is noted. On sheet2 I have a generic message. I need to send an email to all of the people on the list with the generic message as a PDF. This part is...
  15. M

    Runtime error 1004 with "ActiveWorkbook.EnvelopeVisible = True"

    Hi all, I am trying to create a macro to send an email via outlook. The code works on my computer but it does not seem to work on another computer, where a Runtime error 1004 is returned. "ActiveWorkbook.EnvelopeVisible = True" being highlighted when I try to debug. Please see my code below...
  16. C

    Email Hyperlink

    Hello: When I click an email hyperlink, it currently opens to the Mail app. Is there any way to have this switched to Outlook? Thanks OJ
  17. Grizlore

    Issue now we have moved to 365 on browser - CreateObject("Outlook.Application")

    Hi All, I have been using this code with success for generating emails, using VBA Set OutApp = CreateObject("Outlook.Application") Our company is moving to the web based Outlook email, Office 365. This causes the code to error Is there code which creates email when using Outlook 365? Any help...
  18. G

    Auto-send email and auto back up at specific time

    Hi, I am trying to create an automated report to be sent out as an email. I need a email created and cells B6:S8 copied into a table and the email automatically sent from a PC. I already have a Macro to take a back up of the information in cells B8:S8 and paste it into the next available...
  19. G

    VBA Email notification

    Is it possible to have an email notification when one of my files is open by another user? I have used MsgBox and With Outmail code before but it was when someone ran my macro. I wasn't sure if it can be done with my file is opened. Thank you in advance.
  20. I

    Macro for VLOOKUP and Email

    I’m looking to createa workflow tool that helps our team identify when a document is ready forreview. I have a preparer column and reviewer column for each item forevery month the task is in (so up to 12 times). If a user enters an “x”in a cell, I wanted MS Excel to look to the cell to the...

Some videos you may like

This Week's Hot Topics