?
Solved

emails generated in vba with attachments not being delivered

Posted on 2014-07-28
6
Medium Priority
?
106 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 58
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 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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 49

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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

752 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