Help required - VBA Letter Generation tool

[vinu_april18]

Hi,

I am in the process of creating a excel based letter generation tool and with my limited knowledge of VBA I was able to work on something that creates a letter and saves the document with a file name in a specific folder. The challenge I am facing is that I am unable to create an option to create multiple letters at the sametime at a click of a button. I am unable to write a code which can create letters for all the employees in a sheet insted of just one and save each of them in a specific folder with the respective employee name as the file name.

Kindly help. Below mentioned is the code I am using:

Please Login or Register  to view this content.

[Pepe Le Mokko]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here