Automating COmmunications from a Excel Spreadsheet?

Communications Management

Chanukya Rajagopala Director - IT Strategy - R & D| iPOCA Private Ltd United 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?

Posted: Jan 8, 2017 5:12 PM

Sort By:

< 1 2 >

Chanukya Rajagopala Director - IT Strategy - R & D| iPOCA Private Ltd United Kingdom

Jan 09, 2017 4:04 PM

Replying to Vincent Guerard

...

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!

Thanks for the suggestions Vincent.

Regards

Posted: Jan 16, 2017 7:58 AM

Stéphane Parent Self Employed / Semi-retired| Leader Maker Prince Edward Island, Canada

Based on the scenario you put forward, Chanu, you may find using Outlook recurrent tasks easier to manage than the spreadsheet.

Otherwise, you will need to figure out what "daily", "weekly", "monthly", "quarterly" means to you and then implement it in the VBA code.

The other problem with using a spreadsheet to send notifications is that it has to be open for the VBA code to work. (There are workarounds but, trust me, it gets ugly quick.)

Posted: Jan 16, 2017 8:39 AM (Updated by author: Jan 16, 2017 8:39 AM)

< 1 2 >

Please login or join to reply

Automating COmmunications from a Excel Spreadsheet?

Sponsors

Vendor Events

Guessing is not a strategy: How to build decision velocity with AI and real-time data

Newsletters