email

  1. S

    Excel2010 VBA for reminder Outlook2016 emails, three months before review date

    Hallo, I'm an admin and VBA newbie, trying to send automated reminder emails from Excel 2010 via Outlook, three months before the review date (in Column C). I've managed to send an email from Excel :) But can't get any further, have tried the YouTube videos but am baffled and was advised to try...
  2. T

    Sending Email Using Hyperlink Question

    Hi Everyone, I have came across a function of sending an email using they Hyperlink Function of Excel, the idea behind it is using the following formula as a hyperlink generates an email in Outlook. I am trying to figure out a way to get this feature to work but include a table within the body...
  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. D

    Send/display email through Excel in Outlook

    Hello everybody, I am currently trying to create a macro in Excel that, once you click on it, displays a pre-written message (by me) and then allows the user to send off the email from their own account. Is this possible? Furthermore, I know that you can do something like: Set.subject /...
  5. R

    Command button to send/display email to corresponding email address if condition is met

    Hello VBA experts, I have a spreadsheet that I would like to add a command button to that would populate an email to the corresponding email address, but only if a condition is met (an upcoming due date). I have tried several versions of code, but none have worked so far and I'm also a beginner...
  6. D

    Run-time error "53": File not found - How to fix?

    Hello everybody, I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code)...
  7. D

    Excel notifications by email/warnings inside the program

    Hello everybody, My current excel-file looks like this: I would like to create a macro that, once I click on it, checks if the quantity is less than or equal to the minimum stock. So in the photo, for row 2 where material number "6046100" has a minimum stock of "1" and the quantity on the...
  8. M

    Save a macro file in a new file without the macros

    I am stuck. I need to save the file without macros and attach it to an email/ I cannot get any of your examples to work/ If you have another option, I will take it. Dim OlApp As Object Set OlApp = CreateObject("Outlook.Application") Dim NewMail As Object Set NewMail = OlApp.CreateItem(0) Dim...
  9. D

    Create macro that sends out emails when quantity is less than or equal to minimum stock

    Hello everybody, My current excel-file looks like this: I would like to create a macro that, once I click on it, checks if the quantity is less than or equal to the minimum stock. So in the photo, for row 2 where material number "6046100" has a minimum stock of "1" and the quantity on the...
  10. D

    Convert Excel to PDF before sending out automatically by email

    Hello Everybody, I am currently trying to create an Excel macro that converts my excel sheet into a PDF file and then sends it out by email. My current macro can do this, but it cannot convert it to a PDF file. I tried to merge my current VBA formula with the one here: to convert my excel...
  11. B

    E-Mail address validation (Multiple contacts per cell)

    I am looking for a solution , but starting cell B2 I have a group of contacts to be e-mailed that needs to be checked for proper format. COLUMN A COLUMN B AREA (A1) E-MAILS (B1) Inspection 'test@abc.com; ab@abc.com; abc@abc.com; Machining 'abcd@abc.com; abcde@abc.com; Thanks for any...
  12. D

    (Fast read!) Send out email automatically with attachment through command button

    Hello everybody, Goal: I am currently trying to create a command button in Excel that, when one clicks on it, sends out an email to me with an order that one has entered into Excel. The following link here: Using Excel VBA to Send Emails with Attachments - wellsr.com has a nice VBA code that...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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 =...

Some videos you may like

This Week's Hot Topics

Top