Populate existing word form with excel- multiple fields

Palms

New Member
Joined
Jul 1, 2017
Messages
1
Hi,
I have search hi and low on the internet and this site but cant seem to get exactly what i am after.
So hoping someone can point me in the right direction or assist.

1. Have an existing word doc which is quite busy with required information.Consists of 10 participants per enrollment sheet
Some of this information is basic personal data for student registration but to the right of their personal information is administration details to be completed at a later time.

2. Same student information is now being collected in an excel sheet

3. I want to partially populate the word doc (personal details) with the excel sheet, print off then complete remainder by hand(requirement)
4. Tried mail merge by manually creating multiple bookmarks but data wont continue on the form as per the excel sheet

I am only self taught & you tube with excel, so would appreciate if someone can help
Thanks
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,216,185
Messages
6,129,383
Members
449,506
Latest member
nomvula

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top