+ Reply to Thread
Results 1 to 2 of 2

Automatically send email when item past expiry date- Power automate?

  1. #1
    Registered User
    Join Date
    05-24-2023
    Location
    Scotland
    MS-Off Ver
    MacOS, Version 16.73
    Posts
    3

    Lightbulb Automatically send email when item past expiry date- Power automate?

    Hi, I was wondering if anyone knew how to create an automated email that is sent to staff when an item is past it's due date. My columns are Description, Cat, Lot, and ExpiryDate. I know power automate may work but I haven't had any success yet and I think the issue may be that there are some cells in the expiry date column that are blank. I can't fill these in unless there is a specific date, is there anyway around this, so it ignores the blank cells? I would be really grateful for any help!

    Thank you
    Last edited by brodiej; 05-29-2023 at 11:52 AM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Automatically send email when item past expiry date- Power automate?

    Attach a sample workbook and we will see what we can do.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help: Send email to people where expiry date is missing in column H & I
    By A9kurs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2021, 12:51 AM
  2. VBA code to send email automatically to ownself of expiry of license/insurance/ others
    By surazshrestha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2016, 03:08 AM
  3. Replies: 19
    Last Post: 06-03-2016, 11:29 PM
  4. Send email from Excel based on expiry date approaching
    By kordon in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-19-2015, 11:55 PM
  5. Send an auto email if the expiry date is 1 month away
    By jy7788 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2013, 11:29 AM
  6. Replies: 5
    Last Post: 02-22-2013, 02:00 AM
  7. Need to send email to user on expiry date to return book
    By saleha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2012, 06:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1