reminder

Hello everyone, I'm hoping someone can help me with a bit of dilemma. I have a long list of cases that I am working on. I have to be reminded on which ones to chase everyday. I have used conditional formatting where certain cases are coloured which kind of helps, but as the list gets longer...

Hi! new issue came up, previous issue is resolved. However, the Msgbox only display the current data in the cell. if new data is entered in the worksheet, it will still show the previous msg. like for example as shown below. The msgbox will show that reminds your that the letter number 00001...

Hello everyone, I will try to explain again. I'm trying to make a reminder for my letter log and I have more than 1 condition before it includes the letter number in the Msg Box. I have multiple sheet so I need to make the Msgbox appears everytime I click the sheets. I here's my code I...

Hello everyone, I'm trying to make a reminder for my letter log and I have more than 1 condition before it includes the letter number in the Msg Box. I have multiple sheet so I need to make the Msgbox appear everytime I click the sheets. I here's my code I create. The code already works, but...

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

I have written code to send a reminder to outlook based on a date on Col C I have dates and text In Col C https://www.dropbox.com/s/sh4uinn570nd3ds/VBA%20Code%20to%20Generate%20Outlook%20Reminders.xlsm?dl=0 I need the code amended so that where there is either no date or text, the...

Hi, I would like to ask: How do you create a pop-up reminder when a certain cell is chosen but dependent on a value of another cell? To be specific, we have the type of service cell J2. "Transportation" and "Guiding" is part of a drop-down menu and every time they are chosen, there is a...

I have some vba code that creates a reminder in my outlook calendar from data in excel. But I don't have a way of knowing if I already have created the reminder previously. I want to know if someone can help me tweak my code to show me if I already have this reminder set in outlook. The reminder...

Hello All, I have a small problem but I have no idea how to solve this, so I want to send a few emails to one person, just not one by one like in the code, but as package or something. For example: Mail to Mr.A where's assigned a few positions should be send in one mail. In mailbody will...

Ok guys, this might take some time, so please bear with me. Is it possible to create a macro that would run everyday (either automatically or when prompted by me) and resend a reminder e-mail? I would have the outlook message saved in a folder and have a cell on the excel table with the path...

Can some please help....I am working on a short deadline. My table: <tbody> A B C D 1 A gentle Reminder: Your trip is scheduled in two weeks 2 Destination Date Days Reminder 3 Boston 8/18/2018 10 Send Reminder 4 New York 8/18/2018 10 Send Reminder 5 South Africa 9/20/2018...

I recently created a spreadsheet that will notify me of upcoming offsite meetings by two weeks. Here is a partial code With OutLookMailItem .to = MailDest1 .bcc = MailDest2 .Subject = Range("a1").Value .Body = Range("B1").Value I like the subject line to include the...

Good evening from Australia. I'm new to the forum have been told it's a great forum with very helpful members. I require some assistance with a formula for work. Hoping the formula is possible. I have a number of fleet vehicles that I look after and want to get a reminder when services are due...

Hi there, I'm struggling to create a workable macro to send an email reminder when a due date arrives. The headings below cover everything in the spreadsheet. The first part of the code is to email a colleague when the "Date report due" with the information from No./Description and Date of...

Hello together, This is my first post. Happy to be part of this. I have created an excel projectplan including nearly 40 milestone-tabs. My goal is to remind the respective milestone owners via email if tasks are due. Actually, this works pretty good using the code examples of Ron. There is...

I have uploaded CSV files to Outlook Calendars for many years and have previously used the Reminder set to TRUE with a Reminder Date and Reminder Time with no problem. With the latest upload to Outlook 2016 the Reminder field is changed to FALSE with no apparent error. I am uploading three...

Hey Everyone, I wonder if you can help me with some VBA for sending out reminder emails based on cell contents. I have a worksheet that looks like this: <tbody> Role Name Manager Name Manager Email Status Opp Date Recruitment Deadline 1st Reminder Email Sent 2nd Reminder Email Sent Officer...

I need to sort column A thru Z by column B, but only down to the first empty cell, then skip 3 lines and sort the reminder.

Hi- I've watched dozens and dozens of youtube videos and I can't figure this out. A1 and B1 are both formulas based on other cells and if they meet certain criteria they say 'Send Reminder' or they are blank. They pull from other cells so one could be blank and the other not. I want to create...

Hi i have excel sheet with a user form the question: I need that file to open automatically on specific date and time then close again by it self after a while. (to work as reminder). Thanks