Need Help

[Pradeepraj]

Hi Chandoo.

Good day My Brother.

I dont want to tell all usual things what all say ... But again thanks for all the knowledge and information which you share to us in Excel. Thanks Again.

I am not so good in excel all my implementations is by watching videos and blogs only

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

Thanks Once again

 

[BobBridges]

Let's tackle just one of these at a time. The Subject line looks pretty easy: It just uses the Subject property of the email object. You have tried that, right? If it isn't working, in what way is it not working? Or if you don't know how to change the subject line, how far have you gotten in creating an email object?