Hi guys,

I'm a beginner with using mail merge.
I want to start mail merge data from Excel to MS word. I have to create or produce a letter for each record/ name. On top of that I need to create or insert a table format for each record/name. I have been searching for ages already and come across different tutorials from gmayorlinks,msoffice tutorials but couldn't fully grasp it. Hard for me to understand. Does anyone have a simple explanation or simple code i could follow? Also, anyone knows how to insert tables when doing mail merge but the rows are not fixed. It will depend on how many brother's the client has.

Need Advice please.
Much appreciated!

Example



in Excel format

first name Surname brother 1 age1 brother 2 age2 brother 3 age3
Jane Smith Sarah 18 Carlo 25 Christ in 28
Alex Curtis Cameron 37
Ben Arandt Tim 40 Simon 45

OUTPUT in Word

Client Name: Jane Smith

Brother's name | brother's Age
Sarah 18
carlo 25
Christin 28


* new page or new latter

Client Name: Alex Curtis

Brother's name | brother's Age
cameron 37