I did double-check for an empty value and there are none, but that's a good callout. When I create the recordset, I'll be sure to accommodate for that.
I'll try to restate:
I am building a database that our team uses to perform access reviews of certain applications. This is a version 2 of a database that I created last year, however I've learned a lot since then (including normalizing) and am rebuilding. In the process of the review, if we have managers who have not responded after a certain amount of time, we send an email to our boss as an escalation. In this escalation email, she wants to see the Managers' ID and include the spreadsheet we sent each manager, as well as our last email attempt. The paths to these two files are stored in a single-column table called "tblPaths" (original, right?).
My goal is to call each path from "tblPaths" into an array, that is then used to add each file as an attachment in an Outlook email. Yesterday @theDBguy helped me get to a point where this runs with one Manager, but when I tried to expand it to two Managers, I ran into all these issues.
I should note, when @theDBguy was helping me yesterday, I was not yet storing those paths in a table. Instead I was just building the path in VBA and assigning directly to the array (which was vArray = Array(path1, path2)).
I'll try to restate:
I am building a database that our team uses to perform access reviews of certain applications. This is a version 2 of a database that I created last year, however I've learned a lot since then (including normalizing) and am rebuilding. In the process of the review, if we have managers who have not responded after a certain amount of time, we send an email to our boss as an escalation. In this escalation email, she wants to see the Managers' ID and include the spreadsheet we sent each manager, as well as our last email attempt. The paths to these two files are stored in a single-column table called "tblPaths" (original, right?).
My goal is to call each path from "tblPaths" into an array, that is then used to add each file as an attachment in an Outlook email. Yesterday @theDBguy helped me get to a point where this runs with one Manager, but when I tried to expand it to two Managers, I ran into all these issues.
I should note, when @theDBguy was helping me yesterday, I was not yet storing those paths in a table. Instead I was just building the path in VBA and assigning directly to the array (which was vArray = Array(path1, path2)).