The way you describe it, needs programming. Learn to use VBA (Visual Basic for Applications) - including the Word and Excel methods and write those macro's. If you don't want to spend the several days (or even weeks, if you're a real programming novice) and can't find anyone to do it for you (for whatever pay you can give him or her) you'll have to continue the way you do.
But if you are willing to change the requirements there's a way. You shouldn't send personalised files (because then as you noted, you must make them each). You should make personalised messages. That can easily be done in MS Word, using a feature called "mailmerge".
Just yesterday, another member noted a success in http://forums.cnet.com/7723-6129_102-574343/linking-access-db-to-contract-in-msw/?messageId=5366617#message5366617
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.