cc'ing an email report

[Alex]

Hi
I am using the following to send a report as a snapshot to TutorEmail.
I want to include a cc to another specified email address. Can someone
advise me of the correct syntax please

thanks

Alex


DoCmd.SendObject acSendReport,
"rptStudentAssignmentFeedbackDetailsCCtoTutor", "Snapshot Format (*.snp)",
TutorEmail, , , subj, msg, True

 

[Douglas J. Steele]

The actual syntax for the SendObject method is:

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][,
bcc][, subject][, messagetext][, editmessage][, templatefile]

Put the cc name after the comma after TutorEmail. If you want to send to (or
cc or bcc) multiple addresses, separate them with a semicolon in the string.

 

[fredg]

Hi
I am using the following to send a report as a snapshot to TutorEmail.
I want to include a cc to another specified email address. Can someone
advise me of the correct syntax please

thanks

Alex

DoCmd.SendObject acSendReport,
"rptStudentAssignmentFeedbackDetailsCCtoTutor", "Snapshot Format (*.snp)",
TutorEmail, , , subj, msg, True

One of the arguments in the SendObject method is the cc argument.
Just enter the address as a string
.... ,"(e-mail address removed)", ....
See VBA help.