Copy and Rename files in One Step?
by svanderlinden - 9/27/12 11:59 PM
As part of my job I have to take one document and save it 3 to 500 times with different nonsequential names. Then I have to repeat the process with a different file and different names. I am wondering if there is any way to copy and rename files in one step? I am a Windows 7 Home Premium user with Microsoft Office Professional 2010. I also have Adobe Professional 9.
I am a person who can use Word to create a document, but do not have the skill to make an index for the document by using the references tab in Word 2010. I do not know anything about building macros or coding, so I am going to give an example of what I have to do so someone can either direct me to a product to purchase or teach me how to use what I already have.
For example I have a file named "Invitation 2010" and I have a list of 34 people to send it to. However I have personalize the file by adding the person's first name to the name of the file so that I get 34 files with 34 unique names. If on the list I have a person named Amy then the file would be named "Amy's Invitation 2010."
After that I have a file named "RSVP 2010" and I have an Excel spreadsheet with 78 rows that include first names, last names, and number of people coming. I have to copy and rename "RSVP 2010" to include the last name and the number of people coming, but remove the 2010. The information in the spreadsheet would be Amy|Jones|4 (the "|" show the separate columns). The file name for this row of the spreadsheet would be "Jones RSVP 4."
In addition to doing this this month, I will have the exact same batch of names to process the same way next month, I will just be drawing the source documents (Invitation 2010 and RSVP 2010) from a different folder.
Please let me know if there is a a way I can use Microsoft Office to copy and rename the files in one step (once the function is created/set up); program out there that can duplicate and rename the files if I save the information the right way, or if I just have to plan to take several hours each month to copy and rename files.