exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
Hi
I wanted VBA code to send emails at the click of the button based on the information we have on the excel sheet.
from column A to K we have data
Column A to K is data and on Column J & K has got the email ID Column J will be To and K will be CC
the VBA code has to pick data from the excel sheet copy data from column A to K as per the email id if the same ID has 2 records it has pick 2 records and paste in the body of example Arun@gmail.com as 2 records and vickey@gmail.com has got 2 records so one email each with these 2 records.
and the body of email it should say " As the activity of the below deal is completed, can you please approve it as early as possible? "
I wanted VBA code to send emails at the click of the button based on the information we have on the excel sheet.
from column A to K we have data
Column A to K is data and on Column J & K has got the email ID Column J will be To and K will be CC
the VBA code has to pick data from the excel sheet copy data from column A to K as per the email id if the same ID has 2 records it has pick 2 records and paste in the body of example Arun@gmail.com as 2 records and vickey@gmail.com has got 2 records so one email each with these 2 records.
reference | Value | Des | status | Sup num | Sup na | activity_start_week | activity_end_week | activity end date | Email Id (TO) | Email Id (CC) |
2105029R3ZRE2Q | 3030 | water bill | pending | 2234 | Aarooa | 202119 | 202122 | 01-08-2021 | Arun@gmail.com | gopi@gmail.com |
220220361NIP67F | 1200 | Electrical bill | pending | 2234 | Aarooa | 202119 | 202122 | 01-08-2021 | Arun@gmail.com | gopi@gmail.com |
and the body of email it should say " As the activity of the below deal is completed, can you please approve it as early as possible? "