Utilizing Excel to Call Sheets to Prepare for a Mail Merge.
Using Microsoft Excel, it is possible to create a master sheet that pulls information from other sheets. This is especially useful when trying to do a mail merge in Microsoft Word. This “master sheet” will allow the mail merge to pull all the required information from one specific sheet. The document that is attached to the right was created using a pull command to create a master grade book for students. This was then exported via mail merge to a completed report card in Microsoft Word. To accomplish this “Master Sheet,” you will need to input the custom call command (=’Pagename’!Location). In the instance of the spreadsheet on the right, this command is =’Practice Log’!E8. This command will pull the data from cell E8 on the practice log page.