Results 1 to 2 of 2

Thread: Excel code to trigger mail
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2019
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default Excel code to trigger mail

    I've a monthly data base register with 50 plus members. I find few members are not entering data in specific cells or entering data which is out of date (EX: Actual end date is exceeding present date). I need to send mail every time to all defaulters. Please find my requirement below and anyone kindly help me out creating Excel Macro code to create a single tap button to filter all unfilled and over dated entries and send mails which will be available in respective next cell.

    Step 1: Need to filter the cells which was not entered or kept empty
    Step 2: Trigger mail to all filtered mail ids in the respective next column cells.

    Thank you in advance

  2. #2
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    United States
    Post Thanks / Like
    36 Post(s)
    1 Thread(s)

    Default Re: Excel code to trigger mail

    Keep in mind that you know what you are looking at. We don't.

    You would need to provide the present layout of your workbook. The best method is to post a copy of your workbook to a cloud site (like or similar)
    then post the link for download here.

    Be certain to not leave any confidential information in the workbook.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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