Syntax for multiple addresses for email

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top