C
Christine
My programme uses the following code to get assorted email
addresses from a table:
Dim strOriginator As String
strOriginator = DLookup
("", "qryEmployees", "[EmployeeID]= [OriginatorID]")
The code for sending the email is:
DoCmd.SendObject acSendNoObject, , , strAssignedTo,
strQAMgr; strOriginator, , mTitle, mMsg,False
I get an error (Compile - expected end of statement) which
has something to do with the way the cc's (strQAMgr;
strOriginator) are written. I've tried putting the
addresses in brackets [], paranthesis(), quotes"" without
success. What am I doing wrong?
Also, what would be the method to put all the To addresses
and CC addressess into one string, for example...
mTo = strOriginator AND strQAMgr AND strProcMgr
mCC = strPerson1 AND strPerson2
This way, the code for actually sending the email might
look like this:
DoCmd.SendObject acSendNoObject, , , mTo, mCC, , mTitle,
mMsg,False
Thanks,
Christine
addresses from a table:
Dim strOriginator As String
strOriginator = DLookup
("", "qryEmployees", "[EmployeeID]= [OriginatorID]")
The code for sending the email is:
DoCmd.SendObject acSendNoObject, , , strAssignedTo,
strQAMgr; strOriginator, , mTitle, mMsg,False
I get an error (Compile - expected end of statement) which
has something to do with the way the cc's (strQAMgr;
strOriginator) are written. I've tried putting the
addresses in brackets [], paranthesis(), quotes"" without
success. What am I doing wrong?
Also, what would be the method to put all the To addresses
and CC addressess into one string, for example...
mTo = strOriginator AND strQAMgr AND strProcMgr
mCC = strPerson1 AND strPerson2
This way, the code for actually sending the email might
look like this:
DoCmd.SendObject acSendNoObject, , , mTo, mCC, , mTitle,
mMsg,False
Thanks,
Christine