Outlook error message using SendObject method

[Juan23]

Merry Christmas to all, hope you have a nice holiday!

I use the SendObject method to perform a periodic email to several email recipients. The email addresses are compiled through a loop statement, the message is created and an attachment is emailed.

The odd thing is, for one particular batch of recipients, I get the following error message from MS Outlook. But with all other batches of recipients, the email works great. I'm not sure if this is a Access problem or an Outlook problem.

So here is a code snippet;

Dim strReport As String
Dim strEmail As String
Dim strSubject As String
Dim strMessage As String

strReport = "RptScheduleMain_Project" 'name of report
strEmail = ProjectEmail(Me.ProjectID) 'function to compile a string of email addresses
strSubject = "Schedule"


strMessage = "Hello World "



DoCmd.SendObject acSendReport, strReport, acFormatPDF, strEmail, , , strSubject, strMessage, False


The snotty gram I get from Outlook is:
"Unknown message recipient; the message was not sent"

I can send email to these same folks without any problems. I can leave the strEmail string blank and input the email addresses manually without any problems.

Any thoughts/suggestions?

[boblarson]

Sounds like you need to debug what is being returned to strEmail and find what is causing the Unknown message recipient message.

Put a

Debug.Print strEmail

just after the line that sets it and then go to the Immediate Window after it fails and see what the string says.

[Juan23]

Bob. Your suggestion got me thinking. I carefully reviewed through all the email addresses in my table and found a "simple" syntax error in some of them. Obviously a fat-finger error.

Sometimes when you look at the same thing a million times you don't notice the little details.

Thanks ...........

[Glenn_Suggs]

I ran into the same error message with the SendObject method. However, I'm getting the email address from the "username" environment variable. Our company generally uses the logon ID as the first part of everyone's email address, but there are some users that get the error mentioned in this post. "Unknown message recipient; the message was not sent" Not only that, if two sendobjects are used one after the other, sometimes it sends to one person and when the second one tries to send a copy back to the sending user, it doesn't recognize the recipient that's logged on and actually trying to send the email. That's the one that comes from the environment variable. But I've tried hard-coding the recipient and bypassing the variable altogether and it still generates the same error. Can anyone please help with this problem? Thanks in advance.
Glenn