emails generated in vba with attachments not being delivered

I use excel to generate a report and then attach it to an email that is sent to a list of recipients (each recipient gets a separate email). This email arrives at some recipients and not others.  All are shown in the "sent items" folders and there are no error, bounce, or spam messages.  Those who do not receive their email have checked spam, etc.  Only happens if there is an attachment and only with vba automation.  Any ideas?
LVL 1
apprescoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I would highly suspect the receiving end, especially if some do get them OK.

 First though, I would make sure your e-mail doesn't appear on any black lists.  You can use the tools at www.mxtoolbox.com to check.

 Then I would ask one of the users to check with their IT department and see if it was actually received or not.  Many companies strip off attachments or stop e-mails with attachments.

 What's the percentage by the way of those that don't receive them? and what format are you using; HTML or plain text?  Some users may not be setup to receive HTML.

Jim.
0
apprescoAuthor Commented:
Thanks.  Have done all that and even tried several send accounts; none are blacklisted at mxtoolbox.  Some recipients even receive on some days and not others; the attachment is a PDF almost exactly the same size every day.  This system worked for months until we moved off of gmail for business.  Must be something on my ISP's SMTP; they are checking.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< This system worked for months until we moved off of gmail for business.  >>

 Well that makes a difference<g>.

<<Must be something on my ISP's SMTP; they are checking. >>

 More than likely yes, but it seems odd that some would receive it one day and not the next.

 But just as a double check, does the SMTP tool at mx toolbox give you a clean bill of health, especially the reverse DNS?

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
apprescoAuthor Commented:
Just checking that now ... I think reverse DNS is the problem.  Thanks.
0
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.