If stetement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

I am sending an e-mail using the below function:

Function Send_Open_Incident()
On Error GoTo Send_Open_Incident_Err

DoCmd.SendObject , "", "RichTextFormat(*.rtf)", Forms![Data Quality
Issues Management]!OpenedBy, Forms![Data Quality Issues Management]!Email,
"", "Closing Incident", _
"Thank You for contacting the Data Standards Project Team. The details of
your recent incident are listed below. If you would like to know the status,
please contact us and reference your incident number below. Incident No: " &
Forms![Data Quality Issues Management]!IncidentNumber & _
" ;***Description: " & Forms![Data Quality Issues Management]!Description,
True, ""

Is it possible to add an if statement to the 'cc'/ or to 'to', like: if
([field1] = "M" the e-mail address is E1, E2; the idea is to send to one
person if 'M' and to other person if not M...

Thank you very much,

Dan
 
Back
Top