".send" command creates an error on one computer but not another

[Bobbbo]

I have VBA code that has been working flawlessly for year. Now all of a sudden I am getting an error:
send error code.PNG
Run-Time error '-2147467259 (80004005)':

Outlook does not recognize one or more names.

When I select debug, .send is highlighted. I put the same workbook on another computer and everything runs fine with no errors.

Please Login or Register  to view this content.

Any Ideas!!!

EDIT: I found a solution that does not make sense, but it works. By simply adding .Display a line before .Send the VBA code does not fail. I was thinking it might be a speed issue where the VBA code is runing too fast. So I added a delay statement just before the .Send. I added: Application.Wait Now + TimeSerial(0, 0, 5) which delays the running of the VBA code by 5 seconds. But it still fails when it reaches .Send. The one thing I find interesting is that I use the .Send command about 3 times to send emails to specific people, but they don't fail.

I don't feel comfortable with the .Display command fixing the issue. Any one know why that works.

[Lastejp]

Does the other computer have Outlook (I would think so) and an account that is logged in?

[Bobbbo]

Does the other computer have Outlook (I would think so) and an account that is logged in?

Yes they are identical Outlook accounts. I also have looked into the two Outlook setting to make sure they are the same and they are.

[Lastejp]

What is "logo"?

May need to see more of that code to get a better idea of what may be happening. Perhaps you are accessing something that is specific to a ...AppData\Roaming\... file

[Bobbbo]

logo is a graphic on the email. I commented that line of code out as well as the attachments and it still fails. The complete VBA code is thousands of line long.

[Artik]

Do cells Q59 and Q60 contain email addresses, such as [email protected], or display names, such as "John Doe". If the latter, you probably don't have that addressee in your contacts.

Artik

[Bobbbo]

Artik, Those cells are full email addresses like [email protected].

[Lastejp]

Just a thought. I always put the following code in before sending:

Please Login or Register  to view this content.

You might also put in

Please Login or Register  to view this content.

and stop there to see the email before sending...

[Bobbbo]

Just a thought. I always put the following code in before sending:

Please Login or Register  to view this content.

You might also put in

Please Login or Register  to view this content.

and stop there to see the email before sending...

Thanks Lastejp. I tried adding the .Display before the .Send before you responded and it worked. I edited my original question. Why does this work?

[Lastejp]

I think it's a matter of timing. The VBA code is trying to send the email before Outlook has resolved the addresses. That's why I always use .Recipients.ResolveAll and DoEvents first