Sending Email

[Bill Davis]

I am using the following code to send and email to 3
people, what i would like to do is pull the address from
a distribution list form my address book and populate the
To and CC. I am pulling the customer account number
Me.txbcustomer_account into the subject but I would like
to add the order # txtorder_number and having problems
getting the code correct. Can someone help.
Thank you

Dim stDocName As String
StDocName ="Daily"

DoCmd.SendObject acSendReport, stDocName, , "mhall;
srose", "jbennett", , Me.txbcustomer_account & _
, "Daily Escalation, Please review.", , False

 

[Bill]

I am using the following code to send and email to 3
people, what i would like to do is pull the address from
a distribution list form my address book and populate the
To and CC. I am pulling the customer account number
Me.txbcustomer_account into the subject but I would like
to add the order # txtorder_number and having problems
getting the code correct. Can someone help.
Thank you

Dim stDocName As String
StDocName ="Daily"

DoCmd.SendObject acSendReport, stDocName, , "mhall;
srose", "jbennett", , Me.txbcustomer_account & " " & txtorder_number _
, "Daily Escalation, Please review.", , False