View Single Post
  #2 (permalink)  
Old June 17th, 2008, 02:23 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Do you mean send it with a different FROM field, or with TWO from addresses, like: "Brendan.Bartley@anpost.com;mmcdonal@aoc.gov"

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"
Else
   sFrom = "mmcdonal@anpost.com"
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