Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email from Excel

    hi All,

    Its probably an old topic but I would really appreciate some help with this.
    I am trying to use this spread sheet to manage our purchasing requirements .

    I need to get an email sent to the address listed in u2 and v2 , when anything becomes "DUE" in the column Q.

    Subject of the email

    Job no - from cell "A4"
    Component due - from the column U , corresponding to the item that has become "DUE" in Column "Q"

    and the Text DUE.

    Dont really need anything in the body of the email.
    But wouldn't hurt to have the "REQD" date listed in the body.

    Body :
    This is due on on , the date from the column "I" corresponding to the item that has become due.

    I am very new to VBA , any help would be greatly appreciated.

    Thanks
    Kind Regards
    winsomeness
    Attached Files Attached Files

  2. #2
    New Lounger
    Join Date
    Aug 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    all good.

    sorted .
    Thanks
    winsomeness

Posting Permissions

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