Using Mail Merge in Excel

Easy way using Mail Merge in Excel

Why mail merge ?
Mail merge is used to send same letter or information for different persons at a time
Mail merge is very useful and time saving for Excel users 

Here are the steps how to use Mail merge

i am using a data sheet to illustrate the mail merge process in excel 

above data sheet has the name address, cheque number amount and contact number etc,.

if your data is ready then easy to mail merge 

go to micro soft word program to do mail merge in the sense of making letter to different persons at a time. for the mail merge you have to maintain both excel and word files should be in same folders like this.

After ready of excel file start word file. then write letter. i have shown an example below

while typing letter use blank for address name and other factors which is ready in excel file.then go to mail merge option

select step by step mail merge wizard option shown in figure below

the wizard dialog box asks you to choose excel file from brows windows. then select the excel file from the same directory as before we stored by typing data. select sheets having data to mail merge .

then confirm the data and select ok from dialog box

then put cursor on the space given while typing letter then go to the insert field option 

then complete the insert field and then click the preview button 

you can confirm the fields are correct in preview option. then go to print option in right panel of mail merge option shown in figure below. 

print using giving range shown in figure below 

the mail merge is ready