How to add another -email recipient

[Dan]

Hi:

I still could not do it:


How do I add another recipient to this function, separated by what?

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,
Forms![Data Quality Issues Management]!OEmail, "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,

Tahnks,

Dan

 

[Rob Oldfield]

The help for SendObject specifies a delimeter of ;

So just mail1+";"+mail2 should work.

Does it not? What error(s) do you get?

 

[D]

Hi Rob:

Sorry for the delay;

This is just in case you type the real names of the recipients; but when you
have the name of the field from the form, does not work...

Thanks again,

Dan

The help for SendObject specifies a delimeter of ;

So just mail1+";"+mail2 should work.

Does it not? What error(s) do you get?

Hi:

I still could not do it:


How do I add another recipient to this function, separated by what?

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,
Forms![Data Quality Issues Management]!OEmail, "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,

Tahnks,

Dan