Access sending emails to exchange Server
Posted on 2014-11-30
I have developed an app which is used to create Reports in Word 2010 and then when the report is completed it can then be sent to the email sever either by the user select different Groups and/or users. With speacial reports (eg; Accident reports) the user has no choice as to who to email these reports are emailed to. They are automatically sent to predefined groups as determined by management. So far this app has created and emailed over 70k reports with no major hiccups. I have 120 users on the system, 73 different types of reports and 51 different email groups and users that are defined for this system. This system has been in place for 5+ years and has been stable, Until now.
I have created a new template (Word 2010) and the process of creating the report ready to be emailed off works fine. This report is to be automatically emailed and is waiting to be emailed as normal. when the User clicks on the email button the Report disappears from the screen and a success message is returned by the email sever. The problem is that the email and attachment never gets to the users listed in the predefined group. If I change the group_ID to any other predefined group in the system, the email & attachment goes through to the users intended.
Any Ideas will be of great help