Help...!Automatically sending Reminders to Resources for Pending Trainings

[Dinesh_Excel]

Hi Friends,

I have a list of trainings that needs to be completed by project resources.
The sheet contains resources and trainings which are completed and which are pending to be completed.

Is there any way by which from the base sheet it will pick status of each resource status and send reminders.

Attached the Base sheet for your reference


The mail format is similar to below :

Hi Xyz,

Below trainings which are marked as not completed.

 

[Monty]

Hello Dinesh,

Do you want to send mail only to people who are pending, and also confirm the email id's column.

Please give more information.

 

[Dinesh_Excel]

Hello Monty,
The mail would be somewhat is a combination of STATUS kind off, where in it show both pending and completed training of resources.

In the base sheet the resource names are reflected in column c and their mail ID's in column "AX".


The output of the mail should print all the training status (which are colored) in the first row of the base sheet.

Can this be possible.

Thank you

 

[Dinesh_Excel]

Hi Monty, Appreciate your help on the above.