Bcc problem

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Using Outlook 2002 the following code is used to add recipients email
address's to a email sent from an Access application

For lngCurrentRow = 0 To lstCC.ListCount - 1
If lngCurrentRow = 0 Then
strCC = lstCC.Column(0, lngCurrentRow)
Else
strCC = strCC & ";" & lstCC.Column(0, lngCurrentRow)
End If

Next lngCurrentRow

For lngCurrentRow = 0 To lstBCC.ListCount - 1
If lngCurrentRow = 0 Then
strBCC = lstBCC.Column(0, lngCurrentRow)
Else
strBCC = strBCC & ";" & lstTo.Column(0, lngCurrentRow)
End If

Next lngCurrentRow

What we are finding is that all address's sent as CC are reciving the email
being sent yet only the 1st address in the BCC is receiving the mail

Any advice whay and how to overcome this problem would be appreciated

TIA

Tom
 
I'd take a look at the actual value of strCC when it's finally compiled.

Also, the Bcc recipients' antispam filters could be blocking the message because it's not sent directly to them.
 
Hi Tom,
strBCC = lstBCC.Column(0, lngCurrentRow)
Else
strBCC = strBCC & ";" & lstTo.Column(0, lngCurrentRow)
Click to expand...

maybe lstTo isn´t the control you´re expecting?
 
Thank you Sue and Michael for your valuable input

Michaels observation of

strBCC = strBCC & ";" & lstTo.Column(0, lngCurrentRow)

was spot on. Once changed to:

strBCC = strBCC & ";" & lstBCC.Column(0, lngCurrentRow)

a msgbox for strBCC shows all the BCC address's whilst prviously, as per
Sue's suggestion it only showed the first email address followed by semi
colons.

Thanks again

Tom
 
Back
Top