Pradeepraj
New Member
I need help in the following
1) I need to send remainder email if the current date is between 1 to 7 (Last Updated date - Current date is between 1 to 7)
2 I need to get the Subject line as the row specific ( For Instance if the A2 Project Name is ABC Infra i need the ABC infra in Subject line and the Body Col B and continues for all 1 to 7 dates)
3)I need to add the people in To as per the Col C ( It has only the name and the Outlook should resolve the full name ) ( Select all the Projects that person is been assigned to )
4) I need to add the CC specific DL and Persons
I have researched few articles of yours " https://chandoo.org/forum/threads/help-with-vba-code-sending-automated-email-with-outlook.36561/"
The only missing is the date part and the Sub and the Body .
The Sub should Contain :- ABC Infra Need update As the last update
The Body should can contain the same
The attachment of the email is filtered by the specific Persons project
1) I need to send remainder email if the current date is between 1 to 7 (Last Updated date - Current date is between 1 to 7)
2 I need to get the Subject line as the row specific ( For Instance if the A2 Project Name is ABC Infra i need the ABC infra in Subject line and the Body Col B and continues for all 1 to 7 dates)
3)I need to add the people in To as per the Col C ( It has only the name and the Outlook should resolve the full name ) ( Select all the Projects that person is been assigned to )
4) I need to add the CC specific DL and Persons
I have researched few articles of yours " https://chandoo.org/forum/threads/help-with-vba-code-sending-automated-email-with-outlook.36561/"
The only missing is the date part and the Sub and the Body .
The Sub should Contain :- ABC Infra Need update As the last update
The Body should can contain the same
The attachment of the email is filtered by the specific Persons project