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