I am going to be needing to learn how to effectivly mail merge two letters and an e-mail. The letters will have certain unique things like "Degree" "Name of person" and so-on. So far all I know for certain is that I'm going to have to use an excel sheet which i will be provided with. What I need to know is this:



how do i make it to where the mail merge will look through the excel sheet and through certain columns for each row, see the information there, then change the one piece from Microsoft word. An example would be:

Hello (NAME),

You are able to recieve the degree of (DEGREE).

the parenthesis need to be changed to what ever is in the certain data cell from excel. Thanks!