Thanks for this, this is fantastic. Btw, my help file from Jam Software doesn't show any info in the RH pane. Microsoft offers some assistance on other categories to search for- but is there anywhere else I can get a similar list please?
@MichaelDewTechTips3 күн бұрын
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.
@JorgePerez-n8v8 күн бұрын
Hi, i have a problem, When I open the file I get an execution error message "5" it gives me the. Do you have a solution for that?
@MichaelDewTechTips8 күн бұрын
Can you email me (legaltree "at" gmail) a screenshot of the error message so I can see it in more detail?
@JorgePerez-n8v7 күн бұрын
What is your email please? I don’t see it on website legaltree.
@MichaelDewTechTips7 күн бұрын
@@JorgePerez-n8v legaltree "at" gmail
@JorgePerez-n8v6 күн бұрын
@@MichaelDewTechTips ok, I sent it a few minutes ago.
@JorgePerez-n8v9 күн бұрын
Can you correct the error? Error 5 has occurred at execution time
@sd483711 күн бұрын
How do I get this ?
@MichaelDewTechTips11 күн бұрын
See the link in the description
@karenschizo20 күн бұрын
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
@MichaelDewTechTips20 күн бұрын
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.
@karenschizo20 күн бұрын
@@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)
@MichaelDewTechTips20 күн бұрын
@@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.
@karenschizo20 күн бұрын
@@MichaelDewTechTips thanks for the response
@Makenshi179Ай бұрын
Thank you so much for this! So useful and lightweight! I have one question: I want to make it rename all the files in subfolders too. I've read your note about subfolders and how we can use the Windows Search, however when I copy the path of the search results (that starts with "search-ms:" and then a lot of parameters), your spreadsheet doesn't recognize it as a valid path. So it doesn't work. Maybe it's because they changed the way Windows Search works in Windows 11? Would you happen to know of any solution to this?
@MichaelDewTechTipsАй бұрын
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?
@Makenshi179Ай бұрын
@@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.
@MichaelDewTechTipsАй бұрын
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.
@Makenshi179Ай бұрын
@@MichaelDewTechTips Email sent!
@tomjun8945Ай бұрын
Hi Michael, thank you for the wonderful demonstration. I am curious how you get so good at this ? This has to take a lot of time to learn right? Did you go to school for this or take any certifications?
@MichaelDewTechTipsАй бұрын
Thanks! Self taught, LOTS of trial and error!
@tomjun8945Ай бұрын
You videos are amazing. You are a great teacher and your explanation is on point. Thank you so much.
@Emporium.PresentsАй бұрын
Dangit this doesn't work :(
@MichaelDewTechTipsАй бұрын
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...
@lizmonard2 ай бұрын
1:20 O
@jakehansen6052 ай бұрын
does anyone know what the attribute codes are for pulling photo latitude and longitude? Thanks
@MichaelDewTechTips2 ай бұрын
Not sure, but I think that is not possible with this tool, may need a more sophisticated photo metadata tool for that.
@jakehansen6052 ай бұрын
@@MichaelDewTechTips Thanks for the response, I used the exiftool to extract X Y info
@valentinalammey39553 ай бұрын
This is great, thank you
@A_A783 ай бұрын
thank you very much for this video 💖. it helps me a lot.
@Essi27213 ай бұрын
Thank you for the time and effort put into this ! I was wondering if there was a way to limit in the output name to only include the first recipient. For instance I would like to turn "2020-01-01 John Smith to Jane Doe, John Doe, Jane Smith (object)" to "2020-01-01 John Smith to Jane Doe (object)" or even better "2020-01-01 John Smith to Jane Smith et al (object)"
@MichaelDewTechTips3 ай бұрын
That is possible, but would take a bit more coding, I will add it to the list but it might be a while...
@Essi27213 ай бұрын
@@MichaelDewTechTips Thank you for the quick reply. Again, very helpful work!
@MichaelDewTechTips3 ай бұрын
@@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!?
@80211Denver3 ай бұрын
perfect, thanks. I definitely find new teams to be stable, annoyed with saying "yes, I really want to keep using this!" each time.
@marcojacott3 ай бұрын
Hi Michael, Thanks so much! Its a great tool. I just started using it and I was wondering if instead using the year romat YYYY can be changed to YY? Much appreciated!
@MichaelDewTechTips3 ай бұрын
No, sorry, that functionality is not included right now.
@JolanXBL4 ай бұрын
First thing is to uninstall teams second install anything other than teams. Vcad online college use it for classes and you could not watch the instructors video without chopping let alone following along in the software at the same time
@Mentagor4 ай бұрын
I have a couple of E-mail adresses in my outlook ( 1 private and 2 for business ), can I choose what "from" adress that e-mail is sendt from?
@MichaelDewTechTips4 ай бұрын
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.
@ritusarkar92344 ай бұрын
Thank you so much. I actually used this to fill out multiple forms for non-mailing purposes and it works!
@keithkeith21065 ай бұрын
Hi, thank you for the video really good. I have an Excel form that I use for each client relationship and it contains data and calculations that need to be put on a form and the form needs to be emailed as a manual process. Any suggestions on who I could get to help me get this work flow built?
@KQCNT5 ай бұрын
Im trying to add Frame Width since "System.Image.HorizontalSize" has no info in my video files. Do you know what would be the correct "system" code?
@MichaelDewTechTips5 ай бұрын
No, sorry, I do not know that one.
@HitMeWUrBestShot5 ай бұрын
Digr
@Melkhalifaaa6 ай бұрын
Hmm would adding the page count per file possible?
@MichaelDewTechTips5 ай бұрын
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.
@halloweenpot6 ай бұрын
is there a way I can create a button that generates a PDF file for each word template individually and in this way, I can create multiple files in one go?
@MichaelDewTechTips6 ай бұрын
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.
@christopherwong61746 ай бұрын
THANK YOU!! I've wanted this tool for my music files for years. THANK YOU!! Excellent tutorial and information.
@niktanaka77766 ай бұрын
Thank you so much!!
@meljoshua7 ай бұрын
Hi, I bought a copy of the spreadsheet and would be interested to pay for the unlock version with VBA. Are you offering such an option?
@MichaelDewTechTips7 ай бұрын
No, sorry, not selling an unlocked version.
@fennho7 ай бұрын
This is a life saver. But can I request for a multiple attachment function? I am trying to send out pdf attachments (event tickets) to 600 people
@MichaelDewTechTips7 ай бұрын
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.
@dinkytwist7 ай бұрын
Hi Michael - I'm a late comer to your excellent video on getting the meta data - It works perfectly. However I would really like the location data too if possible. Its 4 years on from your Video and I want to sort in Excel by date (thank you) but also by location. Do you know how to do that please? Even ChatGPT4 cant help!
@user-yu6mi1mw1v7 ай бұрын
Do you have a Mac compatible version?
@MichaelDewTechTips7 ай бұрын
Sorry, do not have a Mac version.
@Jogesh657 ай бұрын
Hi Michael, would this work to track and report trust accounts for clients funds in a law office.
@MichaelDewTechTips7 ай бұрын
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.
@HamingtonT8 ай бұрын
Thank you this was helpful Sir
@Wipeout28068 ай бұрын
Outstanding
@LS567898 ай бұрын
Thank you! This is so useful.
@selectionbreakdown70248 ай бұрын
Dear Sir How about creating a list of files based on the date modified? Just search for files modified in the year 2022.
@MichaelDewTechTips8 ай бұрын
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.
@ShamADCLoL8 ай бұрын
i have paid to buy the worksheet, however there is still a VBA password. Could you please share?
@MichaelDewTechTips8 ай бұрын
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.
@dasansasse53189 ай бұрын
Does the "Sheet Nav & Table Data " sheet store large lists of clientele? This information would be very helpful
@latvijasfarmaceitubiedriba68649 ай бұрын
Hello, Michael! Could it be that the code is incompatible with my system because we're running older versions of MS Office and Outlook (13)? It seemed to be working on my personal computer as far as i can tell, but the office one with the version 13 says it's not able to run it
@reddlief9 ай бұрын
Michael I have a question and great videos by the way. Excel and even file attributes are different country to country. For instance, European date configuration is D/M whereas my country (USA) is M/D...I've only watched 2 of your files that hit my problem square on, so I apologize if this comes up in your library of videos that I will finish watching!
@reddlief9 ай бұрын
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!
@reddlief9 ай бұрын
I've been using search and replace, but your keyboard shortcuts will save me time and make my end product more accurate! I'm checking this 6 yrs from original and will try on Windows 11 and MS Office 365 to see if it's still current. I've saved and will thank you later!
@blaizex10 ай бұрын
Shift right click doesn't work for me, but this reg-file makes the copy-as-path permanently to the right-click-dialog: Windows Registry Editor Version 5.00 ;Show Copy as Path always in the right-click menu, without pressing SHIFT [HKEY_CLASSES_ROOT\Allfilesystemobjects\shell\windows.copyaspath] @="Copy &as path" "Icon"="imageres.dll,-5302" "InvokeCommandOnSelection"=dword:00000001 "VerbHandler"="{f3d06e7c-1e45-4a26-847e-f9fcdee59be0}" "VerbName"="copyaspath"
@WGSBFunny10 ай бұрын
Hi, how do I unlock the old pro forma now that the excel is behind a pay wall?
@blrsub10 ай бұрын
Thanks Mike for the useful video. What is the code for the file attribute "Comments"?
@VincentMcmanus.10 ай бұрын
I'm having a really rough time with this. I'm trying to get it to output a list of file name, directors, but it's hanging up. I'm using the command like this: FileList.exe /USECOLUMNS System.ItemNameDisplay,System.Media.Year,System.Media.Directors All I get is a response of: 2023-10-15T17:31:23 -- ERRR [] Unknown Column: System.Media.Directors. 2023-10-15T17:31:23 -- ERRR [] Error 3: The system cannot find the path specified: System.ItemNameDisplay,System.Media.Year,System.Media.Directors Can anyone help me figure out what I need to enter for the directors column? I've also tried system.media.director, system.origin.director, and system.origin.directors. None work.
@MrManningata10 ай бұрын
Thanks for this. I enjoyed using it for a while. I don't like that I was using an older version (44) and since there have been newer versions, I cannot use the original spreadsheet, or even copy the settings I had saved with it. I tried to disable the macros/VBA so I could grab the settings, but the menu has been password protected and I can't actually see what it is doing under the hood - very unusual choice and make me slightly suspicious of this tool. Is it contacting some outside source for this information?
@MrManningata10 ай бұрын
@MichaelDewTechTips thanks for responding quickly. How does the spreadsheet know that there's a new version?
@MichaelDewTechTips10 ай бұрын
@@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.
@karenschizo20 күн бұрын
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
@fredsmith742210 ай бұрын
Michael, I am not able to turn on the "Outlook Object Library" because the references tab under tools is greyed out. Could you please advise? I have enabled macros, and taken it off of protected view. Thank you
@ravisaradowden939910 ай бұрын
I get a [DataFormat.Error] The file name 'xxx' is longer than the system-defined maximum length. How can I work around this?
@SomethingCatchy9910 ай бұрын
Thank you for this amazing spreadsheet. I now get an error message indicating it's gone past some kind of expiry date. Is there a way to purchase it from you (pay a licence fee etc.)?