Thread: [Solved] Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line?
View Single Post
 
Old 03-13-2015, 02:35 PM
commissarmo commissarmo is offline Windows 8 Office 2013
Novice
  
Join Date: Mar 2015
Posts: 3
commissarmo is on a distinguished road
Default Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line?
Hi I have no experience with VBA. Office 2013

I have a task at work that is very tedious which I want to automate.

1. I use MailMerge to create say 400 pages of addressed letters.

2. I need to save EACH letter into a separate word document for each person, and then name the file automatically. (Using the first line to automatically name the file is ok, as I've already set it up that the first line of the document is the desired file naming format).

3. There IS I am quite sure, a way to do this. This link shows someone contributing code that seems to do just this.

http://answers.microsoft.com/en-us/o...0eb834a?page=3

4. Unfortunately, and perhaps it is because I am not using it correctly given my zero skill with macros, the code in that link DOES NOT work for me.

5. I'm hoping someone can help?

Thanks
Reply With Quote