Consulting

Results 1 to 6 of 6

Thread: sending email from excel through outlook

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Contributor
    Joined
    Jun 2019
    Posts
    155
    Location

    sending email from excel through outlook

    Dear Team,

    I need code for sending email from excel through outlook.

    My condition is,

    I am having outstanding data's in Sheet1 ( Customer Name, Inv No, Date, Outstanding Amt, Location , Equip, Product, M/c. Sl. No, Service Engg, No. of Days Pending)

    Service Engg name and email ID details in Sheet2

    When i am press the Send Email button, first it should ask to select the Service Engg name.


    Once I select any Service Engg name, that particular engineer name should auto filter and copy all data's with heading(Customer Name, Inv No, Date, Outstanding Amt, Location , Equip, Product, M/c. Sl. No, Service Engg, No. of Days Pending) which is more than 30 days and send by email.


    Email Title: Service Payment outstanding details
    Email Subject : Dear Engineer,
    Pls find the updated service payment outstanding details for your reference. Kindly contact with customer and try to cleat the payment as soon as possible.
    And paste the data's here

    I am attached my excel here for your reference.

    Kindly do the needful.
    Attached Files Attached Files

Posting Permissions

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