Sending email to BCC column returning undelivered

[teel73]

I am having the weirdest issue and I don't know if its related to MS Access or MS Outlook. Here's the simple scenario.

I have a sendEmail Function that works.. what I mean is the code sends the information from MS Access to Outlook and saves the item as a draft. That part works fine.

With olMailItem
.bodyFormat = olFormatHTML
.to
.bcc
.attachments.add(vattach)
.save
End With

Call Sendemail, rpttemplate,,getRDistroList

getRDistroList is a public function that loops thru a table of emails and makes a string for the bcc column in the outlook message. It is a string and it formats the email addresses correctly ie: "name@somedomain.com;name@someotherdomain.com"

When I go to my outlook Drafts to send the item, it sends but then I receive the following system undeliverable message:
"None of your e-mail accounts could send to this recipient."

But if I type the same email addresses into Outlook manually, the email sends without any issues.

I can't determine if this is an ms access issue or an outlook issue. Does anyone have any ideas as to what could be going on? Any help is greatly appreciated.

 

[Gasman]

You have to assign the string to the .BCC ?

.BCC = getRDistroList

Also the To if you intend using that.?

 

[teel73]

Thanks @Gasman for the quick response.
And yes, my function is assigned to the BCC column..

The email draft is saved perfectly. When I open it up, I see all the names accurately in the BCC column.

The issue is once I send the email. I receive an undeliverable that the email didn't deliver to any of the email addresses for the following reason:

"None of your e-mail accounts could send to this recipient."

But with that same email draft, if I delete the addresses from the bcc column and then add them back to the bcc column manually, the email sends and reaches the destinations. I don't get the undeliverable message.

Weird right?

It doesn't like when Access populates the To, cc or bcc columns for some reason and I don't know which end isnt cooperating, ms access or Outlook.

 

[CJ_London]

if I delete the addresses from the bcc column and then add them back to the bcc column manually, the email sends and reaches the destinations.

this implies your vba generated addresses are different, perhaps missing punctuation, hidden characters

 

[teel73]

Thank you all for your suggestions and help. I was not able to solve the mystery of why the email draft gets returned undeliverable.

However, when I changed the VBA from .Save to .Send the email sent successfully to the intended recipients. So with that being said, the function is working, but just not the way I would like for it to work.

 

[Mark_]

"name@somedomain.com;name@someotherdomain.com"

I am guessing you are formatting as

strEmailsToSend & ";" & T_Table.EmailAddress

Should have a space AFTER the semicolon. Ran into this with Outlook 2013. Seems that Outlook will choke without the space unless it is able to validate the address against its GAL (Global Address List) PRIOR to sending.

Due to office settings I haven't checked with .send, but using .display and pressing Send to quickly caused this problem.

Surprised a draft is having this issue though. Which version of Outlook do you have?