Question

Locked

Email multiple recipients from excel using BCC

By xochiltm ·
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!!!

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Possibly as simple as

by seanferd In reply to Email multiple recipients ...

.Recipients.Add c.Value
to
.BCC.Add c.Value
(Based entirely on looking at a code snippet. .BCC may have been defined elsewhere...)

Or possibly not. Check out this thread - be sure to read the bottom post.
http://www.xtremevbtalk.com/showthread.php?t=53441

Collapse -

Thanks for your help.

by xochiltm In reply to Possibly as simple as

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! :)

Collapse -

Good luck.

by seanferd In reply to Thanks for your help.

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.

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums