
December 2nd, 2008, 05:30 AM
|
|
Registered User
|
|
Join Date: Nov 2008
Posts: 29
Time spent in forums: 4 h 19 m 51 sec
Reputation Power: 0
|
|
|
Sending Mail from Access to BCC: recipients
Hi,
I have designed a function to send e-mails to people on my mailing list from a form but would like to know if there is a way to send it as bcc: as opposed to to: or if there is any other way I would be able to hide the e-mail addresses of the recipients.
My current code is:
Code:
Public Sub SendMail()
'Provides the Send Mail automation
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim strSubject As String
Dim strEmailAddress As String
Dim strEMailMsg As String
Dim ingCounter As Integer
Dim intCount As Integer
strSubject = [cmdSubject]
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("qryEmailOut")
rst.MoveFirst
Do Until rst.EOF
strEmailAddress = rst![email address]
strEMailMsg = rst![First Name] & " " & rst![Surname] _
& " - "
'EMAIL USER DETAILS & ATT REPORT
DoCmd.SendObject , , acFormatRTF, strEmailAddress, _
, , strSubject, strEMailMsg, False, False
rst.MoveNext
Loop
rst.Close
Set rst = Nothing
dbs.Close
Set dbs = Nothing
Thanks
Russ
|