Problem with Outlook and vba instruction

May 19, 2020 at 11:09:16
Specs: Windows10
Hi Guys,
I have two problems occurring with the following scenario

I have a VBA that sends an email to a list of email addresses. Each email is unique to each address, that is , only sends the information required for the recipient

Before I initiate the vba, I open Outlook. The list comprises of 26 email addresses

I create a title for the email, a body of text, and attach 2 - 6 pdf files, two of which associate with the email address, the other pdf's are common to all recipients

Problem 1; the sent list in Outlook shows that the e-mails are being sent twice, this has only just started happening over the last 4 - 6 weeks, but the recipient only receives 1 email

Problem 2; the same four email addresses are failing and Outlook is giving me the following
554 6.6.0 Error sending message. These four addresses fall midway through the list of addresses

This has only happened the last two times I have initiated the vba

Any ideas as to why this could be occurring

Regards
Tony

PS Hope everyone is ok


See More: Problem with Outlook and vba instruction

Reply ↓  Report •

#1
May 19, 2020 at 11:11:56
Sorry, forgot to add that the VBA and sending of the emails vis Outlook has been working fine for the last 2 1/2 - 3 years with no problems at all. This has only recently started to happen

Reply ↓  Report •

#2
May 20, 2020 at 04:29:54
Have you Googled that Outlook error code? There are many sites that discuss various 554 error codes, some of which mention the receiving server rejecting the email based on the server's spam rules. Since it's always the same 4 email addresses perhaps they have something in common on the receiving server side.

As far as the "multiple sends" have you single stepped though the code to see if you can tell when the second Send notice shows up?

Obviously it's tough for us to actually troubleshoot the issue since we don't have access to your environment.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question