email

  1. 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)...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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 =...
  16. 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...
  17. 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...
  18. 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&...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top