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

Ok basically I solved this problem.

I didn't learn how to use a Macro to do it... but someone basically wrote an entire Word Add-on that does all of this for you automatically with a lot of good features too.

http://www.gmayor.com/individual_merge_letters.htm

I recommend just using this. I tried it and its great. The instructions are QUITE tedious and hard to follow, but make sure you just slog through it top to bottom before installing it. You don't need to go into the Word Startup folder apparently despite what the instructions say - the program has a self-extracting installer which auto installs itself. MAKE SURE WORD IS CLOSED BEFORE INSTALLING OR IT WON'T WORK.

Learning to write Macros is cool but... given this person did so much work on this free addon, I'm just going to use this. I recommend donating to him if you use it. It should come built in to Word at this point in time of the program's history.

Ok basically I solved this problem.

I didn't learn how to use a Macro to do it... but someone basically wrote an entire Word Add-on that does all of this for you automatically with a lot of good features too.

http://www.gmayor.com/individual_merge_letters.htm

I recommend just using this. I tried it and its great. The instructions are QUITE tedious and hard to follow, but make sure you just slog through it top to bottom before installing it. You don't need to go into the Word Startup folder apparently despite what the instructions say - the program has a self-extracting installer which auto installs itself. MAKE SURE WORD IS CLOSED BEFORE INSTALLING OR IT WON'T WORK.

Learning to write Macros is cool but... given this person did so much work on this free addon, I'm just going to use this. I recommend donating to him if you use it. It should come built in to Word at this point in time of the program's history.

Thanks for the plug.

The add-in is supplied in two forms - a self extracting zip file and the bare template. Some users prefer manual installation so this allows that option.

As for the instructions. This is a complex add-in with lots of features that required documenting. If you think that tedious, just wait until you try http://www.gmayor.com/ManyToOne.htm. Now that IS complicated.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com