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
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    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
    Location
    United States
    Posts
    2,784
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    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 DropBox.com 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
  •