Adding email address not in record set

[ypma]

My situation is that , I have a sub for sending an email to a single client on the current form. Using a record set works fine, I now wish to have .Cc email address which is not part of the Record set ." its to the department head".​

strEmailAddress = rst![clientEmail] & " ;" & somebody@ntlworld.com​

My question is can I type the somebody email address as indicated in red in the above line? to enable the email to go to both addressees .if so any assistance in the correct format would be appreciated .​

　​

set DoCmd.SendObject , , acFormatRTF, clientEmail, _​

, , strSubject, strEMailMsg, False, False?​

I would prefer to use the Do Cmd SendObject is this is achievable​

 

[Mile-O]

That wouldn't CC but instead send the email to somebody@ntlworld.com and the person whose email address is in the field.

Using DoCmd.SendObject you get a To and an CC parameter.

DoCmd.SendObject , , acFormatRTF, strEmailAddress, "somebody@ntlworld.com", , strSubject, strMessage

 

[ypma]

Mile -O. Thank you very much for your quick and accurate response to my questions . it now works as I require it to..