Sending email to multiple recepients from Groupwise

[Foster Purdy via AccessMonster.com]

I am currently using SendObject to generate an email in Groupwise and it
works fine. I am now trying to add multiple recepients in the To and CC
sections but am running into difficulty.

Here is the code:

DoCmd.SendObject acSendNoObject, , , Forms!frm_appraisal_emp_info_entry!
AssignedPC, "Training", "Compliance", _ strSubject, strMsg, True

From what I have read I need to use semi colons to separate additional
recepients:

DoCmd.SendObject acSendNoObject, , , Forms!frm_appraisal_emp_info_entry!
AssignedPC; "Deputy Chief"; "AA_Deputy Chief, "Training", "Compliance", _
strSubject, strMsg, True

However that gives me the following error:

Compile Error: Expected end of statement

Am I heading in the right direction or should I be using another method?

 

[Arvin Meyer [MVP]]

SendObject requires that all the addresses be on a string, separated by
commas. You can have up to 3 strings:

To, CC, and BCC

but you appear to have 4. If you'd like to gather them all into a single
string have a look at the code at:

http://www.datastrat.com/Download/EmailSenate2K.zip

 

[Douglas J. Steele]

Assuming "To:" is supposed to be AssignedPC, "Deputy Chief" and "AA_Deputy
Chief, "CC:" is supposed to be "Training" and "Bcc:" is supposed to be
"Compliance", you should have:

DoCmd.SendObject acSendNoObject, , , _
Forms!frm_appraisal_emp_info_entry!AssignedPC & _
";Deputy Chief;AA_Deputy Chief, "Training", "Compliance", _
strSubject, strMsg, True

 

[Foster Purdy via AccessMonster.com]

Hi Douglas,

I used your code and got a Compile Error: Syntax Error message. I thought it
may have been the double quotes before the semi colon and Deputy Chief but
removing that gave me a Compile Error: Expected Expression.

Assuming "To:" is supposed to be AssignedPC, "Deputy Chief" and "AA_Deputy
Chief, "CC:" is supposed to be "Training" and "Bcc:" is supposed to be
"Compliance", you should have:

DoCmd.SendObject acSendNoObject, , , _
Forms!frm_appraisal_emp_info_entry!AssignedPC & _
";Deputy Chief;AA_Deputy Chief, "Training", "Compliance", _
strSubject, strMsg, True

I am currently using SendObject to generate an email in Groupwise and it
works fine. I am now trying to add multiple recepients in the To and CC

[quoted text clipped - 17 lines]

Am I heading in the right direction or should I be using another method?

 

[Douglas J. Steele]

Sorry, my typo.

There should be a double quote after Deputy Chief, before the comma:

DoCmd.SendObject acSendNoObject, , , _
Forms!frm_appraisal_emp_info_entry!AssignedPC & _
";Deputy Chief;AA_Deputy Chief", "Training", "Compliance", _
strSubject, strMsg, True



--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Douglas,

I used your code and got a Compile Error: Syntax Error message. I thought
it
may have been the double quotes before the semi colon and Deputy Chief but
removing that gave me a Compile Error: Expected Expression.

Assuming "To:" is supposed to be AssignedPC, "Deputy Chief" and
"AA_Deputy
Chief, "CC:" is supposed to be "Training" and "Bcc:" is supposed to be
"Compliance", you should have:

DoCmd.SendObject acSendNoObject, , , _
Forms!frm_appraisal_emp_info_entry!AssignedPC & _
";Deputy Chief;AA_Deputy Chief, "Training", "Compliance", _
strSubject, strMsg, True

I am currently using SendObject to generate an email in Groupwise and it
works fine. I am now trying to add multiple recepients in the To and CC

[quoted text clipped - 17 lines]

Am I heading in the right direction or should I be using another method?

 

[Foster Purdy via AccessMonster.com]

Excellent. Works great. Thanks Douglas.

Sorry, my typo.

There should be a double quote after Deputy Chief, before the comma:

DoCmd.SendObject acSendNoObject, , , _
Forms!frm_appraisal_emp_info_entry!AssignedPC & _
";Deputy Chief;AA_Deputy Chief", "Training", "Compliance", _
strSubject, strMsg, True

Hi Douglas,

[quoted text clipped - 18 lines]