Mail body table format from sheet

  • Dear Team,


    I created code for sending mail based on value matched. I want to insert the data to the mail body in table format from the sheet.


    In column BP if it is in service then the contents to be copied from columns C, I & BQ


    and the body format is


    Dear Service Team,

    Please take care of the below list,



    Customer Name Office address Support required
    M/S ACC Ltd Magadi Road The customer has requested to share the Spares catalogue/Electrical Drawing of the M1CR batching plant.
    M/s Vavedha Infra office address support required
    M/s Ramalingm Construction office address support required
    M/s ZIRCON RMC Bangalore The customer has requested to share the Spares catalogue/Electrical Drawing of the M1CR batching plant.



    and another mail to be triggered for the Spares team


    Dear Spares Team,

    Please take care of the below list,


    Customer Name Office address Support required
    M/s Panchami Concrete office address support required
    M/s HI Tech RMC office address support required
    M/s CCCL Infra office address support required



    And also another mail to be triggered for Units Team


    Dear Units Team,

    Please take care of the below list,


    Customer Name Office address Support required
    M/S Shree Concrete Magadi Road The customer has requested to share the Spares catalogue/Electrical Drawing of the M1CR batching plant.
    M/s Tulasi concrete office address support required


    My code is




    Can anyone help me with how to do the above y requirements? My file is attached here for your kind reference

    Files

    • Book1.xlsm

      (38.73 kB, downloaded 7 times, last: )
  • Dear Ray,


    I changed the code and now my mail body is like this


    Dear Service Team,

    Please take care of the below list,

    Customer Name : M/s ZERCON RMC
    Location : Bangalore
    Support required : Customer has requested to share the Spares catalogue/Electrical Drawing of M1CR batching plant.


    Code is


    But it is updating only one row. I want to update all the row details where the service is in BP column.


    Can you help me

  • Dear Roy,


    I changed the body format from table to list and my new code is


    My mail body looks


    Dear Team,

    Please take care of the below customers problem,

    Customer Name : M/S ACC Ltd
    Location : Magadi Road
    Contact No : 8884433993
    Support required : Customer has requested to share the Spares catalogue/Electrical Drawing of M1CR batching plant.

    Customer Name : M/s Vavedha Infra
    Location : office address
    Contact No : 23781623
    Support required : support required

    Customer Name : M/s Ramalingm Construction
    Location : office address
    Contact No : 23781623
    Support required : support required

    Customer Name : M/s ZERCON RMC
    Location : Bangalore
    Contact No : 8884433993
    Support required : Customer has requested to share the Spares catalogue/Electrical Drawing of M1CR batching plant.




    Now the problem is the body content is updating only for service.


    But I want to generate separate mail for another department also.


    Can you please help me trigger multiple mails for different branch