We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
With objOutlookMsg ' Add the To recipient(s) to the message. Set objOutlookRecip = .Recipients.Add("firstname.lastname@example.org") objOutlookRecip.Type = olTo Set objOutlookRecip = .Recipients.Add("email@example.com") objOutlookRecip.Type = olCC .Subject = "Something " Dim rstData As ADODB.Recordset Set rstData = New ADODB.Recordset rstData.ActiveConnection = CurrentProject.Connection rstData.Open "SELECT * FROM qryAny" Dim strData As String Do Until rstData.EOF strData = strData & rstData("FullName") & vbNewLine rstData.MoveNext Loop .Body = strData For Each objOutlookRecip In .Recipients objOutlookRecip.Resolve Next .Save .send End With
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Create a varying recordset||5||48|
|Combo box question||6||49|
|How to use Recordset, returned from a SPROC as the recourdsource of a form.||24||48|
|MS Access Error - specified field could refer to more than one table listed||10||29|
Join the community of 500,000 technology professionals and ask your questions.