How to copy data from Excel to Word


I have an Excel Document (attached) where I have 2 tabs (Names and Songs)

I want to pull the data from Excel when I open Word with VBA.

I have a sample Word Document attached of how I want it to look, can someone please give me an example?
This will be a lot more complex after said and done, though I need a kick start and think I can handle it form there.

Note the names are on 3 separate pages and the songs are all on 1.

Computer GuyAsked:
Who is Participating?
It looks like a candidate for a couple of mail merges, one from the Names sheet and the other from Sheet1.

Here is a Mail Merge Main document for the Names part
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.