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 www.YouTube.com/MCiTech #marksheet#marksheetdesign#marksheetgenerator