var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Send one Email to many from Addresses in table
i can send an email to each person in the table, but how do i send one email and cc in other names in the table? I have a type field (To or CC or BCC)
currently using, which is great for opening lots of emails.... just want one...
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim strSQL As String
strSQL = "Select emailaddress from tbl_Email where update = true"
rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockReadOnly
Do While Not rs.EOF
DoCmd.SendObject acSendReport, "rpt_ContractorListForIT", acFormatXLS, rs!EmailAddress, , , "Contractor Expiry Dates", strMess
Set rs = Nothing
You can separate addresses with semi-colons ( like this
DoCmd.SendObject acSendReport,<ObjectName>,<OutputFormat>,<To>,"email@example.com; firstname.lastname@example.org"