Hi All
I send e-mails thru access using the following code
DoCmd.SendObject acSendReport, "RPTTT1", acFormatRTF, "[email protected]", "", "", " Call Logging " & CallType, " Call Logging logged by " & LoggedBy, True
I have a second e-mail address that I want to populate the from field with when I send each e-mail. Is this possible to insert a different e-mail address into the from field
Thanks

Brendan Bartley

__________________
Brendan Bartley

Do you mean send it with a different FROM field, or with TWO from addresses, like: "[email protected];[email protected]"

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 = "[email protected]"
Else
   sFrom = "[email protected]"
End If


DoCmd.SendObject acSendReport, "RPTTT1", acFormatRTF, sFrom, "", "", " Call Logging " & CallType, " Call Logging logged by " & LoggedBy, True

Is that what you are getting at?


mmcdonal

Look it up at: http://wrox.books24x7.com