I have a program that produces custom rtf files. These files are emailed and a copy is sent to a folder called "Emailed Documents"
The fileName is in this format:
Customer Lastname Customer Address Document Type ("Proposal").rtf or
Doe 1256 Oak Ave Invoice.rtf This works good so far. Now I want to expand on this and allow another "Invoice" to be sent and not overwrite the original, and have copies of both or maybe even 3 or more. So for the second Invoice it would be:
Doe 1256 Oak Ave Invoice[2].rtf
3rd invoice:
Doe 1256 Oak Ave Invoice[3].rtf
etc
This name appending would have to be done before emailing as to not send duplicate attachements. heres where i need help.
Pull all the files into a listbox and code against that or an array or ?
Then to determine how to search and append the file name. Split ?
Right ? Mid? or ?