vba & outlook

  1. S

    Email individual worksheet as image in Body of text

    Hi, I have a workbook that currently has two sheets, Master and Dash. The Master sheet is data collated from multiple sheets in a folder, then the Dash is a display of this data. The data corresponds to individual people, so what I want to do is create individual new sheets, named after each of...
  2. V

    I want to extract all details form outlook emails in excel using vba according to particular word in subject of email

    Hi Team, I want to extract outlook emails data in excel using VBA according to specific words in subject of email. The subject of emails keep on changing but some part of the subject remains same of all the emails. eg. My email Subject is "Prod - Work Daily Alert for user Steve Johnson...
  3. P

    Excel VBA macro to paste multiple ranges

    Hi, I have found a macro that I was able to modify and use and (sort of) understand, but for the life of me I can't figure out how to do the next step for what I am attempting. https://www.rondebruin.nl/win/s1/outlook/bmail2.htm Above is what I am using - I am using 'find last row' to define...
  4. R

    Create Hyperlink in Excel to open Task imported from Outlook

    Hi All. I have some code to import all non-completed tasks from Outlook into a spreadsheet. My plan is to then put these into some kind of Eisenhower matrix to allow better organising of important vs urgent tasks etc. I want each task to be a hyperlink which will then open the task in Outlook...
  5. C

    EXCEL 2016 Send an email with signature

    I need to compose emails using VBA with signature in EXCEL 2016. I followed an tutorial on YouTube. This is the code I used, exactly same as the youtuber's but it works on his computer, not mine. Sub PrepareEmailNow() Dim olApp As Outlook.Application Dim olEmail As Object Dim sig...
  6. WERNER SLABBERT

    VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi there .... i recently found this thread "https://www.mrexcel.com/forum/general-excel-discussion-other-questions/710212-vba-code-convert-excel-pdf-email-attachment.html" that does more or less what i want in my VBA but implementing it into my Current VBA is no easy feat, would anyone be so...
  7. M

    Extracting Data from folder of EML files when data is UNDER the string signifying it

    I've been mainly working off this code: https://www.mrexcel.com/forum/general-excel-discussion-other-questions/616616-extract-specific-data-folder-eml-files.html as both the folder of eml files and the output are what I want (except I will have more columns). The problem is my EML data looks...
  8. G

    Macro that emails a list of tasks due today

    I'm starting to learn VBA. I've got a list of tasks that are due on various days. They are divided and organized by different departments. What I need to do is scan through the whole range of dates and then automatically send an email with the tasks that are due today. I found some VBA...
  9. J

    Copy and Paste All Values and Keep Original Format of Pivot Tables to Outlook Email VBA

    I am trying to write a VBA code for sending an email of a sheet with 4 pivot tables. These pivot tables are formatted the way the client wants. I am able to copy and paste them to the Outlook email with formatting however: 1) The color of the pivot tables changes from blue to green 2) The...
  10. E

    PDF sent by VBA to outlook as attachment doesnt work/open

    I want to send the worksheet what im working on as PDF in outlook by using VBA, when I test this out it does make an attachment but the PDF file is broken and wont open.. anyone know how to fix this? Sub saveandsend() Dim Path As String Dim filename As String Path = "DIRECTORY" filename =...
  11. S

    VBA code to select the dates and put it in the subject line of the email

    Dear All, I have 3 macros to send emails from the excel. The purposeof the macro is to select the dates in the raw file , which is selected by theuser and send the email. 1st macro does the selection of the datesaccording to the user input. 2nd macro does the sending of the emails (where...
  12. M

    VBA: If Auto filter has no data then it has to move to next filter

    Hello Experts, Requesting you to review my macro. i have tried little bit and i am new to this so please help me out. I want to save the file into two different format based on criteria that i have done. but while filtering if no data for that respective criteria then it has to move to next...
  13. V

    VBA CreateObject("Outlook.Application") ERROR

    hi all, Can I please get your assistance. I have searched various forums and work arounds to try and resolve my issue to no avail. The below code was working on my mac fine and now its generating an error ON THE BELOW LINE OF CODE. Set OutApp = CreateObject("Outlook.Application") The...
  14. S

    VBA Code to create Outlook mail not completing To field after 20(aprox) emails

    Hi, I am using a VBA code to create some emails based on an excel sheet where it gets filtered depending on the email recipient and after creating approximately 20 emails it does not show the recipient anymore. It does display the people in CC which are included in the code, but not the person...
  15. M

    Extract Data with number and Send as email VBA CODE

    HII have inventory Tracking System and What I'm trying to do is create a VBA code that Extracts data if Either of the two conditions is Matched and open outlook Email object to send Email to Purchasing Department.(SEE ATTACHED SCREENSHOT)...
  16. S

    Excel/VBA Creating Outlook Appointments from Spreadsheet Data

    I'm trying to create a macro that will create appointments based on task from column B. For some reason, my code to create appointments is creating each item in the subfolder twice. Also, I'm trying to get the appointment date to be column F -30 days. Ultimately I would like to have this macro...
  17. S

    VBA Excel Setting Outlook Appointments From Spreadsheet Data

    I'm trying to create a Macro to create Outlook appointments based on words in Column B. For some reason, my code to create appointments is creating each item in the subfolder twice. Also, I'm trying to get the appointment date to be column F -30 days. I tried <code style="margin: 0px; padding...
  18. S

    Excel Macro to Auto Fill an Outlook Template Based on Sheet Values.

    I am trying to automate a template in outlook to automatically fill out certain fields based on data provided within the spreadsheet. The spread sheet is called "Progress Report" I want to grab the clients name, which is located in Column A I want to insert the clients membership number which...
  19. T

    VBA macro replying to an e-mail from shared mailbox

    Hi guys <tbody> I'm writing macro that finds and reply to mail from shared mailbox. Everything works with my personal mailbox, the problem is addressing the shared one in the code. I tried something similar to the solution from this question: How to...
  20. E

    Adding an appointment to Outlook 2010 from Excel with VBA

    Hi all. I am trying to use the code below to update my Outlook calendar from an Excel sheet. The code functions fine, but I need to save to a sub calendar rather than my default one. I've tried a few work around's I found online, such as...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top