Email after when date is x days away

[RDF25087]

Good morning -

I want to schedule a daily workflow that notifies a project manager by email that their project will end in 22 days.

The raw data looks something like this:

In the above example, the Product B and Product D campaigns will end 22 days from TODAY. I would like the workflow to identify those two campaigns and email the Project Managers that their campaigns are coming to an end with the following message:

Dear [Project Manager Name]

Your project [Project Number] [Project Name] will end in 22 days. Please review this project and take action where required.

Is this something that can be done, as it's more advanced than I can manage at the moment!

Thank you for any help you might be able to provide.

RDF

[FinnCharlton · Accepted solution]

Hi @RDF25087 , this workflow will do that for you, you can customize the text to say whatever you want.

[RDF25087]

@FinnCharlton- thank you for the quick response. I've added your solution to my workflow and it's running now. Fingers crossed.

RDF

[RDF25087]

Right then. I'm getting a [Null] value on the Date Diff output. I'm presuming this is because in your solution the End Date is in dd/mm/yyyy format whereas in my data it's dd.mm.yyyy.

[FinnCharlton]

@RDF25087 yep that'll be why, just replace the "%d/%m/%Y" with "%d.%m.%Y"

[RDF25087]

@FinnCharlton- Perfect! That has solved that issue. However, it looks as though this will email every manager, every expiring project, whether it is theirs or not:

I need it to email each individual project manager only the expiring projects in their name - they shouldn't see any of the other managers jobs.

Thanks

RDF

[FinnCharlton]

@RDF25087 , it only looks like that because you are viewing many records at once. Each email will just contain one of these reporting snippets. One email will be sent per row of data, and it will only contain information for that manager. 

[RDF25087]

@FinnCharlton  - Thanks for your help. I'll run it tonight and hopefully all will be well.

Thanks again.

RDF