Are you saying that you cannot get the help file for FileList to work? You should be able to download it from www.jam-software.com/filelist.

Can you email me (legaltree "at" gmail) a screenshot of the error message so I can see it in more detail?

What is your email please? I don’t see it on website legaltree.

@@JorgePerez-n8v legaltree "at" gmail

@@MichaelDewTechTips ok, I sent it a few minutes ago.

See the link in the description

Not sure I know what you mean by "initial" email, but you can define the file name on the settings page. To access the settings page put the text "SettingsAdjust" on the clipboard and then open the Excel file. With that content on the clipboard the macro will take you to the settings page so that you can adjust the settings.

@@MichaelDewTechTips oh sorry. I mean the first email on an email thread. I have to rename .msg files based on the date and time of the first email on the thread (email.conversation)

@@karenschizo Sorry, but this tool can only rename files according to the date of the final email in the string, not the first email in the string.

@@MichaelDewTechTips thanks for the response

That is strange, my Windows 11 does not do that, but it gives regular paths when I "copy as path" from a list of search results in Windows 11. Is this a one off task you are trying to perform, or something you will need to repeat from time to time?

​@@MichaelDewTechTips I don't mean manually "copying as path" one of the results of the search, that's not what I'm trying to accomplish. I'd like your spreadsheet to automatically rename all files inside the subfolders of a folder, in addition to the files at the root of that folder. And I thought that what you wrote on your note was that we could copy the "path" we get in the address bar after we do a search. It's kind of a weird path starting with "search-ms:" and I thought you meant that such an address would work with your spreadsheet too. But maybe I misunderstood and you didn't mean that. Because yeah I'm trying to further automate this task by renaming the files of all the 50 subfolders inside the main "Email" folder. I'd rather avoid having to copy the path of each subfolder manually, run the spreadsheet, and so on for each of them every time. Right now I'm looking into making a PowerShell script that goes through all the subfolders of a folder and for each of them, copies the path to the clipboard, run the spreadsheet, and waits 2 seconds (for Excel to launch and finish the job before it increments the loop and does the next subfolder). But the most ideal would be for the code in your spreadsheet to include subfolders (if possible - you probably already tried). It would be a regular task, as part of keeping newly received emails backuped and sorted in different subfolders AND renamed with the date prepended so that I can sort by date inside every subfolder. I saw another way which is to make a script directly in Outlook that changes the subjects of the emails to prepend the date, so that when you save them as MSG they are already named the correct way. But your solution is more lightweight as you don't need to install that script on every Outlook that you use, you can just run it once and it will rename all the final data that always remain in one single place.

OK, I think I now know what you mean. You are correct that it will not work to copy the contents of the address bar after a search to the clipboard and then run the macro. Even in Windows 10 that will not work. I do have another spreadsheet that would do close to what (I think) you want (although it may need some work to do exactly what you want). Send me an email and set out the type of file name you want i.e. what formatting of date, time, etc.

@@MichaelDewTechTips Email sent!

Thanks! Self taught, LOTS of trial and error!

What part of it are you having trouble with? It does not work on macs, but should work on Windows computers. If you want you can email me your workbook and a form that you are having trouble with and I will take a look at it...

Not sure, but I think that is not possible with this tool, may need a more sophisticated photo metadata tool for that.

@@MichaelDewTechTips Thanks for the response, I used the exiftool to extract X Y info

That is possible, but would take a bit more coding, I will add it to the list but it might be a while...

@@MichaelDewTechTips Thank you for the quick reply. Again, very helpful work!

@@Essi2721 See v56 at the download link now - it has the ability to limit the "To" field to just one recipient, and also to include text of your choice (such as et al) after that first recipient name. Hopefully that works for you!?

No, sorry, that functionality is not included right now.

I have not experimented with that setup, but I believe it will send the email from the default email address, so if you can change the default such that any fresh email automatically gets sent from that default email address in outlook then I expect that should work. If you cannot set a default but have to "manually" select the email you are sending from each time a fresh email is composed the for sure it will NOT work.

No, sorry, I do not know that one.

Try adding System.Document.PageCount to the command, for sure it works to pull pdf file page counts, and may also work for some other file types, but obviously not for photograph files, etc.

I do not fully understand your question, but I am pretty sure the answer is "no", including because this spreadsheet does not include convert to pdf functionality. If you have Adobe Standard (or Pro) you can use macros to bulk convert a library of Word docs to pdf, but this spreadsheet does not do that.

No, sorry, not selling an unlocked version.

With the plain text version you can only attach one file to each email, but with the HTML version you can attach up to 30 unique files to each email.

Sorry, do not have a Mac version.

I think not, this is more for preparing ledgers and financial statements for a business than for tracking separate trust accounts. A different design would be best for the situation you describe.

I think the Jam software can only search by folder i.e. it pulls out data for all files in the folder (and its subfolders) irrespective of the dates of the files. After you get the full details of all files from the Jam Software report you could then screen for files with particular dates.

As noted on the buy page: "The sheets of the Workbook are not password protected or locked, and users may modify them as they see fit, but the Visual Basic Editor is locked." If you want a refund I can provide one.

I just hit the more button in comments, and you've listed all the commands and attributes as shown in the video!!!!! What a resource. I only wish I'd have this 30 years ago!

@MichaelDewTechTips thanks for responding quickly. How does the spreadsheet know that there's a new version?

@@MrManningata it does not know that there is a new version. The old file simply expires on a specified date (that date is built into the spreadsheet and is NOT retrieved in real time). In the future there will be a small cost for this spreadsheet (<$10) and the file will expire about once a year, and if the user still wants to use the tool they will go to the website and download a new one. The current spreadsheet does not know when there is a new version available for download, but only knows when it expires. Keep in mind as well that sometimes I put up new versions for download based on feature upgrades / bug fixes, and so there may be a new version available for download even though the old spreadsheet has not yet expired.

Hi michael. Thanks for this. How do i use/set the date and time of the initial email and include it on the file name