Please help me write VBA code that will extract from excel to word in specific spots in the word document. The macro should consist of a two loops The first one will go from each column and paste data in designated areas. The next one will loop through the distribution list and make a document for each person saving with there name as the document nameexcel to word.xlsExcel to word.doc. Never worked with word macros so any help will be greatly appreciated!
Bookmarks