To: or CC: or BCC:

Status
Not open for further replies.
P

Peter Hibbs

I am writing some VBA code in Access 2003 to send multiple emails via

Outlook (using Redemption although I don't think that is relevant in

this situation) for a membership database.

What I am trying to determine is the relationship between the three

fields To:, CC: and BCC:. For example, if I were to send an email to

10 different email addresses, and I don't want the recipients to see

all the email addresses of the other members, I would use the BCC:

field.

The question is - would I copy ALL 10 addresses to the BCC field and

leave the To: field blank (which I don't think works) or do I copy one

email address to the To: field and the other 9 to the BCC: field or do

I copy a dummy email address to the To: field and use the BCC: field

for all the 10 addresses. My tests so far seem to indicate that this

option does work (except that the email address in the To: field does

not seem to receive an email, unless I did something wrong).

What would be the correct procedure in this situation?

Also, is there any limit on the number of email addresses that can be

copied to the BCC: field? I would need about 2000 at the most.

TIA

Peter Hibbs.
 
S

Sue Mosher [MVP]

Re: or CC: or BCC:

Think about it: If you don't want recipients to see any of the other's

addresses, you don't want to put one of those member addresses in the To

field, do you? You could use a dummy address, but Outlook itself doesn't

care which technique you use. The best approach is to test with the mail

clients you expect your recipients to have and then choose the approach that

looks the best for your scenario.

Ask your email provider about the limit on recipients in a single message.

It's their limit that counts.

Bcc is not the approach I'd use. Sending a message using Bcc makes it more

likely that the message will be rejected by the recipient's spam filter. My

preferred approach would be to send 10 separate messages, with a single To

address for each one.

Or, for a better long-term solution, use a dedicated mailing list

application or host.

Sue Mosher

"Peter Hibbs" <peter.hibbs@btinternet.com.NO_SPAM> wrote in message

news:3sol05t64stf51h69a97jp120go36m1tlh@4ax.com...
> I am writing some VBA code in Access 2003 to send multiple emails via
> Outlook (using Redemption although I don't think that is relevant in
> this situation) for a membership database.

> What I am trying to determine is the relationship between the three
> fields To:, CC: and BCC:. For example, if I were to send an email to
> 10 different email addresses, and I don't want the recipients to see
> all the email addresses of the other members, I would use the BCC:
> field.

> The question is - would I copy ALL 10 addresses to the BCC field and
> leave the To: field blank (which I don't think works) or do I copy one
> email address to the To: field and the other 9 to the BCC: field or do
> I copy a dummy email address to the To: field and use the BCC: field
> for all the 10 addresses. My tests so far seem to indicate that this
> option does work (except that the email address in the To: field does
> not seem to receive an email, unless I did something wrong).

> What would be the correct procedure in this situation?

> Also, is there any limit on the number of email addresses that can be
> copied to the BCC: field? I would need about 2000 at the most.

> TIA

> Peter Hibbs.
 
P

Peter Hibbs

Re: or CC: or BCC:

Hi Sue,

Sending one at a time would certainly be an option, not sure about

sending 2000 though. I will need to do some timing tests to see how

long that would take.

The Mailing List app' is an interesting idea. I Googled that and got

quite a few hits, will look into that as well.

Anyway, thanks for the advice, I'll see how I get on with those

options.

Peter Hibbs.

On Wed, 13 May 2009 11:46:25 -0400, "Sue Mosher [MVP]"

<suemvp@turtleflock.com> wrote:


> Think about it: If you don't want recipients to see any of the other's
> addresses, you don't want to put one of those member addresses in the To
> field, do you? You could use a dummy address, but Outlook itself doesn't
> care which technique you use. The best approach is to test with the mail
> clients you expect your recipients to have and then choose the approach that
> looks the best for your scenario.

> Ask your email provider about the limit on recipients in a single message.
> It's their limit that counts.

> Bcc is not the approach I'd use. Sending a message using Bcc makes it more
> likely that the message will be rejected by the recipient's spam filter. My
> preferred approach would be to send 10 separate messages, with a single To
> address for each one.

> Or, for a better long-term solution, use a dedicated mailing list
> application or host.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Put your own address into the To field and the 10 real recipients into BCC.

The number of allowed addresses might be limited by your provider.

Best regards

Michael Bauer

Am Wed, 13 May 2009 16:28:16 +0100 schrieb Peter Hibbs:


> I am writing some VBA code in Access 2003 to send multiple emails via
> Outlook (using Redemption although I don't think that is relevant in
> this situation) for a membership database.

> What I am trying to determine is the relationship between the three
> fields To:, CC: and BCC:. For example, if I were to send an email to
> 10 different email addresses, and I don't want the recipients to see
> all the email addresses of the other members, I would use the BCC:
> field.

> The question is - would I copy ALL 10 addresses to the BCC field and
> leave the To: field blank (which I don't think works) or do I copy one
> email address to the To: field and the other 9 to the BCC: field or do
> I copy a dummy email address to the To: field and use the BCC: field
> for all the 10 addresses. My tests so far seem to indicate that this
> option does work (except that the email address in the To: field does
> not seem to receive an email, unless I did something wrong).

> What would be the correct procedure in this situation?

> Also, is there any limit on the number of email addresses that can be
> copied to the BCC: field? I would need about 2000 at the most.

> TIA

> Peter Hibbs.
 
P

Peter Hibbs

Thanks Michael, that would seem a sensible solution.

Peter Hibbs.

On Thu, 14 May 2009 18:33:19 +0200, "Michael Bauer "

<mb@mvps.org> wrote:



> Put your own address into the To field and the 10 real recipients into BCC.
> The number of allowed addresses might be limited by your provider.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
pwatts2 Restrict some lists to only BCC send option Outlook Wishlist 2
B BCC issues after changing root folder path for gmail Using Outlook 1
M CC AND BCC Using Outlook 1
C Create new Message with shared contacts & BCC'ing recipients Outlook VBA and Custom Forms 0
N Outlook rules don't create a copy for bcc'ed emails Using Outlook 3
M Forward Appointment as BCC with VBScript Outlook VBA and Custom Forms 7
O Outlook on Android - add BCC Using Outlook 2
S Example VBA Macro - To Conditionally Change the From Account and Add a BCC Address on Emails Outlook VBA and Custom Forms 11
G Bcc help - Preventing multiple forwards from a bcc'd distribution group Using Outlook 1
J Will BCC messages still deliver if TO address fails Outlook 2013 Using Outlook 3
V Please help if you can. Problems with Bcc BCM (Business Contact Manager) 3
S BCC lists addressees Using Outlook 2
T bcc and Google imap Using Outlook 3
V Mark BCC when emails is sent from specific account Outlook VBA and Custom Forms 2
B Auto BCC VBA macro: how to add exceptions? Using Outlook 28
V using Bcc in Outlook.com 2013 Using Outlook 1
J Cc and Bcc not working Using Outlook 8
K received bcc as encrypted Using Outlook 12
V Contact group: addresses in BCC? Using Outlook 2
C a BCC script question Using Outlook 1
C BCC - How many email address will it accomodate? Using Outlook 2
P help me plase !!! outlook 2007 I can see mail Bcc Using Outlook 1
N How do you BCC Someone Using Outlook 1
S Automatically move recipients to BCC field Using Outlook 3
S Rule to Auto-forward/re-direct a specific incoming email to a group via BCC? Using Outlook 1
M Automatic Bcc Using Outlook 2
L automating a BCC on every email Using Outlook 1
M Create Rule to BCC email? Using Outlook 2
H show bcc field when viewing a sent message Using Outlook 15
williamlambton Customised To, CC, BCC and Have-replies-sent-to columns in message lists. Using Outlook 16
L Creating Custom Rule to Forward emails to a BCC Using Outlook 1
T display bcc field in sent emails Using Outlook 1
S Rule to move BCC email to a folder Using Outlook 6
A How to disable bcc option in GAL - Address Book - Exchange 2007 Exchange Server Administration 4
D BCC based upon TO address Outlook VBA and Custom Forms 1
G All contacts from Contact Folder to BCC by code Outlook VBA and Custom Forms 1
G Populate BCC field with all Contacts within a Contact Folder Outlook VBA and Custom Forms 4
S BCC How to? Outlook VBA and Custom Forms 1
R (Outlook2003)Monitor change for "to" "cc" "bcc" on message compose dialog? Outlook VBA and Custom Forms 6
R suppress BCC Outlook VBA and Custom Forms 1
R how to display Bcc if not available? Outlook VBA and Custom Forms 1
Y bcc macro Outlook VBA and Custom Forms 1

Similar threads

Top