Afternoon all,
I have an excel template which emails PDF documents found in a directory to the relevant email addresses. I am trying to add some code into the macro which will also move all the sent files to a new folder called "Sent".
The amount off attachments in each email will vary.
I currently use the below code which only sort of works:
The issue I have is that I may have 20 files that are named something like ACC109 - ????? and I would need it to move every file which has ACC109 -, the code I currently use only moves the first one and then moves on to the next "b" which may be file names like ACC110 - ???? etc.
Hope that makes sense?
I feel like there is a simple solution such as a "do while sourcefilename > 0" or something like that but unfortunately im not quite at that stage in my development yet.
Thanks in advance
Dan
Bookmarks