I will be glad to assist you with this. I have posted the script below that will send out an email notification when the user defined field is populated with the value 'Ready for Review'. You will need to edit the script to work with your current environment. I also recommend that you test this in a test project before implementing into your production environment.
Add this workflow to the existing Req_AfterPost subroutine:
Set tdc = TDConnection
Set objReqFactory = tdc.reqFactory
Set ReqFilter = objReqFactory.Filter
pQCAdmin = ''email@example.com'' 'Send the email to the Quality Center Administrator
'Change for your own environment
Req_AssignedTo = Req_Fields.Field(''RQ_USER_01'').Value
pEmail = tdc.Customization.Users.User(Req_AssignedTo).Email
If len(pEmail)<1 Then 'If Requirement Author's email address is blank
pEmail = pQCAdmin 'Send the email to the Quality Center Administrator
Req_AssignedTo = pEmail 'Change for your own environment
If Req_Fields(''RQ_REQ_REVIEWED'').Value = ''Ready for Review'' Then
strTO = Req_AssignedTo
strSubject = ''The Status for Requirement # '' & Req_Fields(''RQ_REQ_ID'').value & '' Has Changed to '' & Req_Fields(''RQ_REQ_REVIEWED'').value
strComment = ''The Status for Requirement # '' & Req_Fields(''RQ_REQ_ID'').value & '' Has Changed to '' & Req_Fields(''RQ_REQ_REVIEWED'').value
TDConnection.sendmail strTo, strFrom, strSubject, strComment, NULL, ''HTML''
Set TDConnection = nothing
MsgBox ''Mail Sent''
Set tdc = nothing
Set objReqFactory = nothing