none
Email Address in Project Center Summary View in Project Server 2007 RRS feed

  • Question

  • Currenly we have Email Address custom field at Resource level. Can we use the same custom field at project level also. I have checked adding that column in my summary view in the project center but it is not available.

    Can anyone tell me how to achieve the Email Address column in the summary view in the project center.

    Thanks, Vivek

    Thursday, October 6, 2011 6:22 PM

All replies

  • Could you explain why?  That might help to better address the need.
     
    Thanks
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Thursday, October 6, 2011 6:32 PM
    Moderator
  • We have got a requirement from the PMO to add the Email address column in the summary view of the project center so that when ever the PM didnt publish the project plan for last 14 days, the PMO will have take the email address from Email address column and send an email.
    Thursday, October 6, 2011 7:13 PM
  • Why don't you just use their names?  Outlook will resolve the names when
    they're dropped in the To: field of the e-mail.
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Thursday, October 6, 2011 7:21 PM
    Moderator
  • The PMO have already used the names but most of the times the names are not getting recognized in the outlook and finally they have asked for this email address field in the summary view in project center.

     

    Thursday, October 6, 2011 8:30 PM
  • If its only one email address, you could consider a client macro or server event to copy the value to a custom project field that will be used in the summary view

    If its more than one email address that needs to be aggregated to one string, you can do the same, but you should be aware of size limitation in the custom field's value (256 characters if I recall..)

    Another possibility would be to open project client and use a macro to send an email directly from there 

     

    HTH


    Assaf
    Thursday, October 6, 2011 9:41 PM
  • A couple options:

    1) Use the Owner field and sync your resource pool with AD.

    2) Create a Project level text field and ask the PM to fill it out when the project is created.

    3) Repurpose the Resource Phonetics field.  Copy the e-mail address into that field when the resource is created.  Create a custom task field to roll it up to the summary level.  Create a custom project field to equal the summary.  Add the project field to Project Center.


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Friday, October 7, 2011 1:34 AM
    Moderator
  • Another thought, You can automate the process. I did the similar stuff for one of my client for project compliance.

    1. You can write a procedure which gets the lists of projects, ProjectOwnerResourceUID , "ProjectModifiedDate" from project server reporting database vieww MSP_EpmProject_UserView. Join this view with MSP_EpmResource_UserView to get the ProjectOwnerResourceUID's ResourceEmailAddress. & use the logic to check the last modified date with current date & find the difference.
    2. Wite a SQL agent job which runs on a scheduled time & sends the emails using sp_send_dbmail to those Project Owners with CCing to PMO.
    http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Friday, October 7, 2011 8:13 AM