I feel slightly embarassed posting this..and it took me a whole night thinking about it and another few minutes this morning...but the reason it's erroring out is because we both need to change the '=' to an '&'
From: sToName = sToName = .Fields(5) & ";"
To: sToName = sToName & .Fields(5) &...
When I try the above, it errors out:
Run-time '2205'
Unknown message recipient(s); the message was not sent.
Do you have any ideas?
-----------------------------------------
Here's what I moved around:
-----------------------------------------
Private Sub Command12_Click()
Dim MyDb As...