Solved

emails generated in vba with attachments not being delivered

Posted on 2014-07-28
6
102 Views
Last Modified: 2014-11-16
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?
0
Comment
Question by:appresco
  • 2
  • 2
6 Comments
 
LVL 57
ID: 40224424
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
 
LVL 1

Author Comment

by:appresco
ID: 40224514
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
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40224615
<< 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
 
LVL 1

Author Comment

by:appresco
ID: 40224630
Just checking that now ... I think reverse DNS is the problem.  Thanks.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40445496
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
In this step by step procedure, you will come to know the details of creating an Outlook meeting in 2007, 2010, 2013 & 2016.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question