exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
Hi Team,
I have a data as below and the data starts from row 3. Row 1 and 2 are headers.
What i want macro to do is to create a new workbook for respective user and draft an email with standard text from outlook. In below example for James there should be 2 emails generated because the name is same and the email address is different.
Also if the generic mail id is different then it has to create a new workbook for this generic id.
So the logic will be based on Generic mailid, User and User email and these headers are in row 2
Generic mailid - column E
User - column - H
User email address column P
Data will be until row AZ
Text is - Please go through attached file.
Workbook should be created from row 1 till the end of the data.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thanks
I have a data as below and the data starts from row 3. Row 1 and 2 are headers.
What i want macro to do is to create a new workbook for respective user and draft an email with standard text from outlook. In below example for James there should be 2 emails generated because the name is same and the email address is different.
Also if the generic mail id is different then it has to create a new workbook for this generic id.
So the logic will be based on Generic mailid, User and User email and these headers are in row 2
Generic mailid - column E
User - column - H
User email address column P
Data will be until row AZ
Text is - Please go through attached file.
Workbook should be created from row 1 till the end of the data.
ID | From | Date | Country | Generic mailid | Contracter name | Activity | User | Reporter | Form | TAT | Days | Form | TAT | Days | User email |
8675 | John | 05/03/2019 | ENG | Roy@gmail.com | Muller | Setup | Wright | Ronak | Wight@gmail.com | ||||||
78678 | Kevin | 13/03/2019 | AST | Roy@gmail.com | Danone | Setup | James | Ronak | James@gmail.com | ||||||
8679 | Johny | 05/04/2019 | RS | Roy@gmail.com | Nestle | Setup | Vince | Roy | Vince@gmail.com | ||||||
78673 | Kevin Peter | 13/02/2019 | IT | Roy@gmail.com | Choco | Setup | James | Ronak | James@gmail.com | ||||||
8787 | Paul | 13/03/2019 | IT | Roy@gmail.com | Dominos | Setup | James | Jaison | Jamesorg@gmail.com | ||||||
86752 | John | 05/03/2019 | ENG | Roy@ymail.com | Muller | Setup | Wright | Ronak | Wight@gmail.com | ||||||
786784 | Kevin | 13/03/2019 | AST | Roy@ymail.com | Danone | Setup | James | Ronak | James@gmail.com | ||||||
86796 | Johny | 05/04/2019 | RS | Roy@ymail.com | Nestle | Setup | Vince | Roy | Vince@gmail.com | ||||||
786739 | Kevin Peter | 13/02/2019 | IT | Roy@ymail.com | Choco | Setup | James | Ronak | James@gmail.com | ||||||
87875 | Paul | 13/03/2019 | IT | Roy@ymail.com | Dominos | Setup | James | Jaison | Jamesorg@gmail.com |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thanks