Do you mean send it with a different FROM field, or with TWO from addresses, like: "Brendan.Bartley@anpost.com;email@example.com"
I don't think you can concatenate from fields, but you can change the from field in your string by placing the field in a variable, and then changing the value of the variable for whatever reason, as long as your email system will accept emails from the sender. For example:
Dim sFrom As String
If (condition is met) Then
sFrom = "Brendan.Bartley@anpost.com"
sFrom = "firstname.lastname@example.org"
DoCmd.SendObject acSendReport, "RPTTT1", acFormatRTF, sFrom, "", "", " Call Logging " & CallType, " Call Logging logged by " & LoggedBy, True
Is that what you are getting at?
Look it up at: http://wrox.books24x7.com