Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2015
    Posts
    2
    Thanks
    0
    Thanked 1 Time in 1 Post

    Creating Automatically Generated Emails in Excel When Criteria are Met

    Hello,

    I am trying to create a VBA in Excel that will send an email to someone to notify them that one criterion is met, but another is not. I have browsed the forum for similar postings, and found this thread: http://windowssecrets.com/forums/sho...s-notification

    sdckapr posted a code which I adapted to fit my spreadsheet. It worked once when I manually ran the code, then never worked again. Can someone please tell me how to fix my problem?FGC Invoicing Spreadsheet.xlsm

    This is what I need to happen:

    When I put in a date under Date of Service in the Review Meeting I section, and there is not an Invoice Date, an email is generated to tell someone invoicing needs to be done. When the invoice date is inputted, an email will no longer be generated for that client. I need it to send multiple emails, or even one email with multiple client references, if more than one meeting needs to be invoiced for at a time. Also, there are five different sections within this spreadsheet: Acceptance, Conference, Review Meeting I, Review Meeting II, and Review Meeting III. It would be ideal if there is a way to make the code work for all five sections, so that if any section has a Date of Service cell filled without a corresponding Invoice Date cell, an email will be generated.

    I have attached the spreadsheet. The code I used is under Visual Basic. I would appreciate any help I can get.

    Thank you very much,

    megantheorange

  2. The Following User Says Thank You to megantheorange For This Useful Post:

    diannbaldo@gmail.com (2015-04-02)

  3. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,827
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    Welcome to the Lounge!
    ..now attach your file as promised.

    zeddy

  4. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,638
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Magan,

    Right off the bat, the Workbook_Open event is sitting in a worksheet module. It should reside in the ThisWorkbook module where it will run when the workbook is opened. As of right now, it is lying dormant.

    HTH,
    Maud

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,638
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Megan,

    I think this should do the trick! It will cycle through all 5 sections when the workbook opens,

    Maud
    Attached Files Attached Files

  6. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,827
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi Megan

    my apologies! I didn't see that file link!
    I'm used to seeing attachments at the bottom of the post.

    Maud to the rescue!

    zeddy

  7. #6
    New Lounger
    Join Date
    Feb 2015
    Posts
    2
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi Maudibe,

    The code works perfectly. Thank you so much for your help!

    Megan

Tags for this Thread

Posting Permissions

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