Question Locked

Email multiple recipients from excel using BCC

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

I'd like to email recipients from excel and BCC the recipients instead of having the email addresses in the 'To' field. I'm not very savvy figuring out how to change it myself as I'm quite a novice.

I found a code to email multiple recipients from excel, it works great, however does anyone know how I need to tweek the code below so that the email addresses are in the BCC field instead?

The following is the code I'm using:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim OlApp As Object, M As Object, c As Range
If Target.Address <> "$A$3" Then Exit Sub
Cancel = True
' Creates an instance of Outlook
Set OlApp = CreateObject("Outlook.application")
'Creation of the message
Set M = OlApp.CreateItem(olMailItem)
With M
.Subject = "Subject"
.Body = "Body"
' Adding the recipients
For Each c In Range("B6", Range("B60000").End(xlUp))
.Recipients.Add c.Value
Next c
.display ' Use this line instead of the next one if you want to see / edit
' the Message
.Send
End With
End Sub

Any help/direction would be much appreciated!!!

4 replies

by xochiltm

Thanks for your help! I tried your suggestion of adding the .BCC.Add c.Value and unfortunately the emails continue to populate in the 'To' section of the composed email. I did follow the link you suggested and did some reading... I'll continue working on it to see if I can understand what the problem is.

Again, thank you so much for your time! :)

by seanferd

I don't do VBA normally myself, so I can't give you a definitive answer. Hopefully, someone else will see this.

You can add to the thread occasionally (bump) to keep it up in the list here, if you like.

This discussion is closed to new replies.