<div>
As it turns out I looked in Outlook at the email that Access was looking at didn't contain an attachment. &nbsp;I guess the first one in 7 years of using the application. &nbsp;Possibly not having an attachment triggered the out of bounds in that it was looking for one and none was there? &nbsp;Anyway, when I deleted the email without an attachment, everything started working again.
</div>


As it turns out I looked in Outlook at the email that Access was looking at didn't contain an attachment.  I guess the first one in 7 years of using the application.  Possibly not having an attachment triggered the out of bounds in that it was looking for one and none was there?  Anyway, when I deleted the email without an attachment, everything started working again.

<div>
<div class="content wysiwyg-content">
I have an Access application that we've been using for years. &nbsp;One of things it does is looks in an Outlook folder and pulls any new files that have been copied to the folder. &nbsp;Today we started getting an error &quot;Array index out of bounds&quot;. &nbsp;When I go to debug, it highlights the following line of code:<br />
<br />

<pre><code id="code-10-27729218-1">oMsg.Attachments.Item(1).SaveAsFile &quot;C:\Faxes\&quot; &amp; TheFileName</code></pre>
<br />
Any ideas of how to work around this?
</div>
</div>


I have an Access application that we've been using for years.  One of things it does is looks in an Outlook folder and pulls any new files that have been copied to the folder.  Today we started getting an error "Array index out of bounds".  When I go to debug, it highlights the following line of code:

(CODE)

Any ideas of how to work around this?

MS Access &quot;Array Index Out of Bounds&quot; Error

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

MS Access &quot;Array Index Out of Bounds&quot; Error

MS Access "Array Index Out of Bounds" Error