Automatic Marksheet creation in Ms word | using Excel

Hi friends, In this tutorial you can learn how to create automatic marksheet in ms word , using Excel sheet. This is a simple way design only one marksheet where you can automatic generate one to more marksheet design includes photo Follow given below these steps - -Enter your student mark details in excel sheet -After entering student details you must save it in your required place folder minimize the excel sheet open Word New document Design your marksheet After designing marksheet click Mailings in the menu bar Click select recipients Click use existing list Click to open -select data source -of excel sheet saving file Click Ok Click insert merge fields - remember you always insert excel merge fields Click finish & merge then click edit individual documents Click All or select required documents - click Ok -After clicking OK Display only text but not display photo - for displaying with photo Press CTRL and F9 enter- includepicture- space enter double quatation i mean inverted comma Then Insert Photo merge field display blank Press CTRL and A Press F9 Finally display with photo So friends I hope you like this video tutorial Thank You for watching For more Pls visit    / mcitech   #marksheet#marksheetdesign#marksheetgenerator