Chanukya RajagopalaDirector - IT Strategy - R & D| iPOCA Private LtdUnited Kingdom
Scenario- Communication plan on an excel spreadsheet, contains dates for reports to be sent out to project team and other stakeholders. A day before the due date for report, the project manager sends an email reminder for report to be sent out.
Question - Is there any way that Outlook picks up these dates from Excel spreadsheet to send reminder alerts to stakeholders? Saving Changes...
Markus KopkoAI Enabler for Project & Program Mgmt | Founder PMotion.ai / The PM
AI Coach| PMotion.aiHamburg, Hamburg, Germany
you may search for similar vba code examples online and customize it for your needs
...
1 reply by Chanukya Rajagopala
Jan 16, 2017 7:56 AM
Chanukya Rajagopala
...
Markus,
Thanks for a quick response.
Regards
Chanu
Saving Changes...
Drew CraigSr. Agile & Product Coach| VanguardPhiladelphia, Pa, United States
This should be set up in SharePoint - workflow, timer jobs, alerts. Centralize the content, reduce email noise, and multiple versions of the document.
...
1 reply by Markus Kopko
Jan 09, 2017 7:59 AM
Markus Kopko
...
Hi Andrew,
you are absolutely right, as best this should be done with SharePoint, if available.
I have assumed (cause it was not mentioned) that we do not have SharePoint available here.
BTW: MP4PM will provide something similar (connections with Outlook, SharePoint and also other databases/SQL are possible), but this will need some additional time ... ;)
Saving Changes...
Drew CraigSr. Agile & Product Coach| VanguardPhiladelphia, Pa, United States
But understood SharePoint may not be available. With that, I'd agree wth Markus and Anupam Saving Changes...
Markus KopkoAI Enabler for Project & Program Mgmt | Founder PMotion.ai / The PM
AI Coach| PMotion.aiHamburg, Hamburg, Germany
Jan 09, 2017 7:07 AM
Replying to Drew Craig
...
This should be set up in SharePoint - workflow, timer jobs, alerts. Centralize the content, reduce email noise, and multiple versions of the document.
Hi Andrew,
you are absolutely right, as best this should be done with SharePoint, if available.
I have assumed (cause it was not mentioned) that we do not have SharePoint available here.
BTW: MP4PM will provide something similar (connections with Outlook, SharePoint and also other databases/SQL are possible), but this will need some additional time ... ;) Saving Changes...
According to your budget and current software installation, many scenario can be consider
Some VBA code would be required!
Sharepoint is one solution, MS project can also link to Outlook to follow progress of the schedule!
...
1 reply by Chanukya Rajagopala
Jan 16, 2017 7:58 AM
Chanukya Rajagopala
...
Thanks for the suggestions Vincent.
Regards
Saving Changes...
Chanukya RajagopalaDirector - IT Strategy - R & D| iPOCA Private LtdUnited Kingdom
Jan 08, 2017 11:49 PM
Replying to Anupam
...
Get VBA code written.
Thanks Anupam.
Regards
Chanu Saving Changes...
Chanukya RajagopalaDirector - IT Strategy - R & D| iPOCA Private LtdUnited Kingdom
Jan 09, 2017 3:11 AM
Replying to Markus Kopko
...
you may search for similar vba code examples online and customize it for your needs
Markus,
Thanks for a quick response.
Regards
Chanu Saving Changes...
Chanukya RajagopalaDirector - IT Strategy - R & D| iPOCA Private LtdUnited Kingdom
Jan 09, 2017 3:53 PM
Replying to Mayte Mata Sivera
...
I've struggling with VBA until I've worked in a company with SharePoint, now I'm a super fan of SharePoint as Andrew seems, lol.
