Email to three people

[Jake F]

I'm trying to send a report to three people and am wondering if this will
work for automatically sending to them or if there is a different way i
should go about it. The rest of the code works for getting the message body
and the report in there, I just am not sure about filling in the "To:" field
for the email and want to know it works before I try to send it out.

' HR_Email sends Rep Report to HR Reps
Hr_Reps = "(e-mail address removed); (e-mail address removed); (e-mail address removed)"
DoCmd.SendObject acReport, "rptDivisionTransactionsForReps", acFormatPDF,
Hr_Reps, , , "Rep Reports", strMessageBody_HrReps, False

Thanks.

 

[Daniel Pineault]

Your format is correct and you can easily test it (and you should always test
before implementing) by using your own e-mail addresses (or colleague).

But separated by ; is the right format for the To, CC, BCC lists