Adding email addresses based on cell references to a mail button

[Godot60]

I have form that has a button that sends an email to those completing the form. The relevant section looks like this:

With OutMail
.To = "James.jones@urcca.edu"
.CC = ""
.BCC = ""
.Subject = "Successful Submission: " & Sheet1.Range("j10")
.Body = strbody
.Attachments.Add ActiveWorkbook.FullName
'You can add a file like this
'.Attachments.Add ("C:\test.txt")
.Send 'or use .Display
End With

How do I add cell references that contain an email address to the CC line? I've tried a number of things and nothing seems to work. Any ideas? Thanks.

 

[Logit]

.
The same as you have in SUBJECT

 

[Godot60]

Thanks! What if I need to reference two different cells in the cc line - for two different email addresses?

 

[Logit]

.

.CC = Sheet1.Range("D10").Value & ", " & Sheet1.Range("D11").Value

 

[Godot60]

Thanks! Worked like a charm!

 

[Godot60]

It worked with one change replacing the comma with a semicolon

 

[Logit]

.
You are welcome.