Good Morning/Afternoon/Night,
I'm looking to create a macro that will take data from Excel, copy it into a Word document (I have a template already made up), and then save the word document. I have multiple lines of data so I will need to create multiple word documents.
Here is an example of what I'd like the macro to do:
1. Open the Word template I have created
2. Copy the Data from excel to word: ie. Cell B2 in Excel will have a name, I need the name copied from excel and pasted into word about 10 spaces down after the text that says "Name". C2 data will say have an age, I need hte age copied from excel and pasted into word about 12 spaces down after the text that says "Age". Etc...
3. After all the data has been populated, I would like the document to be saved as a combination of two of the fields in that were populated in Word.
4. The Word document will then be closed.
5. Steps 1 through 4 are repeated with the next line of excel data.
I know this is pretty detailed but if someone could help me I'd greatly appreciate it!
Thanks in advance!
Bookmarks