Hi I'm currently working on a project where I have to transfer specific data from an excel spreadsheet (pivot table actually) into Word documents. Basically in the excel spreadsheet i have a column for the names of students, followed by another with the respective course they have chosen, and lastly the grades they have in each course. Is it possible to have a macro create a word document, name it with the student's name, and fill in a table in the Word document using data from the excel spreadsheet? I did some research and somebody suggested using bookmarks in Word as a sort of label to make sure data from excel goes exactly where you want it in word but I have no idea how it could be incorporated into a macro. I've only been using VBA for a short while and this sounds really really complicated. Kind of lost in the sea of programming language. Any help would be much appreciated! To make things simple, let the excel file be name be sourcefile.xlsm.