vba & outlook

Hello all, I would like to create Outlook reminders based on task due dates in a specific column (in some instances there will be no date). I managed to create a code that works based on pieces of code found in other threads and my own. The code works perfectly and does what I want it to do...

This script creates emails with invoices for customers. The way it does this is sorting by customer name through a list and then adding the corresponding invoice. My problem right now is that, although the script is adding the correct invoice for each customer, it is also attaching the previous...

Hi All, I seem to have hit a brick wall with my code. The main intention of what I am trying to achieve is run a macro in Outlook that saves attachments into a new folder, and the name for that folder and the files need to be based off information in some cells within an excel workbook...

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

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

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

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

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

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

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

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

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

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 =...

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

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

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

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

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)...

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

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