How do I get a folder's filename list into Excel?
The command to list files is dir followed by a 'mask'. The mask searches for filetypes. An asterisk in the mask means include any file. Therefore *.* would mean include any file and any extension. *.PDF means include only all PDF files. Since you are loading all files in the folder, you need a list of all files and we're going to send that listing to a text file so we can move the list to Excel.
Type dir *.* > WX_email_list.txt
You would use whatever name is appropriate.
We can now open this file in Excel