Consulting

Results 1 to 6 of 6

Thread: sending email from excel through outlook

  1. #1
    VBAX Contributor
    Joined
    Jun 2019
    Posts
    102
    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

  2. #2
    VBAX Contributor
    Joined
    Jun 2019
    Posts
    102
    Location
    Has anyone please send reply for my query

  3. #3
    It is the Christmas holiday period. Only odd compulsive characters like me tend to access the forums at this time

    The attached should be close to what you want, though I don't understand your outstanding time scales - you can modify it to give the results you require.
    Attached Files Attached Files
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  4. #4
    VBAX Contributor
    Joined
    Jun 2019
    Posts
    102
    Location
    Dear Gmayor,

    Thanks for your reply. The attached file is working great.

    But one clarification.
    outlook output.jpg

    I change the code with adding tabs for proper alignment of data. But improper alignment of data is displaying on mail body (Please refer the attached image).

    Is it possible to attached this data like table format with borders.

  5. #5
    It is a little more complicated to use a table, but see attached. The code is annotated should you wish to add more columns.
    Attached Files Attached Files
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  6. #6
    VBAX Contributor
    Joined
    Jun 2019
    Posts
    102
    Location
    Dear Graham Mayor,

    First of all sorry for late replying your message.

    Above your attachment is working great. Thanks for your support.

    I need one more support from you.

    I had posted one query on http://www.vbaexpress.com/forum/show...n-hour-reading But i did not get any reply from the forum.

    Can you please support me for my query which is posted on the above link

Posting Permissions

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